Cassandra monitoring integration

db.allMemtablesOffHeapSizeBytes

Total amount of bytes stored in the memtables (2i and pending flush memtables included) that resides on-heap.

db.allMemtablesOnHeapSizeBytes

Total amount of bytes stored in the memtables (2i and pending flush memtables included) that resides off-heap.

db.commitLogCompletedTasksPerSecond

The number of commit log messages written per second.

db.commitLogPendindTasks

Number of commit log messages written but yet to be fsync’ed.

db.commitLogTotalSizeBytes

Current size, in bytes, used by all the commit log segments.

db.droppedRequestTypeMessagesPerSecond

Dropped messages per second for this type of request. RequestType can be any of the following: BatchRemove, BatchStore, CounterMutation, Hint, Mutation, PagedRange, RangeSlice, Read, ReadRepair, RequestResponse, or Trace.

db.keyCacheCapacityBytes

Key cache capacity in bytes.

db.keyCacheHitRate

One-minute key cache hit rate.

db.keyCacheHitsPerSecond

Number of key cache hits per second.

db.keyCacheRequestsPerSecond

Number of requests to the key cache per second.

db.keyCacheSizeBytes

Size of occupied cache in bytes.

db.liveSSTableCount

Number of SSTables on disk for this column family.

db.loadBytes

Size, in bytes, of the on disk data size this node manages.

db.rowCacheCapacityBytes

Row cache capacity in bytes.

db.rowCacheHitRate

One-minute row cache hit rate.

db.rowCacheHitsPerSecond

Number of row cache hits per second.

db.rowCacheRequestsPerSecond

Number of requests to the row cache per second.

db.rowCacheSizeBytes

Total size of occupied row cache, in bytes.

db.threadpool.poolActiveTasks

Number of tasks being actively worked on by this pool. pool can be one of the following:

• internalAntiEntropyStage
• internalCacheCleanupExecutor
• internalCompactionExecutor
• internalGossipStage
• internalHintsDispatcher
• internalInternalResponseStage
• internalMemtableFlushWriter
• internalMemtablePostFlush
• internalMemtableReclaimMemory
• internalMigrationStage
• internalMiscStage
• internalPendingRangeCalculator
• internalSampler
• internalSecondaryIndexManagement
• internalValidationExecutor
• requestCounterMutationStage
• requestMutationStage
• requestReadRepairStage
• requestReadStage
• requestRequestResponse
• requestViewMutationStage

db.threadpool.pool.PendingTasks

Number of tasks being actively worked on by this pool. pool can be any of the items in the list provided in the description of db.threadpool.poolActiveTasks.

db.totalHintsInProgress

Number of hints currently attempting to be sent.

db.totalHintsPerSecond

Number of hint messages per second written to this node. Includes one entry for each host to be hinted per hint.

query.CASReadRequestsPerSecond

Transaction read latency in requests per second.

query.CASWriteRequestsPerSecond

Transaction write latency in requests per second.

query.rangeSliceRequestsPerSecond

Number of range slice requests per second.

query.rangeSliceTimeoutsPerSecond

Number of timeouts encountered per second when processing token range read requests.

query.rangeSliceUnavailablesPerSecond

Number of unavailable exceptions encountered per second when processing token range read requests.

query.readLatency50thPercentileMilliseconds

Read latency in milliseconds, 50th percentile.

query.readLatency75thPercentileMilliseconds

Read latency in milliseconds, 75th percentile.

query.readLatency95thPercentileMilliseconds

Read latency in milliseconds, 95th percentile.

query.readLatency98thPercentileMilliseconds

Read latency in milliseconds, 98th percentile.

query.readLatency999thPercentileMilliseconds

Read latency in milliseconds, 999th percentile.

query.readLatency99thPercentileMilliseconds

Read latency in milliseconds, 99th percentile.

query.readRequestsPerSecond

Number of read requests per second.

query.readTimeoutsPerSecond

Number of timeouts encountered per second when processing standard read requests.

query.readUnavailablesPerSecond

