sstableofflinerelevel 

The sstableofflinerelevel utility will relevel SSTables.

This tool is intended to run in an offline fashion. When using the LevelledCompactionStrategy, it is possible for the number of SSTables in level L0 to become excessively large, resulting in read latency degrading. This is often the case when atypical write load is experienced (eg. bulk import of data, node bootstrapping). This tool will relevel the SSTables in an optimal fashion. The --dry run flag can be used to run in test mode and examine the tools results.

Usage:
  • DataStax Enterprise 5.0 Installer Services and package installations:
    $ sstableofflinerelevel [--dry-run] keyspace table
  • DataStax Enterprise 5.0 Installer No-Services and tarball installations:
    $ cd install_location//resources/cassandra/tools
    $ bin/sstableofflinerelevel [--dry-run] keyspace table
  • Cassandra package installations:
    $ sstableofflinerelevel [--dry-run] keyspace table
  • Cassandra tarball installations:
    $ cd install_location/tools
    $ bin/sstableofflinerelevel [--dry-run] keyspace table

Procedure

Choose a keyspace and table to relevel.
$ sstableofflinerelevel cycling cyclist_name