Scylla University Live | July 28 & 29 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

See Also

Nodetool Reference

Compaction Overview

CQL compaction Reference

How to choose a Compaction Strategy