Metrics
nodetool cfhistograms
This tool has been renamed to nodetool tablehistograms.
nodetool cfstats
This tool has been renamed to nodetool tablestats.
nodetool tablehistograms
Initial troubleshooting and performance metrics that provide current performance statics for read and write latency on a table during the past fifteen minutes.
nodetool tablehistograms shows table performance statistics over the past fifteen minutes, including read/write latency, partition size, cell count, and number of SSTables. Use this tool to analyze performance and tune individual tables and ensure that the percent latency level meets the SLA for the data stored in the table.
nodetool options tablehistograms [--] keyspace_name table_name
nodetool tablehistograms
nodetool: tablehistograms requires keyspace and table name arguments
See 'nodetool help' or 'nodetool help <command>'.
nodetool tablehistograms keyspace1 standard1
keyspace1/standard1 histograms
Percentile SSTables Write Latency Read Latency Partition Size Cell Count
(micros) (micros) (bytes)
50% 2.00 11.86 73.46 258 5
75% 2.00 17.08 105.78 258 5
95% 3.00 24.60 182.79 258 5
98% 3.00 35.43 654.95 258 5
99% 3.00 42.51 2346.80 258 5
Min 2.00 2.30 24.60 180 5
Max 3.00 74975.55 155469.30 258 5
nodetool tablestats
Provides statistics about one or more tables.
nodetool [ options ] tablestats
[ -H | --human-readable ]
[ -i table [, table ] . . . ] [ - - ]
[ keyspace | table | keyspace.table ] [keyspace | table | keyspace.table ] . . .
-H | --human-readable to display bytes in human readable form: KiB (kibibyte), MiB (mebibyte), GiB (gibibyte), TiB (tebibyte). -i to ignore the list of tables and display the remaining tables
The nodetool tablestats command provides statistics about one or more tables. It's updated when SSTables change through compaction or flushing. DataStax Enterprise uses the metrics-core library to make the output more informative and easier to understand.
nodetool tablestats
Total number of tables: 38
----------------
Keyspace : keyspace1
Read Count: 562512
Read Latency: 0.17637808437864436 ms
Write Count: 12688321
Write Latency: 0.06319982021261915 ms
Pending Flushes: 0
Table: counter1
SSTable count: 0
Space used (live): 0
Space used (total): 0
...
...
...
----------------
Keyspace : system_auth
Read Count: 2
Read Latency: 0.4575 ms
Write Count: 1
Write Latency: 0.504 ms
Pending Flushes: 0
Table: resource_role_permissons_index
SSTable count: 0
Space used (live): 0
Space used (total): 0
...
...
...
Average tombstones per slice (last five minutes): NaN
Maximum tombstones per slice (last five minutes): 0
Dropped Mutations: 0
----------------
nodetool tablestats keyspace1
Total number of tables: 38
----------------
Keyspace : keyspace1
Read Count: 562512
Read Latency: 0.17637808437864436 ms
Write Count: 12688321
Write Latency: 0.06319982021261915 ms
Pending Flushes: 0
Table: counter1
SSTable count: 0
Space used (live): 0
Space used (total): 0
Space used by snapshots (total): 0
Off heap memory used (total): 0
SSTable Compression Ratio: -1.0
Number of partitions (estimate): 0
Memtable cell count: 0
Memtable data size: 0
Memtable off heap memory used: 0
Memtable switch count: 0
Local read count: 0
Local read latency: NaN ms
Local write count: 0
Local write latency: NaN ms
Pending flushes: 0
Percent repaired: 100.0
Bloom filter false positives: 0
Bloom filter false ratio: 0.00000
Bloom filter space used: 0
Bloom filter off heap memory used: 0
Index summary off heap memory used: 0
Compression metadata off heap memory used: 0
Compacted partition minimum bytes: 0
Compacted partition maximum bytes: 0
Compacted partition mean bytes: 0
Average live cells per slice (last five minutes): NaN
Maximum live cells per slice (last five minutes): 0
Average tombstones per slice (last five minutes): NaN
Maximum tombstones per slice (last five minutes): 0
Dropped Mutations: 0
Table: standard1
SSTable count: 6
Space used (live): 1550359602
Space used (total): 1550359602
Space used by snapshots (total): 0
Off heap memory used (total): 15513506
SSTable Compression Ratio: -1.0
Number of partitions (estimate): 5293397
Memtable cell count: 123066
Memtable data size: 34335414
Memtable off heap memory used: 0
Memtable switch count: 63
Local read count: 562512
Local read latency: 0.130 ms
Local write count: 12688321
Local write latency: 0.014 ms
Pending flushes: 0
Percent repaired: 0.0
Bloom filter false positives: 0
Bloom filter false ratio: 0.00000
Bloom filter space used: 14449744
Bloom filter off heap memory used: 14449696
Index summary off heap memory used: 1063810
Compression metadata off heap memory used: 0
Compacted partition minimum bytes: 180
Compacted partition maximum bytes: 258
Compacted partition mean bytes: 258
Average live cells per slice (last five minutes): 1.0
Maximum live cells per slice (last five minutes): 1
Average tombstones per slice (last five minutes): 1.0
Maximum tombstones per slice (last five minutes): 1
Dropped Mutations: 40
----------------
nodetool tablestats keyspace1.standard1 -H
Total number of tables: 38
----------------
Keyspace : keyspace1
Read Count: 562512
Read Latency: 0.17637808437864436 ms
Write Count: 12688321
Write Latency: 0.06319982021261915 ms
Pending Flushes: 0
Table: standard1
SSTable count: 6
Space used (live): 1550359602
Space used (total): 1550359602
Space used by snapshots (total): 0
Off heap memory used (total): 15513506
SSTable Compression Ratio: -1.0
Number of partitions (estimate): 5293397
Memtable cell count: 123066
Memtable data size: 34335414
Memtable off heap memory used: 0
Memtable switch count: 63
Local read count: 562512
Local read latency: 0.198 ms
Local write count: 12688321
Local write latency: 0.016 ms
Pending flushes: 0
Percent repaired: 0.0
Bloom filter false positives: 0
Bloom filter false ratio: 0.00000
Bloom filter space used: 14449744
Bloom filter off heap memory used: 14449696
Index summary off heap memory used: 1063810
Compression metadata off heap memory used: 0
Compacted partition minimum bytes: 180
Compacted partition maximum bytes: 258
Compacted partition mean bytes: 258
Average live cells per slice (last five minutes): 1.0
Maximum live cells per slice (last five minutes): 1
Average tombstones per slice (last five minutes): 1.0
Maximum tombstones per slice (last five minutes): 1
Dropped Mutations: 40
----------------