sstableexpiredblockers
Outputs the SSTables that prevent an SSTable from dropping.
Identify the SSTables that are blocking dropping of entire SSTables during compaction. SSTables are dropped during compaction only when they contain only expired tombstones and are guaranteed not to cover any data in other SSTables.
Restriction: Stop HCD before you run this command.
The default location of this SSTable tool depends on the type of installation:
-
Package installations:
/usr/bin/ -
Tarball installations:
<installation_location>/resources/cassandra/tools/bin
Synopsis
sstableexpiredblockers
[--dry-run]
<keyspace_name> <table_name>The short form and long form parameters are comma-separated.
Command arguments
- --dry-run
-
Test command syntax and environment. Do not execute the command.
- keyspace_name
-
Keyspace name. Required.
- table_name
-
Table name. Required.
Examples
Output the blocking SSTables that prevent an SSTable from dropping
sstableexpiredblockers cycling cyclist_racesTest the output without executing sstableexpiredblockers
sstableexpiredblockers --dry-run cycling cyclist_races