nodetool setcompactionthreshold
Sets minimum and maximum compaction thresholds for a table.
SSTables are compacted concurrently to avoid wasting memory or running out of memory when compacting highly overlapping SSTables.
|
The max_threshold table property sets an upper bound on the number of SSTables that may be compacted in a single minor compaction, as described in How is data updated?. |
Synopsis
nodetool [<connection_options>] setcompactionthreshold
[--] <keyspace_name> <table_name> <minthreshold> <maxthreshold>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.
- keyspace_name
-
The keyspace name.
- maxthreshold
-
Resets or overrides internal setting of 32. How many SSTables of a similar size must be present before a minor compaction is scheduled.
- minthreshold
-
Minimum threshold.
- table_name
-
The table name.
Examples
Set minimum compaction throttling
nodetool setcompactionthreshold cycling comments 6 28