Scylla University Live | Nov 9 (AMERICAS), Nov 10 (EMEA and APAC) Free Virtual Training Event
Learn More

Nodetool compact


It is always best to allow Scylla to automatically run minor compactions using a compaction strategy. Using Nodetool to run compaction can quickly exhaust all resources, increase operational costs, and take up valuable disk space. For this reason, major compactions should be avoided and are not recommended for any production system.

compact [<keyspace> <cfnames>...]- Forces a (major) compaction on one or more tables. Compaction is an optimization that reduces the cost of IO and CPU over time by merging rows in the background. By default, major compaction runs on all the keyspaces and tables. Major compactions will take all the SSTables for a column family and merge them into a single SSTable per shard. If a keyspace is provided, the compaction will run on all of the tables within that keyspace. If one or more tables are provided as command-line arguments, the compaction will run on all tables.

For Example:

nodetool compact
nodetool compact keyspace1
nodetool compact standard1