Collecting table histogram diagnostics
Enable the histogram_data_options parameter in dse.yaml.
The following histogram diagnostics tables collect histogram data at a table level:
- cell_count_histograms
Cell count per partition.
- partition_size_histograms
Partition size.
- read_latency_histograms
Read latency.
- sstables_per_read_histograms
SSTables per read.
- write_latency_histograms
Write latency.
Note: These tables somewhat duplicate the information obtained by the nodetool cfhistograms utility. The major
difference is that cfhistograms output is recent data, whereas the diagnostic tables
contain lifetime data. Additionally, each time nodetool cfhistograms is run for a
column family, the histogram values are reset; whereas the data in the diagnostic
histogram tables are not.
Procedure
To enable the collection of table histogram data: