cassandra commands

15 commands, each with a one-line explanation. Click a command to copy it, or its title for details.

Commands 15 shown

  • Nodetool status
    nodetool status

    Show ring topology, load, state, and host IDs

    monitoring

  • Nodetool info
    nodetool info

    Local node heap, uptime, gossip, data center info

    monitoring

  • Connect with cqlsh
    cqlsh <host> 9042 -u cassandra -p cassandra

    Open CQL interactive shell

  • List keyspaces
    cqlsh -e 'DESCRIBE KEYSPACES'

    Show all keyspaces in the cluster

  • Repair keyspace
    nodetool repair -pr <keyspace>

    Run incremental repair on the primary range (use in maintenance)

  • Compaction stats
    nodetool compactionstats

    Show ongoing compaction operations and queue length

    monitoring

  • Flush table to disk
    nodetool flush <keyspace> <table>

    Force memtable flush to SSTables

  • Describe table
    cqlsh -e 'DESCRIBE TABLE <keyspace>.<table>'

    Show CREATE TABLE statement with all settings

  • Check node status
    nodetool status

    Show cluster ring with status, load and ownership

  • Check compaction stats
    nodetool compactionstats

    Show pending and active compaction tasks

    monitoring

  • Run CQL from cqlsh
    cqlsh -u cassandra -p cassandra -e 'DESCRIBE KEYSPACES;'

    Execute a CQL statement non-interactively

  • Check table stats
    nodetool tablestats mykeyspace.mytable

    Show read/write latencies and SSTable count for a table

    monitoring

  • Repair a keyspace
    nodetool repair -full mykeyspace

    Full repair to sync all replicas for a keyspace

  • Get gossip info
    nodetool gossipinfo

    Show gossip state for all nodes (debug)

    debug

  • Flush memtables to disk
    nodetool flush mykeyspace

    Force flush in-memory data to SSTables