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: