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:
-
Edit the 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 |
-
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 parameter.
The refresh_rate_ms specifies the length of the sampling
period, that is, the frequency with which this data is updated.
