Database Reference
In-Depth Information
Getting Statistics
Nodetool also lets you gather statistics about the state of your server down to the data level. This
is much more detailed information about your data than is gathered by the
info
switch. There
are two basic commands:
cfstats
and
tpstats
, both of which we examine now.
Using cfstats
To see an overview of each column family, you can use the
cfstats
switch. This gives you
cluster metrics. To view column family statistics, execute Nodetool as follows (replacing the IP
address with one in your cluster, of course):
$ bin/nodetool -host 192.168.1.5 cfstats
This will generate output like the following:
Keyspace: Keyspace1
Read Count: 13
Read Latency: 0.3252307692307692 ms.
Write Count: 3
Write Latency: 0.13266666666666665 ms.
Pending Tasks: 0
Column Family: StandardByUUID1
SSTable count: 0
Space used (live): 0
Space used (total): 0
Memtable Columns Count: 0
Memtable Data Size: 0
Memtable Switch Count: 0
Read Count: 0
Read Latency: NaN ms.
Write Count: 0
Write Latency: NaN ms.
Pending Tasks: 0
Key cache capacity: 200000
Key cache size: 0
Key cache hit rate: NaN
Row cache: disabled
Compacted row minimum size: 0
Compacted row maximum size: 0
Compacted row mean size: 0
Column Family: Standard2
SSTable count: 1
Space used (live): 379
