Collecting database summary diagnostics

Steps to enable collecting database summary diagnostics using the DataStax Enterprise Performance Service.

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

dse.yaml

The location of the dse.yaml file depends on the type of installation:
Package installations /etc/dse/dse.yaml
Tarball installations installation_location/resources/dse/conf/dse.yaml

Procedure

To permanently enable the collection of database-level statistics data:
  1. Edit the dse.yaml file.
  2. 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
  3. (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.

Example

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.