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

Procedure

To enable the collection of database-level statistics data:

  1. Edit the dse.yaml file.
    The location of the dse.yaml file depends on the type of installation:
    Installer-Services /etc/dse/dse.yaml
    Package installations /etc/dse/dse.yaml
    Installer-No Services install_location/resources/dse/conf/dse.yaml
    Tarball installations install_location/resources/dse/conf/dse.yaml
  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 parameter.

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