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.
Synopsis
nodetool options tablehistograms
[--] keyspace_name table_nameTarball and Installer No-Services path:
<installation_location>/resources/cassandra/bin| Short | Long | Description |
|---|---|---|
|
|
Hostname or IP address. |
|
|
Port number. |
|
|
Password file path. |
|
|
Password. |
|
|
Remote JMX agent username. |
|
Name of keyspace. |
|
|
Name of table. |
|
|
Separates an option from an argument that could be mistaken for an option. |
Description
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.
Example
For example, to get statistics for the DSE Search wiki demo solr table, use this command:
nodetool tablehistograms wiki solrOutput:
wiki/solr histograms
Percentile SSTables Write Latency Read Latency Partition Size Cell Count
(micros) (micros) (bytes)
50% 1.00 126.93 654.95 2759 3
75% 1.00 152.32 1358.10 5722 3
95% 1.00 785.94 5839.59 17084 3
98% 1.00 1629.72 12108.97 29521 3
99% 1.00 2346.80 12108.97 42510 3
Min 1.00 73.46 219.34 104 3
Max 1.00 2346.80 12108.97 219342 3The output shows the percentile rank of read and write latency values, the partition size, and the cell count for the table.
