nodetool garbagecollect
Removes deleted data from one or more tables.
|
The nodetool garbagecollect command is not the same as the Perform GC option in OpsCenter. |
Synopsis
nodetool [<connection_options>] garbagecollect
[-g ROW|CELL] [-j <job_threads>] [--]
[<keyspace_name> <table_name> [<table_name> ...]]Definition
The short- and long-form options are comma-separated.
Connection options
- -h, --host hostname
-
The hostname or IP address of a remote node or nodes. When omitted, the default is the local machine.
- -p, --port jmx_port
-
The JMX port number.
- -pw, --password jmxpassword
-
The JMX password for authenticating with secure JMX. If a password is not provided, you are prompted to enter one.
- -pwf, --password-file jmx_password_filepath
-
The filepath to the file that stores JMX authentication credentials.
- -u, --username jmx_username
-
The username for authenticating with secure JMX.
Command arguments
---
Separates an option from an argument that could be mistaken for an option.
- -g, --granularity ROW|CELL
-
ROW (default) removes deleted partitions and rows.
CELL also removes overwritten or deleted cells.
- -j, --jobs num_jobs
-
-
num_jobs - Number of SSTables affected simultaneously. Default: 2.
-
0 - Use all available compaction threads.
-
- keyspace_name
-
The keyspace name.
- table_name
-
One or more table names, separated by a space.
Examples
To remove deleted data from all tables and keyspaces at the default granularity
nodetool garbagecollectTo remove deleted data from all tables and keyspaces, including overwritten or deleted cells
nodetool garbagecollect -g CELL