Cassandra supported metrics
Hardware metrics:
| Metrics | Description |
|---|---|
| Type of OS | Type of OS on which DB is running (Linux/Windows etc.) |
| Architecture | The OS architecture |
| Host Name | Configured host name on which DB is present |
| Availability | Active/Inactive [Database availablity ] |
| Average CPU Usage | Average CPU usage of the machine |
| Average Memory Usage | Average memory usage of the machine |
| Disk Usage | Disk usage on the configured host |
| CPU Usage | CPU usage on the configured host |
| Network I/O disk usage | I/O megabytes per second |
| Network I/O disk request | I/O requests per second |
Cluster metrics:
| Metrics | Description |
|---|---|
| Cluster name | Name for the configured cluster |
| Keyspace name | Name for the configured keyspace |
| Data center | Logical group of nodes |
| Cql version | Cql version |
| Rack | A logical grouping of Cassandra nodes within the ring |
Query Performance:
| Metrics | Description |
|---|---|
| Query | List of slow queries performed/available |
| Total Execution | Count of executions of each slow queries performed/available |
| Execution Time | Total execution time of each collected query |
| Timestamp | Last timestamp of each collected query |
Connections:
| Metrics | Description |
|---|---|
| Connections and Sessions | Number of connections and sessions made for the database |
| Heartbeat | Number of heartbeats for the specified time |
| Session details | User/Query list for established session |
Metrics:
| Metrics | Description |
|---|---|
| Load | The amount of file system data under the cassandra data directory after excluding all content in the snapshots subdirectories [updates every 90 seconds ] |
| Database Size | Database size in MB |
| SS Table & Pending Hints | A file format used when memtables are flushed to durable storage from memory |
| Latency | Replication time to the required set of nodes |
| Keyspace Count | A namespace that specifies data replication on nodes. |
| Prepared Statements | A Cassandra query that has been pre-parsed and validated by the cassandra database. |
| Task | Number of tasks running inside the thread pool |
| Local Read, Scan, Write | Number of requests count |
| Cache | The hit rate of keys and counters |
| Compaction | Size of the compactions performed per second |
note
Disk usage shows in GB and other metrics will be available in MB.