nodetool setcompactionthreshold
Sets minimum and maximum compaction thresholds for a table.
Sets minimum and maximum compaction thresholds for a table.
Synopsis
C:\> %CASSANDRA_HOME%\bin\nodetool <options> setcompactionthreshold -- <keyspace> <table> <minthreshold> <maxthreshold>
| Short | Long | Description |
|---|---|---|
-h |
--host |
Hostname or IP address. |
-p |
--port |
Port number. |
-pwf |
--password-file |
Password file path. |
-pw |
--password |
Password. |
-u |
--username |
Remote JMX agent username. |
| keyspace | Name of a keyspace. | |
| table | Name of a table. | |
| minthreshold | Sets the minimum number of SSTables to trigger a minor compaction when using SizeTieredCompactionStrategy or DateTieredCompactionStrategy. | |
| maxthreshold | Sets the maximum number of SSTables to allow in a minor compaction when using SizeTieredCompactionStrategy or DateTieredCompactionStrategy. | |
-- |
Separates an option from an argument that could be mistaken for a option. | |
Description
This parameter controls how many SSTables of a similar size must be present before a minor compaction is scheduled. 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 http://wiki.apache.org/cassandra/MemtableSSTable.When using LeveledCompactionStrategy, maxthreshold sets the MAX_COMPACTING_L0, which limits the number of L0 SSTables that are compacted concurrently to avoid wasting memory or running out of memory when compacting highly overlapping SSTables.
CASSANDRA_HOME
On a standard Windows installation, the installation wizard creates
%CASSANDRA_HOME% as an environment variable.
| Windows 3.0 installations | C:\Program Files\Datastax Community\apache-cassandra\ |
| Windows 3.x installations | C:\Program Files\Datastax-DDC\apache-cassandra\ |