Collecting histogram diagnostics

DSE provides histogram tables for this data:

Histogram Details table Summary table Keyspace details Keyspace summary Global details Global summary

cell_count

Y

Y

N

N

N

N

partition_size

Y

Y

N

N

N

N

range_latency

Y

Y

Y

N

Y

N

read_latency

Y

Y

Y

N

Y

N

sstables_per_read

Y

Y

Y

N

N

N

write_latency

Y

Y

Y

N

N

N

These tables show similar information to the data obtained by the nodetool tablehistograms utility. The major difference is that the nodetool histograms output is recent data, while the diagnostic tables contain lifetime data. The data in the diagnostic histogram tables is cumulative since the DSE server was started. In contrast, the nodetool tablehistograms shows the values for the past fifteen minutes.

Procedure

  1. To enable the collection of table histogram data using the DataStax Enterprise Performance Service:

  2. Edit the dse.yaml file.

  3. In the dse.yaml file, set the enabled option for histogram_data_options to true.

    # Column Family Histogram data tables options
    histogram_data_options:
      enabled: true
      refresh_rate_ms: 10000
      retention_count: 3
  4. (Optional) To control how often the statistics are refreshed, increase or decrease the refresh_rate_ms option in dse.yaml.

    The refresh_rate_ms specifies the length of the sampling period, that is, the frequency with which this data is updated.

Was this helpful?

Give Feedback

How can we improve the documentation?

© 2024 DataStax | Privacy policy | Terms of use

Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Apache Solr, Apache Hadoop, Hadoop, Apache Pulsar, Pulsar, Apache Spark, Spark, Apache TinkerPop, TinkerPop, Apache Kafka and Kafka are either registered trademarks or trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries. Kubernetes is the registered trademark of the Linux Foundation.

General Inquiries: +1 (650) 389-6000, info@datastax.com