sstableexpiredblockers
During compaction, the database can drop entire SSTables when they contain only expired tombstones and if it is guaranteed to not cover any data in other SSTables. This diagnostic tool outputs all SSTables that are blocking other SSTables from being dropped.
Usage:
sstableexpiredblockers [--dry-run] keyspace tableTarball and Installer No-Services path:
<installation_location>/resources/cassandra/tools/binProcedure
Choose a keyspace and table to check for any SSTables that are blocking the specified table from dropping.
sstableexpiredblockers cycling cyclist_name