sstableexpiredblockers

The sstableexpiredblockers utility will reveal blocking SSTables that prevent an SSTable from dropping.

During compaction, Cassandra can drop entire SSTables if 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:

C:\> cd %CASSANDRA_HOME%
C:\> sstableexpiredblockers [--dry-run] keyspace table

Procedure

Choose a keyspace and table to check for any SSTables that are blocking the specified table from dropping.

C:\> %CASSANDRA_HOME%\tools\bin\sstableexpiredblockers cycling cyclist_name

What's next

CASSANDRA_HOME

Windows 3.0 installations	C:\Program Files\Datastax Community\apache-cassandra\
Windows 3.x installations	C:\Program Files\Datastax-DDC\apache-cassandra\

On a standard Windows installation, the installation wizard creates %CASSANDRA_HOME% as an environment variable.

DataStax, Titan, and TitanDB are registered trademark of DataStax, Inc. and its subsidiaries in the United States and/or other countries.

Apache Cassandra, Apache, Tomcat, Lucene, Solr, Hadoop, Spark, TinkerPop, and Cassandra are trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries.