Collecting database summary diagnostics 

Enable the db_summary_stats_options parameter in dse.yaml.

The following 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.