Collecting database summary diagnostics

You can enable collecting database summary diagnostics using the DataStax Enterprise Performance Service.

These database summary diagnostic tables collect statistics at a database level:

node_table_snapshot

Per node lifetime table metrics broken down by keyspace and table.
table_snapshot

Cluster wide lifetime table metrics broken down by keyspace and table (aggregates node_table_snapshot from each node in the cluster).
keyspace_snapshot

Cluster wide lifetime table metrics, aggregated at the keyspace level (rolls up the data in table_snapshot).

Procedure

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

# Database summary stats options
db_summary_stats_options:
    enabled: true
    refresh_rate_ms: 10000

(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.

To temporarily enable the collection of database-level statistics data:

dsetool perf clustersummary enable

To temporarily disable the collection of database-level statistics data:

dsetool perf clustersummary disable

Changes made with performance object subcommands do not persist between restarts and are useful only for short-term diagnostics.