Number of unavailable exceptions encountered per second when processing standard read requests.

query.viewWriteRequestsPerSecond

Number of view write requests per second.

query.writeLatency50thPercentileMilliseconds

Write latency in milliseconds, 50th percentile.

query.writeLatency75thPercentileMilliseconds

Write latency in milliseconds, 75th percentile.

query.writeLatency95thPercentileMilliseconds

Write latency in milliseconds, 95th percentile.

query.writeLatency98thPercentileMilliseconds

Write latency in milliseconds, 98th percentile.

query.writeLatency999thPercentileMilliseconds

Write latency in milliseconds, 999th percentile.

query.writeLatency99thPercentileMilliseconds

Write latency in milliseconds, 99th percentile.

query.writeRequestsPerSecond

Number of write requests per second.

query.writeTimeoutsPerSecond

Number of timeouts encountered per second when processing regular write requests.

query.writeUnavailablesPerSecond

Number of unavailable exceptions encountered per second when processing regular write requests.

db.columnFamily

The Cassandra column family these metrics refer to.

db.keyspace

The Cassandra keyspace that contains this column family.

db.keyspaceAndColumnFamily

The keyspace and column family in a single metadata attribute in the following format: keyspace.columnFamily.

db.allMemtablesOffHeapSizeBytes

Total number of bytes stored in the memtables (2i and pending flush memtables included) that resides off-heap.

db.allMemtablesOnHeapSizeBytes

Total number of bytes stored in the memtables (2i and pending flush memtables included) that resides on-heap.

db.liveDiskSpaceUsedBytes

Disk space in bytes used by SSTables belonging to this column family (in bytes).

db.liveSSTableCount

Number of SSTables on disk for this column family.

db.pendingCompactions

Estimate of number of pending compactions for this column family.

db.SSTablesPerRead50thPercentileMilliseconds

Number of sstable data files accessed per read, 50th percentile.

db.SSTablesPerRead75thPercentileMilliseconds

Number of sstable data files accessed per read, 75th percentile.

db.SSTablesPerRead95thPercentileMilliseconds

Number of sstable data files accessed per read, 95th percentile.

db.SSTablesPerRead98thPercentileMilliseconds

Number of sstable data files accessed per read, 98th percentile.

db.SSTablesPerRead999thPercentileMilliseconds

Number of sstable data files accessed per read, 999th percentile.

db.SSTablesPerRead99thPercentileMilliseconds

Number of sstable data files accessed per read, 99th percentile.

query.readLatency50thPercentileMilliseconds

Local read latency in milliseconds for this column family, 50th percentile.

query.readLatency75thPercentileMilliseconds

Local read latency in milliseconds for this column family, 75th percentile.

query.readLatency95thPercentileMilliseconds

Local read latency in milliseconds for this column family, 95th percentile.

query.readLatency98thPercentileMilliseconds

Local read latency in milliseconds for this column family, 98th percentile.

query.readLatency999thPercentileMilliseconds

Local read latency in milliseconds for this column family, 999th percentile.

query.readLatency99thPercentileMilliseconds

Local read latency in milliseconds for this column family, 99th percentile.

query.readRequestsPerSecond

Number of read requests per second for this column family.

query.writeLatency50thPercentileMilliseconds

Local write latency in milliseconds for this column family, 50th percentile.

query.writeLatency75thPercentileMilliseconds

Local write latency in milliseconds for this column family, 75th percentile.

query.writeLatency95thPercentileMilliseconds

Local write latency in milliseconds for this column family, 95th percentile.

query.writeLatency98thPercentileMilliseconds

Local write latency in milliseconds for this column family, 98th percentile.

query.writeLatency999thPercentileMilliseconds

Local write latency in milliseconds for this column family, 999th percentile.

query.writeLatency99thPercentileMilliseconds

Local write latency in milliseconds for this column family, 99th percentile.

query.writeRequestsPerSecond

Number of write requests per second for this column family.

software.version

The Cassandra version.

cluster.name

The name of the cluster this Cassandra node belongs to.