Available solutions
Apache Cassandra by JMX
Overview
This template is designed for the effortless deployment of Apache Cassandra monitoring by Zabbix via JMX and doesn't require any external scripts.
Requirements
Zabbix version: 7.4 and higher.
Tested versions
This template has been tested on:
- Apache Cassandra 3.11.8
Configuration
Zabbix should be configured according to the instructions in the Templates out of the box section.
Setup
This template works with standalone and cluster instances. Metrics are collected by JMX.
- Enable and configure JMX access to Apache cassandra. See documentation for instructions.
- Set the user name and password in host macros {$CASSANDRA.USER} and {$CASSANDRA.PASSWORD}.
Macros used
| Name | Description | Default |
|---|---|---|
| {$CASSANDRA.USER} | zabbix |
|
| {$CASSANDRA.PASSWORD} | zabbix |
|
| {$CASSANDRA.KEY_SPACE.MATCHES} | Filter of discoverable key spaces |
.* |
| {$CASSANDRA.KEY_SPACE.NOT_MATCHES} | Filter to exclude discovered key spaces |
(system|system_auth|system_distributed|system_schema) |
| {$CASSANDRA.PENDING_TASKS.MAX.HIGH} | 500 |
|
| {$CASSANDRA.PENDING_TASKS.MAX.WARN} | 350 |
Items
| Name | Description | Type | Key and additional info |
|---|---|---|---|
| Cluster - Nodes down | JMX agent | jmx["org.apache.cassandra.net:type=FailureDetector","DownEndpointCount"] Preprocessing
|
|
| Cluster - Nodes up | JMX agent | jmx["org.apache.cassandra.net:type=FailureDetector","UpEndpointCount"] Preprocessing
|
|
| Cluster - Name | JMX agent | jmx["org.apache.cassandra.db:type=StorageService","ClusterName"] Preprocessing
|
|
| Version | JMX agent | jmx["org.apache.cassandra.db:type=StorageService","ReleaseVersion"] Preprocessing
|
|
| Dropped messages - Write (Mutation) | Number of dropped regular writes messages. |
JMX agent | jmx["org.apache.cassandra.metrics:type=DroppedMessage,scope=MUTATION,name=Dropped","Count"] |
| Dropped messages - Read | Number of dropped regular reads messages. |
JMX agent | jmx["org.apache.cassandra.metrics:type=DroppedMessage,scope=READ,name=Dropped","Count"] |
| Storage - Used (bytes) | Size, in bytes, of the on disk data size this node manages. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Storage,name=Load","Count"] |
| Storage - Errors | Number of internal exceptions caught. Under normal exceptions this should be zero. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Storage,name=Exceptions","Count"] |
| Storage - Hints | Number of hint messages written to this node since [re]start. Includes one entry for each host to be hinted per hint. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Storage,name=TotalHints","Count"] |
| Compaction - Number of completed tasks | Number of completed compactions since server [re]start. |
JMX agent | jmx["org.apache.cassandra.metrics:name=CompletedTasks,type=Compaction","Value"] |
| Compaction - Total compactions completed | Throughput of completed compactions since server [re]start. |
JMX agent | jmx["org.apache.cassandra.metrics:name=TotalCompactionsCompleted,type=Compaction","Count"] |
| Compaction - Pending tasks | Estimated number of compactions remaining to perform. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Compaction,name=PendingTasks","Value"] |
| Commitlog - Pending tasks | Number of commit log messages written but yet to be fsync'd. |
JMX agent | jmx["org.apache.cassandra.metrics:name=PendingTasks,type=CommitLog","Value"] |
| Commitlog - Total size | Current size, in bytes, used by all the commit log segments. |
JMX agent | jmx["org.apache.cassandra.metrics:name=TotalCommitLogSize,type=CommitLog","Value"] |
| Latency - Read median | Latency read from disk in milliseconds - median. |
JMX agent | jmx["org.apache.cassandra.metrics:name=ReadLatency,type=Table","50thPercentile"] Preprocessing
|
| Latency - Read 75 percentile | Latency read from disk in milliseconds - p75. |
JMX agent | jmx["org.apache.cassandra.metrics:name=ReadLatency,type=Table","75thPercentile"] Preprocessing
|
| Latency - Read 95 percentile | Latency read from disk in milliseconds - p95. |
JMX agent | jmx["org.apache.cassandra.metrics:name=ReadLatency,type=Table","95thPercentile"] Preprocessing
|
| Latency - Write median | Latency write to disk in milliseconds - median. |
JMX agent | jmx["org.apache.cassandra.metrics:name=WriteLatency,type=Table","50thPercentile"] Preprocessing
|
| Latency - Write 75 percentile | Latency write to disk in milliseconds - p75. |
JMX agent | jmx["org.apache.cassandra.metrics:name=WriteLatency,type=Table","75thPercentile"] Preprocessing
|
| Latency - Write 95 percentile | Latency write to disk in milliseconds - p95. |
JMX agent | jmx["org.apache.cassandra.metrics:name=WriteLatency,type=Table","95thPercentile"] Preprocessing
|
| Latency - Client request read median | Total latency serving data to clients in milliseconds - median. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Read,name=Latency","50thPercentile"] Preprocessing
|
| Latency - Client request read 75 percentile | Total latency serving data to clients in milliseconds - p75. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Read,name=Latency","75thPercentile"] Preprocessing
|
| Latency - Client request read 95 percentile | Total latency serving data to clients in milliseconds - p95. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Read,name=Latency","95thPercentile"] Preprocessing
|
| Latency - Client request write median | Total latency serving write requests from clients in milliseconds - median. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Write,name=Latency","50thPercentile"] Preprocessing
|
| Latency - Client request write 75 percentile | Total latency serving write requests from clients in milliseconds - p75. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Write,name=Latency","75thPercentile"] Preprocessing
|
| Latency - Client request write 95 percentile | Total latency serving write requests from clients in milliseconds - p95. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Write,name=Latency","95thPercentile"] Preprocessing
|
| KeyCache - Capacity | Cache capacity in bytes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=Capacity","Value"] Preprocessing
|
| KeyCache - Entries | Total number of cache entries. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=Entries","Value"] |
| KeyCache - HitRate | All time cache hit rate. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=HitRate","Value"] Preprocessing
|
| KeyCache - Hits per second | Rate of cache hits. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=Hits","Count"] Preprocessing
|
| KeyCache - requests per second | Rate of cache requests. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=Requests","Count"] Preprocessing
|
| KeyCache - Size | Total size of occupied cache, in bytes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=Size","Value"] |
| Client connections - Native | Number of clients connected to this nodes native protocol server. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Client,name=connectedNativeClients","Value"] |
| Client connections - Trifts | Number of connected to this nodes thrift clients. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Client,name=connectedThriftClients","Value"] |
| Client request - Read per second | The number of client requests per second. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Read,name=Latency","Count"] Preprocessing
|
| Client request - Write per second | The number of local write requests per second. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Write,name=Latency","Count"] Preprocessing
|
| Client request - Write Timeouts | Number of write requests timeouts encountered. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Write,name=Timeouts","Count"] |
| Thread pool.MutationStage - Pending tasks | Number of queued tasks queued up on this pool. MutationStage: Responsible for writes (exclude materialized and counter writes). |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=MutationStage,name=PendingTasks","Value"] |
| Thread pool MutationStage - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. MutationStage: Responsible for writes (exclude materialized and counter writes). |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=MutationStage,name=CurrentlyBlockedTasks","Count"] |
| Thread pool MutationStage - Total blocked tasks | Number of tasks that were blocked due to queue saturation. MutationStage: Responsible for writes (exclude materialized and counter writes). |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=MutationStage,name=TotalBlockedTasks","Count"] |
| Thread pool CounterMutationStage - Pending tasks | Number of queued tasks queued up on this pool. CounterMutationStage: Responsible for counter writes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=CounterMutationStage,name=PendingTasks","Value"] |
| Thread pool CounterMutationStage - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. CounterMutationStage: Responsible for counter writes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=CounterMutationStage,name=CurrentlyBlockedTasks","Count"] |
| Thread pool CounterMutationStage - Total blocked tasks | Number of tasks that were blocked due to queue saturation. CounterMutationStage: Responsible for counter writes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=CounterMutationStage,name=TotalBlockedTasks","Count"] |
| Thread pool ReadStage - Pending tasks | Number of queued tasks queued up on this pool. ReadStage: Local reads run on this thread pool. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ReadStage,name=PendingTasks","Value"] |
| Thread pool ReadStage - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. ReadStage: Local reads run on this thread pool. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ReadStage,name=CurrentlyBlockedTasks","Count"] |
| Thread pool ReadStage - Total blocked tasks | Number of tasks that were blocked due to queue saturation. ReadStage: Local reads run on this thread pool. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ReadStage,name=TotalBlockedTasks","Count"] |
| Thread pool ViewMutationStage - Pending tasks | Number of queued tasks queued up on this pool. ViewMutationStage: Responsible for materialized view writes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ViewMutationStage,name=PendingTasks","Value"] |
| Thread pool ViewMutationStage - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. ViewMutationStage: Responsible for materialized view writes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ViewMutationStage,name=CurrentlyBlockedTasks","Count"] |
| Thread pool ViewMutationStage - Total blocked tasks | Number of tasks that were blocked due to queue saturation. ViewMutationStage: Responsible for materialized view writes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ViewMutationStage,name=TotalBlockedTasks","Count"] |
| Thread pool MemtableFlushWriter - Pending tasks | Number of queued tasks queued up on this pool. MemtableFlushWriter: Writes memtables to disk. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtableFlushWriter,name=PendingTasks","Value"] |
| Thread pool MemtableFlushWriter - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. MemtableFlushWriter: Writes memtables to disk. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtableFlushWriter,name=CurrentlyBlockedTasks","Count"] |
| Thread pool MemtableFlushWriter - Total blocked tasks | Number of tasks that were blocked due to queue saturation. MemtableFlushWriter: Writes memtables to disk. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtableFlushWriter,name=TotalBlockedTasks","Count"] |
| Thread pool HintsDispatcher - Pending tasks | Number of queued tasks queued up on this pool. HintsDispatcher: Performs hinted handoff. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=HintsDispatcher,name=PendingTasks","Value"] |
| Thread pool HintsDispatcher - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. HintsDispatcher: Performs hinted handoff. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=HintsDispatcher,name=CurrentlyBlockedTasks","Count"] |
| Thread pool HintsDispatcher - Total blocked tasks | Number of tasks that were blocked due to queue saturation. HintsDispatcher: Performs hinted handoff. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=HintsDispatcher,name=TotalBlockedTasks","Count"] |
| Thread pool MemtablePostFlush - Pending tasks | Number of queued tasks queued up on this pool. MemtablePostFlush: Cleans up commit log after memtable is written to disk. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtablePostFlush,name=PendingTasks","Value"] |
| Thread pool MemtablePostFlush - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. MemtablePostFlush: Cleans up commit log after memtable is written to disk. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtablePostFlush,name=CurrentlyBlockedTasks","Count"] |
| Thread pool MemtablePostFlush - Total blocked tasks | Number of tasks that were blocked due to queue saturation. MemtablePostFlush: Cleans up commit log after memtable is written to disk. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtablePostFlush,name=TotalBlockedTasks","Count"] |
| Thread pool MigrationStage - Pending tasks | Number of queued tasks queued up on this pool. MigrationStage: Runs schema migrations. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MigrationStage,name=PendingTasks","Value"] |
| Thread pool MigrationStage - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. MigrationStage: Runs schema migrations. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MigrationStage,name=CurrentlyBlockedTasks","Count"] |
| Thread pool MigrationStage - Total blocked tasks | Number of tasks that were blocked due to queue saturation. MigrationStage: Runs schema migrations. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MigrationStage,name=TotalBlockedTasks","Count"] |
| Thread pool MiscStage - Pending tasks | Number of queued tasks queued up on this pool. MiscStage: Miscellaneous tasks run here. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MiscStage,name=PendingTasks","Value"] |
| Thread pool MiscStage - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. MiscStage: Miscellaneous tasks run here. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MiscStage,name=CurrentlyBlockedTasks","Count"] |
| Thread pool MiscStage - Total blocked tasks | Number of tasks that were blocked due to queue saturation. MiscStage: Miscellaneous tasks run here. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MiscStage,name=TotalBlockedTasks","Count"] |
| Thread pool SecondaryIndexManagement - Pending tasks | Number of queued tasks queued up on this pool. SecondaryIndexManagement: Performs updates to secondary indexes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=SecondaryIndexManagement,name=PendingTasks","Value"] |
| Thread pool SecondaryIndexManagement - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. SecondaryIndexManagement: Performs updates to secondary indexes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=SecondaryIndexManagement,name=CurrentlyBlockedTasks","Count"] |
| Thread pool SecondaryIndexManagement - Total blocked tasks | Number of tasks that were blocked due to queue saturation. SecondaryIndexManagement: Performs updates to secondary indexes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=SecondaryIndexManagement,name=TotalBlockedTasks","Count"] |
Triggers
| Name | Description | Expression | Severity | Dependencies and additional info |
|---|---|---|---|---|
| Apache Cassandra: There are down nodes in cluster | last(/Apache Cassandra by JMX/jmx["org.apache.cassandra.net:type=FailureDetector","DownEndpointCount"])>0 |
Average | ||
| Apache Cassandra: Version has changed | Cassandra version has changed. Acknowledge to close the problem manually. |
last(/Apache Cassandra by JMX/jmx["org.apache.cassandra.db:type=StorageService","ReleaseVersion"],#1)<>last(/Apache Cassandra by JMX/jmx["org.apache.cassandra.db:type=StorageService","ReleaseVersion"],#2) and length(last(/Apache Cassandra by JMX/jmx["org.apache.cassandra.db:type=StorageService","ReleaseVersion"]))>0 |
Info | Manual close: Yes |
| Apache Cassandra: Failed to fetch info data | Zabbix has not received data for items for the last 15 minutes |
nodata(/Apache Cassandra by JMX/jmx["org.apache.cassandra.metrics:type=Storage,name=Load","Count"],15m)=1 |
Warning | |
| Apache Cassandra: Too many storage exceptions | min(/Apache Cassandra by JMX/jmx["org.apache.cassandra.metrics:type=Storage,name=Exceptions","Count"],5m)>0 |
Warning | ||
| Apache Cassandra: Many pending tasks | min(/Apache Cassandra by JMX/jmx["org.apache.cassandra.metrics:type=Compaction,name=PendingTasks","Value"],15m)>{$CASSANDRA.PENDING_TASKS.MAX.WARN} |
Warning | Depends on:
|
|
| Apache Cassandra: Too many pending tasks | min(/Apache Cassandra by JMX/jmx["org.apache.cassandra.metrics:type=Compaction,name=PendingTasks","Value"],15m)>{$CASSANDRA.PENDING_TASKS.MAX.HIGH} |
Average |
LLD rule Tables
| Name | Description | Type | Key and additional info |
|---|---|---|---|
| Tables | Info about keyspaces and tables |
JMX agent | jmx.discovery[beans,"org.apache.cassandra.metrics:type=Table,keyspace=,scope=,name=ReadLatency"] |
Item prototypes for Tables
| Name | Description | Type | Key and additional info |
|---|---|---|---|
| {#JMXKEYSPACE}.{#JMXSCOPE}: SS Tables per read 75 percentile | The number of SSTable data files accessed per read - p75. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=SSTablesPerReadHistogram","75thPercentile"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: SS Tables per read 95 percentile | The number of SSTable data files accessed per read - p95. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=SSTablesPerReadHistogram","95thPercentile"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Tombstone scanned 75 percentile | Number of tombstones scanned per read - p75. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=TombstoneScannedHistogram","75thPercentile"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Tombstone scanned 95 percentile | Number of tombstones scanned per read - p95. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=TombstoneScannedHistogram","95thPercentile"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Waiting on free memtable space 75 percentile | The time spent waiting for free memtable space either on- or off-heap - p75. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=WaitingOnFreeMemtableSpace","75thPercentile"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Waiting on free memtable space95 percentile | The time spent waiting for free memtable space either on- or off-heap - p95. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=WaitingOnFreeMemtableSpace","95thPercentile"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Col update time delta75 percentile | The column update time delta - p75. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=ColUpdateTimeDeltaHistogram","75thPercentile"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Col update time delta 95 percentile | The column update time delta - p95. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=ColUpdateTimeDeltaHistogram","95thPercentile"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Bloom filter false ratio | The ratio of Bloom filter false positives to total checks. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=BloomFilterFalseRatio","Value"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Compression ratio | The compression ratio for all SSTables. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=CompressionRatio","Value"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: KeyCache hit rate | The key cache hit rate. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=KeyCacheHitRate","Value"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Live SS Table | Number of "live" (in use) SSTables. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=LiveSSTableCount","Value"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Max partition size | The size of the largest compacted partition. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=MaxPartitionSize","Value"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Mean partition size | The average size of compacted partition. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=MeanPartitionSize","Value"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Pending compactions | The number of pending compactions. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=PendingCompactions","Value"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Snapshots size | The disk space truly used by snapshots. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=SnapshotsSize","Value"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Compaction bytes written | The amount of data that was compacted since (re)start. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=CompactionBytesWritten","Count"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Bytes flushed | The amount of data that was flushed since (re)start. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=BytesFlushed","Count"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Pending flushes | The number of pending flushes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=PendingFlushes","Count"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Live disk space used | The disk space used by "live" SSTables (only counts in use files). |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=LiveDiskSpaceUsed","Count"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Disk space used | Disk space used. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=TotalDiskSpaceUsed","Count"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Out of row cache hits | The number of row cache hits that do not satisfy the query filter and went to disk. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=RowCacheHitOutOfRange","Count"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Row cache hits | The number of row cache hits. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=RowCacheHit","Count"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Row cache misses | The number of table row cache misses. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=RowCacheMiss","Count"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Read latency 75 percentile | Latency read from disk in milliseconds. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=ReadLatency","75thPercentile"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Read latency 95 percentile | Latency read from disk in milliseconds. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=ReadLatency","95thPercentile"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Read per second | The number of client requests per second. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=ReadLatency","Count"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Write latency 75 percentile | Latency write to disk in milliseconds. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=WriteLatency","75thPercentile"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Write latency 95 percentile | Latency write to disk in milliseconds. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=WriteLatency","95thPercentile"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Write per second | The number of local write requests per second. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=WriteLatency","Count"] Preprocessing
|
Feedback
Please report any issues with the template at https://support.zabbix.com
You can also provide feedback, discuss the template, or ask for help at ZABBIX forums
Apache Cassandra by JMX
Overview
This template is designed for the effortless deployment of Apache Cassandra monitoring by Zabbix via JMX and doesn't require any external scripts.
Requirements
Zabbix version: 7.2 and higher.
Tested versions
This template has been tested on:
- Apache Cassandra 3.11.8
Configuration
Zabbix should be configured according to the instructions in the Templates out of the box section.
Setup
This template works with standalone and cluster instances. Metrics are collected by JMX.
- Enable and configure JMX access to Apache cassandra. See documentation for instructions.
- Set the user name and password in host macros {$CASSANDRA.USER} and {$CASSANDRA.PASSWORD}.
Macros used
| Name | Description | Default |
|---|---|---|
| {$CASSANDRA.USER} | zabbix |
|
| {$CASSANDRA.PASSWORD} | zabbix |
|
| {$CASSANDRA.KEY_SPACE.MATCHES} | Filter of discoverable key spaces |
.* |
| {$CASSANDRA.KEY_SPACE.NOT_MATCHES} | Filter to exclude discovered key spaces |
(system|system_auth|system_distributed|system_schema) |
| {$CASSANDRA.PENDING_TASKS.MAX.HIGH} | 500 |
|
| {$CASSANDRA.PENDING_TASKS.MAX.WARN} | 350 |
Items
| Name | Description | Type | Key and additional info |
|---|---|---|---|
| Cluster - Nodes down | JMX agent | jmx["org.apache.cassandra.net:type=FailureDetector","DownEndpointCount"] Preprocessing
|
|
| Cluster - Nodes up | JMX agent | jmx["org.apache.cassandra.net:type=FailureDetector","UpEndpointCount"] Preprocessing
|
|
| Cluster - Name | JMX agent | jmx["org.apache.cassandra.db:type=StorageService","ClusterName"] Preprocessing
|
|
| Version | JMX agent | jmx["org.apache.cassandra.db:type=StorageService","ReleaseVersion"] Preprocessing
|
|
| Dropped messages - Write (Mutation) | Number of dropped regular writes messages. |
JMX agent | jmx["org.apache.cassandra.metrics:type=DroppedMessage,scope=MUTATION,name=Dropped","Count"] |
| Dropped messages - Read | Number of dropped regular reads messages. |
JMX agent | jmx["org.apache.cassandra.metrics:type=DroppedMessage,scope=READ,name=Dropped","Count"] |
| Storage - Used (bytes) | Size, in bytes, of the on disk data size this node manages. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Storage,name=Load","Count"] |
| Storage - Errors | Number of internal exceptions caught. Under normal exceptions this should be zero. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Storage,name=Exceptions","Count"] |
| Storage - Hints | Number of hint messages written to this node since [re]start. Includes one entry for each host to be hinted per hint. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Storage,name=TotalHints","Count"] |
| Compaction - Number of completed tasks | Number of completed compactions since server [re]start. |
JMX agent | jmx["org.apache.cassandra.metrics:name=CompletedTasks,type=Compaction","Value"] |
| Compaction - Total compactions completed | Throughput of completed compactions since server [re]start. |
JMX agent | jmx["org.apache.cassandra.metrics:name=TotalCompactionsCompleted,type=Compaction","Count"] |
| Compaction - Pending tasks | Estimated number of compactions remaining to perform. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Compaction,name=PendingTasks","Value"] |
| Commitlog - Pending tasks | Number of commit log messages written but yet to be fsync'd. |
JMX agent | jmx["org.apache.cassandra.metrics:name=PendingTasks,type=CommitLog","Value"] |
| Commitlog - Total size | Current size, in bytes, used by all the commit log segments. |
JMX agent | jmx["org.apache.cassandra.metrics:name=TotalCommitLogSize,type=CommitLog","Value"] |
| Latency - Read median | Latency read from disk in milliseconds - median. |
JMX agent | jmx["org.apache.cassandra.metrics:name=ReadLatency,type=Table","50thPercentile"] Preprocessing
|
| Latency - Read 75 percentile | Latency read from disk in milliseconds - p75. |
JMX agent | jmx["org.apache.cassandra.metrics:name=ReadLatency,type=Table","75thPercentile"] Preprocessing
|
| Latency - Read 95 percentile | Latency read from disk in milliseconds - p95. |
JMX agent | jmx["org.apache.cassandra.metrics:name=ReadLatency,type=Table","95thPercentile"] Preprocessing
|
| Latency - Write median | Latency write to disk in milliseconds - median. |
JMX agent | jmx["org.apache.cassandra.metrics:name=WriteLatency,type=Table","50thPercentile"] Preprocessing
|
| Latency - Write 75 percentile | Latency write to disk in milliseconds - p75. |
JMX agent | jmx["org.apache.cassandra.metrics:name=WriteLatency,type=Table","75thPercentile"] Preprocessing
|
| Latency - Write 95 percentile | Latency write to disk in milliseconds - p95. |
JMX agent | jmx["org.apache.cassandra.metrics:name=WriteLatency,type=Table","95thPercentile"] Preprocessing
|
| Latency - Client request read median | Total latency serving data to clients in milliseconds - median. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Read,name=Latency","50thPercentile"] Preprocessing
|
| Latency - Client request read 75 percentile | Total latency serving data to clients in milliseconds - p75. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Read,name=Latency","75thPercentile"] Preprocessing
|
| Latency - Client request read 95 percentile | Total latency serving data to clients in milliseconds - p95. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Read,name=Latency","95thPercentile"] Preprocessing
|
| Latency - Client request write median | Total latency serving write requests from clients in milliseconds - median. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Write,name=Latency","50thPercentile"] Preprocessing
|
| Latency - Client request write 75 percentile | Total latency serving write requests from clients in milliseconds - p75. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Write,name=Latency","75thPercentile"] Preprocessing
|
| Latency - Client request write 95 percentile | Total latency serving write requests from clients in milliseconds - p95. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Write,name=Latency","95thPercentile"] Preprocessing
|
| KeyCache - Capacity | Cache capacity in bytes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=Capacity","Value"] Preprocessing
|
| KeyCache - Entries | Total number of cache entries. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=Entries","Value"] |
| KeyCache - HitRate | All time cache hit rate. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=HitRate","Value"] Preprocessing
|
| KeyCache - Hits per second | Rate of cache hits. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=Hits","Count"] Preprocessing
|
| KeyCache - requests per second | Rate of cache requests. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=Requests","Count"] Preprocessing
|
| KeyCache - Size | Total size of occupied cache, in bytes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=Size","Value"] |
| Client connections - Native | Number of clients connected to this nodes native protocol server. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Client,name=connectedNativeClients","Value"] |
| Client connections - Trifts | Number of connected to this nodes thrift clients. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Client,name=connectedThriftClients","Value"] |
| Client request - Read per second | The number of client requests per second. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Read,name=Latency","Count"] Preprocessing
|
| Client request - Write per second | The number of local write requests per second. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Write,name=Latency","Count"] Preprocessing
|
| Client request - Write Timeouts | Number of write requests timeouts encountered. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Write,name=Timeouts","Count"] |
| Thread pool.MutationStage - Pending tasks | Number of queued tasks queued up on this pool. MutationStage: Responsible for writes (exclude materialized and counter writes). |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=MutationStage,name=PendingTasks","Value"] |
| Thread pool MutationStage - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. MutationStage: Responsible for writes (exclude materialized and counter writes). |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=MutationStage,name=CurrentlyBlockedTasks","Count"] |
| Thread pool MutationStage - Total blocked tasks | Number of tasks that were blocked due to queue saturation. MutationStage: Responsible for writes (exclude materialized and counter writes). |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=MutationStage,name=TotalBlockedTasks","Count"] |
| Thread pool CounterMutationStage - Pending tasks | Number of queued tasks queued up on this pool. CounterMutationStage: Responsible for counter writes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=CounterMutationStage,name=PendingTasks","Value"] |
| Thread pool CounterMutationStage - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. CounterMutationStage: Responsible for counter writes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=CounterMutationStage,name=CurrentlyBlockedTasks","Count"] |
| Thread pool CounterMutationStage - Total blocked tasks | Number of tasks that were blocked due to queue saturation. CounterMutationStage: Responsible for counter writes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=CounterMutationStage,name=TotalBlockedTasks","Count"] |
| Thread pool ReadStage - Pending tasks | Number of queued tasks queued up on this pool. ReadStage: Local reads run on this thread pool. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ReadStage,name=PendingTasks","Value"] |
| Thread pool ReadStage - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. ReadStage: Local reads run on this thread pool. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ReadStage,name=CurrentlyBlockedTasks","Count"] |
| Thread pool ReadStage - Total blocked tasks | Number of tasks that were blocked due to queue saturation. ReadStage: Local reads run on this thread pool. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ReadStage,name=TotalBlockedTasks","Count"] |
| Thread pool ViewMutationStage - Pending tasks | Number of queued tasks queued up on this pool. ViewMutationStage: Responsible for materialized view writes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ViewMutationStage,name=PendingTasks","Value"] |
| Thread pool ViewMutationStage - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. ViewMutationStage: Responsible for materialized view writes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ViewMutationStage,name=CurrentlyBlockedTasks","Count"] |
| Thread pool ViewMutationStage - Total blocked tasks | Number of tasks that were blocked due to queue saturation. ViewMutationStage: Responsible for materialized view writes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ViewMutationStage,name=TotalBlockedTasks","Count"] |
| Thread pool MemtableFlushWriter - Pending tasks | Number of queued tasks queued up on this pool. MemtableFlushWriter: Writes memtables to disk. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtableFlushWriter,name=PendingTasks","Value"] |
| Thread pool MemtableFlushWriter - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. MemtableFlushWriter: Writes memtables to disk. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtableFlushWriter,name=CurrentlyBlockedTasks","Count"] |
| Thread pool MemtableFlushWriter - Total blocked tasks | Number of tasks that were blocked due to queue saturation. MemtableFlushWriter: Writes memtables to disk. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtableFlushWriter,name=TotalBlockedTasks","Count"] |
| Thread pool HintsDispatcher - Pending tasks | Number of queued tasks queued up on this pool. HintsDispatcher: Performs hinted handoff. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=HintsDispatcher,name=PendingTasks","Value"] |
| Thread pool HintsDispatcher - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. HintsDispatcher: Performs hinted handoff. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=HintsDispatcher,name=CurrentlyBlockedTasks","Count"] |
| Thread pool HintsDispatcher - Total blocked tasks | Number of tasks that were blocked due to queue saturation. HintsDispatcher: Performs hinted handoff. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=HintsDispatcher,name=TotalBlockedTasks","Count"] |
| Thread pool MemtablePostFlush - Pending tasks | Number of queued tasks queued up on this pool. MemtablePostFlush: Cleans up commit log after memtable is written to disk. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtablePostFlush,name=PendingTasks","Value"] |
| Thread pool MemtablePostFlush - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. MemtablePostFlush: Cleans up commit log after memtable is written to disk. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtablePostFlush,name=CurrentlyBlockedTasks","Count"] |
| Thread pool MemtablePostFlush - Total blocked tasks | Number of tasks that were blocked due to queue saturation. MemtablePostFlush: Cleans up commit log after memtable is written to disk. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtablePostFlush,name=TotalBlockedTasks","Count"] |
| Thread pool MigrationStage - Pending tasks | Number of queued tasks queued up on this pool. MigrationStage: Runs schema migrations. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MigrationStage,name=PendingTasks","Value"] |
| Thread pool MigrationStage - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. MigrationStage: Runs schema migrations. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MigrationStage,name=CurrentlyBlockedTasks","Count"] |
| Thread pool MigrationStage - Total blocked tasks | Number of tasks that were blocked due to queue saturation. MigrationStage: Runs schema migrations. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MigrationStage,name=TotalBlockedTasks","Count"] |
| Thread pool MiscStage - Pending tasks | Number of queued tasks queued up on this pool. MiscStage: Miscellaneous tasks run here. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MiscStage,name=PendingTasks","Value"] |
| Thread pool MiscStage - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. MiscStage: Miscellaneous tasks run here. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MiscStage,name=CurrentlyBlockedTasks","Count"] |
| Thread pool MiscStage - Total blocked tasks | Number of tasks that were blocked due to queue saturation. MiscStage: Miscellaneous tasks run here. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MiscStage,name=TotalBlockedTasks","Count"] |
| Thread pool SecondaryIndexManagement - Pending tasks | Number of queued tasks queued up on this pool. SecondaryIndexManagement: Performs updates to secondary indexes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=SecondaryIndexManagement,name=PendingTasks","Value"] |
| Thread pool SecondaryIndexManagement - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. SecondaryIndexManagement: Performs updates to secondary indexes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=SecondaryIndexManagement,name=CurrentlyBlockedTasks","Count"] |
| Thread pool SecondaryIndexManagement - Total blocked tasks | Number of tasks that were blocked due to queue saturation. SecondaryIndexManagement: Performs updates to secondary indexes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=SecondaryIndexManagement,name=TotalBlockedTasks","Count"] |
Triggers
| Name | Description | Expression | Severity | Dependencies and additional info |
|---|---|---|---|---|
| Apache Cassandra: There are down nodes in cluster | last(/Apache Cassandra by JMX/jmx["org.apache.cassandra.net:type=FailureDetector","DownEndpointCount"])>0 |
Average | ||
| Apache Cassandra: Version has changed | Cassandra version has changed. Acknowledge to close the problem manually. |
last(/Apache Cassandra by JMX/jmx["org.apache.cassandra.db:type=StorageService","ReleaseVersion"],#1)<>last(/Apache Cassandra by JMX/jmx["org.apache.cassandra.db:type=StorageService","ReleaseVersion"],#2) and length(last(/Apache Cassandra by JMX/jmx["org.apache.cassandra.db:type=StorageService","ReleaseVersion"]))>0 |
Info | Manual close: Yes |
| Apache Cassandra: Failed to fetch info data | Zabbix has not received data for items for the last 15 minutes |
nodata(/Apache Cassandra by JMX/jmx["org.apache.cassandra.metrics:type=Storage,name=Load","Count"],15m)=1 |
Warning | |
| Apache Cassandra: Too many storage exceptions | min(/Apache Cassandra by JMX/jmx["org.apache.cassandra.metrics:type=Storage,name=Exceptions","Count"],5m)>0 |
Warning | ||
| Apache Cassandra: Many pending tasks | min(/Apache Cassandra by JMX/jmx["org.apache.cassandra.metrics:type=Compaction,name=PendingTasks","Value"],15m)>{$CASSANDRA.PENDING_TASKS.MAX.WARN} |
Warning | Depends on:
|
|
| Apache Cassandra: Too many pending tasks | min(/Apache Cassandra by JMX/jmx["org.apache.cassandra.metrics:type=Compaction,name=PendingTasks","Value"],15m)>{$CASSANDRA.PENDING_TASKS.MAX.HIGH} |
Average |
LLD rule Tables
| Name | Description | Type | Key and additional info |
|---|---|---|---|
| Tables | Info about keyspaces and tables |
JMX agent | jmx.discovery[beans,"org.apache.cassandra.metrics:type=Table,keyspace=,scope=,name=ReadLatency"] |
Item prototypes for Tables
| Name | Description | Type | Key and additional info |
|---|---|---|---|
| {#JMXKEYSPACE}.{#JMXSCOPE}: SS Tables per read 75 percentile | The number of SSTable data files accessed per read - p75. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=SSTablesPerReadHistogram","75thPercentile"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: SS Tables per read 95 percentile | The number of SSTable data files accessed per read - p95. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=SSTablesPerReadHistogram","95thPercentile"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Tombstone scanned 75 percentile | Number of tombstones scanned per read - p75. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=TombstoneScannedHistogram","75thPercentile"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Tombstone scanned 95 percentile | Number of tombstones scanned per read - p95. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=TombstoneScannedHistogram","95thPercentile"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Waiting on free memtable space 75 percentile | The time spent waiting for free memtable space either on- or off-heap - p75. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=WaitingOnFreeMemtableSpace","75thPercentile"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Waiting on free memtable space95 percentile | The time spent waiting for free memtable space either on- or off-heap - p95. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=WaitingOnFreeMemtableSpace","95thPercentile"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Col update time delta75 percentile | The column update time delta - p75. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=ColUpdateTimeDeltaHistogram","75thPercentile"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Col update time delta 95 percentile | The column update time delta - p95. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=ColUpdateTimeDeltaHistogram","95thPercentile"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Bloom filter false ratio | The ratio of Bloom filter false positives to total checks. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=BloomFilterFalseRatio","Value"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Compression ratio | The compression ratio for all SSTables. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=CompressionRatio","Value"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: KeyCache hit rate | The key cache hit rate. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=KeyCacheHitRate","Value"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Live SS Table | Number of "live" (in use) SSTables. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=LiveSSTableCount","Value"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Max partition size | The size of the largest compacted partition. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=MaxPartitionSize","Value"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Mean partition size | The average size of compacted partition. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=MeanPartitionSize","Value"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Pending compactions | The number of pending compactions. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=PendingCompactions","Value"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Snapshots size | The disk space truly used by snapshots. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=SnapshotsSize","Value"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Compaction bytes written | The amount of data that was compacted since (re)start. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=CompactionBytesWritten","Count"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Bytes flushed | The amount of data that was flushed since (re)start. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=BytesFlushed","Count"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Pending flushes | The number of pending flushes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=PendingFlushes","Count"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Live disk space used | The disk space used by "live" SSTables (only counts in use files). |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=LiveDiskSpaceUsed","Count"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Disk space used | Disk space used. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=TotalDiskSpaceUsed","Count"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Out of row cache hits | The number of row cache hits that do not satisfy the query filter and went to disk. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=RowCacheHitOutOfRange","Count"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Row cache hits | The number of row cache hits. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=RowCacheHit","Count"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Row cache misses | The number of table row cache misses. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=RowCacheMiss","Count"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Read latency 75 percentile | Latency read from disk in milliseconds. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=ReadLatency","75thPercentile"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Read latency 95 percentile | Latency read from disk in milliseconds. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=ReadLatency","95thPercentile"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Read per second | The number of client requests per second. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=ReadLatency","Count"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Write latency 75 percentile | Latency write to disk in milliseconds. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=WriteLatency","75thPercentile"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Write latency 95 percentile | Latency write to disk in milliseconds. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=WriteLatency","95thPercentile"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Write per second | The number of local write requests per second. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=WriteLatency","Count"] Preprocessing
|
Feedback
Please report any issues with the template at https://support.zabbix.com
You can also provide feedback, discuss the template, or ask for help at ZABBIX forums
Apache Cassandra by JMX
Overview
This template is designed for the effortless deployment of Apache Cassandra monitoring by Zabbix via JMX and doesn't require any external scripts.
Requirements
Zabbix version: 7.0 and higher.
Tested versions
This template has been tested on:
- Apache Cassandra 3.11.8
Configuration
Zabbix should be configured according to the instructions in the Templates out of the box section.
Setup
This template works with standalone and cluster instances. Metrics are collected by JMX.
- Enable and configure JMX access to Apache cassandra. See documentation for instructions.
- Set the user name and password in host macros {$CASSANDRA.USER} and {$CASSANDRA.PASSWORD}.
Macros used
| Name | Description | Default |
|---|---|---|
| {$CASSANDRA.USER} | zabbix |
|
| {$CASSANDRA.PASSWORD} | zabbix |
|
| {$CASSANDRA.KEY_SPACE.MATCHES} | Filter of discoverable key spaces |
.* |
| {$CASSANDRA.KEY_SPACE.NOT_MATCHES} | Filter to exclude discovered key spaces |
(system|system_auth|system_distributed|system_schema) |
| {$CASSANDRA.PENDING_TASKS.MAX.HIGH} | 500 |
|
| {$CASSANDRA.PENDING_TASKS.MAX.WARN} | 350 |
Items
| Name | Description | Type | Key and additional info |
|---|---|---|---|
| Cluster - Nodes down | JMX agent | jmx["org.apache.cassandra.net:type=FailureDetector","DownEndpointCount"] Preprocessing
|
|
| Cluster - Nodes up | JMX agent | jmx["org.apache.cassandra.net:type=FailureDetector","UpEndpointCount"] Preprocessing
|
|
| Cluster - Name | JMX agent | jmx["org.apache.cassandra.db:type=StorageService","ClusterName"] Preprocessing
|
|
| Version | JMX agent | jmx["org.apache.cassandra.db:type=StorageService","ReleaseVersion"] Preprocessing
|
|
| Dropped messages - Write (Mutation) | Number of dropped regular writes messages. |
JMX agent | jmx["org.apache.cassandra.metrics:type=DroppedMessage,scope=MUTATION,name=Dropped","Count"] |
| Dropped messages - Read | Number of dropped regular reads messages. |
JMX agent | jmx["org.apache.cassandra.metrics:type=DroppedMessage,scope=READ,name=Dropped","Count"] |
| Storage - Used (bytes) | Size, in bytes, of the on disk data size this node manages. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Storage,name=Load","Count"] |
| Storage - Errors | Number of internal exceptions caught. Under normal exceptions this should be zero. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Storage,name=Exceptions","Count"] |
| Storage - Hints | Number of hint messages written to this node since [re]start. Includes one entry for each host to be hinted per hint. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Storage,name=TotalHints","Count"] |
| Compaction - Number of completed tasks | Number of completed compactions since server [re]start. |
JMX agent | jmx["org.apache.cassandra.metrics:name=CompletedTasks,type=Compaction","Value"] |
| Compaction - Total compactions completed | Throughput of completed compactions since server [re]start. |
JMX agent | jmx["org.apache.cassandra.metrics:name=TotalCompactionsCompleted,type=Compaction","Count"] |
| Compaction - Pending tasks | Estimated number of compactions remaining to perform. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Compaction,name=PendingTasks","Value"] |
| Commitlog - Pending tasks | Number of commit log messages written but yet to be fsync'd. |
JMX agent | jmx["org.apache.cassandra.metrics:name=PendingTasks,type=CommitLog","Value"] |
| Commitlog - Total size | Current size, in bytes, used by all the commit log segments. |
JMX agent | jmx["org.apache.cassandra.metrics:name=TotalCommitLogSize,type=CommitLog","Value"] |
| Latency - Read median | Latency read from disk in milliseconds - median. |
JMX agent | jmx["org.apache.cassandra.metrics:name=ReadLatency,type=Table","50thPercentile"] Preprocessing
|
| Latency - Read 75 percentile | Latency read from disk in milliseconds - p75. |
JMX agent | jmx["org.apache.cassandra.metrics:name=ReadLatency,type=Table","75thPercentile"] Preprocessing
|
| Latency - Read 95 percentile | Latency read from disk in milliseconds - p95. |
JMX agent | jmx["org.apache.cassandra.metrics:name=ReadLatency,type=Table","95thPercentile"] Preprocessing
|
| Latency - Write median | Latency write to disk in milliseconds - median. |
JMX agent | jmx["org.apache.cassandra.metrics:name=WriteLatency,type=Table","50thPercentile"] Preprocessing
|
| Latency - Write 75 percentile | Latency write to disk in milliseconds - p75. |
JMX agent | jmx["org.apache.cassandra.metrics:name=WriteLatency,type=Table","75thPercentile"] Preprocessing
|
| Latency - Write 95 percentile | Latency write to disk in milliseconds - p95. |
JMX agent | jmx["org.apache.cassandra.metrics:name=WriteLatency,type=Table","95thPercentile"] Preprocessing
|
| Latency - Client request read median | Total latency serving data to clients in milliseconds - median. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Read,name=Latency","50thPercentile"] Preprocessing
|
| Latency - Client request read 75 percentile | Total latency serving data to clients in milliseconds - p75. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Read,name=Latency","75thPercentile"] Preprocessing
|
| Latency - Client request read 95 percentile | Total latency serving data to clients in milliseconds - p95. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Read,name=Latency","95thPercentile"] Preprocessing
|
| Latency - Client request write median | Total latency serving write requests from clients in milliseconds - median. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Write,name=Latency","50thPercentile"] Preprocessing
|
| Latency - Client request write 75 percentile | Total latency serving write requests from clients in milliseconds - p75. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Write,name=Latency","75thPercentile"] Preprocessing
|
| Latency - Client request write 95 percentile | Total latency serving write requests from clients in milliseconds - p95. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Write,name=Latency","95thPercentile"] Preprocessing
|
| KeyCache - Capacity | Cache capacity in bytes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=Capacity","Value"] Preprocessing
|
| KeyCache - Entries | Total number of cache entries. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=Entries","Value"] |
| KeyCache - HitRate | All time cache hit rate. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=HitRate","Value"] Preprocessing
|
| KeyCache - Hits per second | Rate of cache hits. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=Hits","Count"] Preprocessing
|
| KeyCache - requests per second | Rate of cache requests. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=Requests","Count"] Preprocessing
|
| KeyCache - Size | Total size of occupied cache, in bytes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=Size","Value"] |
| Client connections - Native | Number of clients connected to this nodes native protocol server. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Client,name=connectedNativeClients","Value"] |
| Client connections - Trifts | Number of connected to this nodes thrift clients. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Client,name=connectedThriftClients","Value"] |
| Client request - Read per second | The number of client requests per second. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Read,name=Latency","Count"] Preprocessing
|
| Client request - Write per second | The number of local write requests per second. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Write,name=Latency","Count"] Preprocessing
|
| Client request - Write Timeouts | Number of write requests timeouts encountered. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Write,name=Timeouts","Count"] |
| Thread pool.MutationStage - Pending tasks | Number of queued tasks queued up on this pool. MutationStage: Responsible for writes (exclude materialized and counter writes). |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=MutationStage,name=PendingTasks","Value"] |
| Thread pool MutationStage - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. MutationStage: Responsible for writes (exclude materialized and counter writes). |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=MutationStage,name=CurrentlyBlockedTasks","Count"] |
| Thread pool MutationStage - Total blocked tasks | Number of tasks that were blocked due to queue saturation. MutationStage: Responsible for writes (exclude materialized and counter writes). |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=MutationStage,name=TotalBlockedTasks","Count"] |
| Thread pool CounterMutationStage - Pending tasks | Number of queued tasks queued up on this pool. CounterMutationStage: Responsible for counter writes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=CounterMutationStage,name=PendingTasks","Value"] |
| Thread pool CounterMutationStage - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. CounterMutationStage: Responsible for counter writes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=CounterMutationStage,name=CurrentlyBlockedTasks","Count"] |
| Thread pool CounterMutationStage - Total blocked tasks | Number of tasks that were blocked due to queue saturation. CounterMutationStage: Responsible for counter writes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=CounterMutationStage,name=TotalBlockedTasks","Count"] |
| Thread pool ReadStage - Pending tasks | Number of queued tasks queued up on this pool. ReadStage: Local reads run on this thread pool. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ReadStage,name=PendingTasks","Value"] |
| Thread pool ReadStage - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. ReadStage: Local reads run on this thread pool. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ReadStage,name=CurrentlyBlockedTasks","Count"] |
| Thread pool ReadStage - Total blocked tasks | Number of tasks that were blocked due to queue saturation. ReadStage: Local reads run on this thread pool. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ReadStage,name=TotalBlockedTasks","Count"] |
| Thread pool ViewMutationStage - Pending tasks | Number of queued tasks queued up on this pool. ViewMutationStage: Responsible for materialized view writes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ViewMutationStage,name=PendingTasks","Value"] |
| Thread pool ViewMutationStage - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. ViewMutationStage: Responsible for materialized view writes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ViewMutationStage,name=CurrentlyBlockedTasks","Count"] |
| Thread pool ViewMutationStage - Total blocked tasks | Number of tasks that were blocked due to queue saturation. ViewMutationStage: Responsible for materialized view writes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ViewMutationStage,name=TotalBlockedTasks","Count"] |
| Thread pool MemtableFlushWriter - Pending tasks | Number of queued tasks queued up on this pool. MemtableFlushWriter: Writes memtables to disk. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtableFlushWriter,name=PendingTasks","Value"] |
| Thread pool MemtableFlushWriter - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. MemtableFlushWriter: Writes memtables to disk. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtableFlushWriter,name=CurrentlyBlockedTasks","Count"] |
| Thread pool MemtableFlushWriter - Total blocked tasks | Number of tasks that were blocked due to queue saturation. MemtableFlushWriter: Writes memtables to disk. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtableFlushWriter,name=TotalBlockedTasks","Count"] |
| Thread pool HintsDispatcher - Pending tasks | Number of queued tasks queued up on this pool. HintsDispatcher: Performs hinted handoff. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=HintsDispatcher,name=PendingTasks","Value"] |
| Thread pool HintsDispatcher - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. HintsDispatcher: Performs hinted handoff. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=HintsDispatcher,name=CurrentlyBlockedTasks","Count"] |
| Thread pool HintsDispatcher - Total blocked tasks | Number of tasks that were blocked due to queue saturation. HintsDispatcher: Performs hinted handoff. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=HintsDispatcher,name=TotalBlockedTasks","Count"] |
| Thread pool MemtablePostFlush - Pending tasks | Number of queued tasks queued up on this pool. MemtablePostFlush: Cleans up commit log after memtable is written to disk. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtablePostFlush,name=PendingTasks","Value"] |
| Thread pool MemtablePostFlush - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. MemtablePostFlush: Cleans up commit log after memtable is written to disk. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtablePostFlush,name=CurrentlyBlockedTasks","Count"] |
| Thread pool MemtablePostFlush - Total blocked tasks | Number of tasks that were blocked due to queue saturation. MemtablePostFlush: Cleans up commit log after memtable is written to disk. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtablePostFlush,name=TotalBlockedTasks","Count"] |
| Thread pool MigrationStage - Pending tasks | Number of queued tasks queued up on this pool. MigrationStage: Runs schema migrations. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MigrationStage,name=PendingTasks","Value"] |
| Thread pool MigrationStage - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. MigrationStage: Runs schema migrations. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MigrationStage,name=CurrentlyBlockedTasks","Count"] |
| Thread pool MigrationStage - Total blocked tasks | Number of tasks that were blocked due to queue saturation. MigrationStage: Runs schema migrations. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MigrationStage,name=TotalBlockedTasks","Count"] |
| Thread pool MiscStage - Pending tasks | Number of queued tasks queued up on this pool. MiscStage: Miscellaneous tasks run here. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MiscStage,name=PendingTasks","Value"] |
| Thread pool MiscStage - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. MiscStage: Miscellaneous tasks run here. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MiscStage,name=CurrentlyBlockedTasks","Count"] |
| Thread pool MiscStage - Total blocked tasks | Number of tasks that were blocked due to queue saturation. MiscStage: Miscellaneous tasks run here. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MiscStage,name=TotalBlockedTasks","Count"] |
| Thread pool SecondaryIndexManagement - Pending tasks | Number of queued tasks queued up on this pool. SecondaryIndexManagement: Performs updates to secondary indexes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=SecondaryIndexManagement,name=PendingTasks","Value"] |
| Thread pool SecondaryIndexManagement - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. SecondaryIndexManagement: Performs updates to secondary indexes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=SecondaryIndexManagement,name=CurrentlyBlockedTasks","Count"] |
| Thread pool SecondaryIndexManagement - Total blocked tasks | Number of tasks that were blocked due to queue saturation. SecondaryIndexManagement: Performs updates to secondary indexes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=SecondaryIndexManagement,name=TotalBlockedTasks","Count"] |
Triggers
| Name | Description | Expression | Severity | Dependencies and additional info |
|---|---|---|---|---|
| Apache Cassandra: There are down nodes in cluster | last(/Apache Cassandra by JMX/jmx["org.apache.cassandra.net:type=FailureDetector","DownEndpointCount"])>0 |
Average | ||
| Apache Cassandra: Version has changed | Cassandra version has changed. Acknowledge to close the problem manually. |
last(/Apache Cassandra by JMX/jmx["org.apache.cassandra.db:type=StorageService","ReleaseVersion"],#1)<>last(/Apache Cassandra by JMX/jmx["org.apache.cassandra.db:type=StorageService","ReleaseVersion"],#2) and length(last(/Apache Cassandra by JMX/jmx["org.apache.cassandra.db:type=StorageService","ReleaseVersion"]))>0 |
Info | Manual close: Yes |
| Apache Cassandra: Failed to fetch info data | Zabbix has not received data for items for the last 15 minutes |
nodata(/Apache Cassandra by JMX/jmx["org.apache.cassandra.metrics:type=Storage,name=Load","Count"],15m)=1 |
Warning | |
| Apache Cassandra: Too many storage exceptions | min(/Apache Cassandra by JMX/jmx["org.apache.cassandra.metrics:type=Storage,name=Exceptions","Count"],5m)>0 |
Warning | ||
| Apache Cassandra: Many pending tasks | min(/Apache Cassandra by JMX/jmx["org.apache.cassandra.metrics:type=Compaction,name=PendingTasks","Value"],15m)>{$CASSANDRA.PENDING_TASKS.MAX.WARN} |
Warning | Depends on:
|
|
| Apache Cassandra: Too many pending tasks | min(/Apache Cassandra by JMX/jmx["org.apache.cassandra.metrics:type=Compaction,name=PendingTasks","Value"],15m)>{$CASSANDRA.PENDING_TASKS.MAX.HIGH} |
Average |
LLD rule Tables
| Name | Description | Type | Key and additional info |
|---|---|---|---|
| Tables | Info about keyspaces and tables |
JMX agent | jmx.discovery[beans,"org.apache.cassandra.metrics:type=Table,keyspace=,scope=,name=ReadLatency"] |
Item prototypes for Tables
| Name | Description | Type | Key and additional info |
|---|---|---|---|
| {#JMXKEYSPACE}.{#JMXSCOPE}: SS Tables per read 75 percentile | The number of SSTable data files accessed per read - p75. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=SSTablesPerReadHistogram","75thPercentile"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: SS Tables per read 95 percentile | The number of SSTable data files accessed per read - p95. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=SSTablesPerReadHistogram","95thPercentile"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Tombstone scanned 75 percentile | Number of tombstones scanned per read - p75. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=TombstoneScannedHistogram","75thPercentile"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Tombstone scanned 95 percentile | Number of tombstones scanned per read - p95. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=TombstoneScannedHistogram","95thPercentile"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Waiting on free memtable space 75 percentile | The time spent waiting for free memtable space either on- or off-heap - p75. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=WaitingOnFreeMemtableSpace","75thPercentile"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Waiting on free memtable space95 percentile | The time spent waiting for free memtable space either on- or off-heap - p95. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=WaitingOnFreeMemtableSpace","95thPercentile"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Col update time delta75 percentile | The column update time delta - p75. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=ColUpdateTimeDeltaHistogram","75thPercentile"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Col update time delta 95 percentile | The column update time delta - p95. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=ColUpdateTimeDeltaHistogram","95thPercentile"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Bloom filter false ratio | The ratio of Bloom filter false positives to total checks. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=BloomFilterFalseRatio","Value"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Compression ratio | The compression ratio for all SSTables. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=CompressionRatio","Value"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: KeyCache hit rate | The key cache hit rate. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=KeyCacheHitRate","Value"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Live SS Table | Number of "live" (in use) SSTables. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=LiveSSTableCount","Value"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Max partition size | The size of the largest compacted partition. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=MaxPartitionSize","Value"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Mean partition size | The average size of compacted partition. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=MeanPartitionSize","Value"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Pending compactions | The number of pending compactions. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=PendingCompactions","Value"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Snapshots size | The disk space truly used by snapshots. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=SnapshotsSize","Value"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Compaction bytes written | The amount of data that was compacted since (re)start. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=CompactionBytesWritten","Count"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Bytes flushed | The amount of data that was flushed since (re)start. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=BytesFlushed","Count"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Pending flushes | The number of pending flushes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=PendingFlushes","Count"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Live disk space used | The disk space used by "live" SSTables (only counts in use files). |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=LiveDiskSpaceUsed","Count"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Disk space used | Disk space used. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=TotalDiskSpaceUsed","Count"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Out of row cache hits | The number of row cache hits that do not satisfy the query filter and went to disk. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=RowCacheHitOutOfRange","Count"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Row cache hits | The number of row cache hits. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=RowCacheHit","Count"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Row cache misses | The number of table row cache misses. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=RowCacheMiss","Count"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Read latency 75 percentile | Latency read from disk in milliseconds. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=ReadLatency","75thPercentile"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Read latency 95 percentile | Latency read from disk in milliseconds. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=ReadLatency","95thPercentile"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Read per second | The number of client requests per second. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=ReadLatency","Count"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Write latency 75 percentile | Latency write to disk in milliseconds. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=WriteLatency","75thPercentile"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Write latency 95 percentile | Latency write to disk in milliseconds. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=WriteLatency","95thPercentile"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Write per second | The number of local write requests per second. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=WriteLatency","Count"] Preprocessing
|
Feedback
Please report any issues with the template at https://support.zabbix.com
You can also provide feedback, discuss the template, or ask for help at ZABBIX forums
Apache Cassandra by JMX
Overview
This template is designed for the effortless deployment of Apache Cassandra monitoring by Zabbix via JMX and doesn't require any external scripts.
Requirements
Zabbix version: 6.4 and higher.
Tested versions
This template has been tested on:
- Apache Cassandra 3.11.8
Configuration
Zabbix should be configured according to the instructions in the Templates out of the box section.
Setup
This template works with standalone and cluster instances. Metrics are collected by JMX.
- Enable and configure JMX access to Apache cassandra. See documentation for instructions.
- Set the user name and password in host macros {$CASSANDRA.USER} and {$CASSANDRA.PASSWORD}.
Macros used
| Name | Description | Default |
|---|---|---|
| {$CASSANDRA.USER} | zabbix |
|
| {$CASSANDRA.PASSWORD} | zabbix |
|
| {$CASSANDRA.KEY_SPACE.MATCHES} | Filter of discoverable key spaces |
.* |
| {$CASSANDRA.KEY_SPACE.NOT_MATCHES} | Filter to exclude discovered key spaces |
(system|system_auth|system_distributed|system_schema) |
| {$CASSANDRA.PENDING_TASKS.MAX.HIGH} | 500 |
|
| {$CASSANDRA.PENDING_TASKS.MAX.WARN} | 350 |
Items
| Name | Description | Type | Key and additional info |
|---|---|---|---|
| Apache Cassandra: Cluster - Nodes down | JMX agent | jmx["org.apache.cassandra.net:type=FailureDetector","DownEndpointCount"] Preprocessing
|
|
| Apache Cassandra: Cluster - Nodes up | JMX agent | jmx["org.apache.cassandra.net:type=FailureDetector","UpEndpointCount"] Preprocessing
|
|
| Apache Cassandra: Cluster - Name | JMX agent | jmx["org.apache.cassandra.db:type=StorageService","ClusterName"] Preprocessing
|
|
| Apache Cassandra: Version | JMX agent | jmx["org.apache.cassandra.db:type=StorageService","ReleaseVersion"] Preprocessing
|
|
| Apache Cassandra: Dropped messages - Write (Mutation) | Number of dropped regular writes messages. |
JMX agent | jmx["org.apache.cassandra.metrics:type=DroppedMessage,scope=MUTATION,name=Dropped","Count"] |
| Apache Cassandra: Dropped messages - Read | Number of dropped regular reads messages. |
JMX agent | jmx["org.apache.cassandra.metrics:type=DroppedMessage,scope=READ,name=Dropped","Count"] |
| Apache Cassandra: Storage - Used (bytes) | Size, in bytes, of the on disk data size this node manages. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Storage,name=Load","Count"] |
| Apache Cassandra: Storage - Errors | Number of internal exceptions caught. Under normal exceptions this should be zero. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Storage,name=Exceptions","Count"] |
| Apache Cassandra: Storage - Hints | Number of hint messages written to this node since [re]start. Includes one entry for each host to be hinted per hint. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Storage,name=TotalHints","Count"] |
| Apache Cassandra: Compaction - Number of completed tasks | Number of completed compactions since server [re]start. |
JMX agent | jmx["org.apache.cassandra.metrics:name=CompletedTasks,type=Compaction","Value"] |
| Apache Cassandra: Compaction - Total compactions completed | Throughput of completed compactions since server [re]start. |
JMX agent | jmx["org.apache.cassandra.metrics:name=TotalCompactionsCompleted,type=Compaction","Count"] |
| Apache Cassandra: Compaction - Pending tasks | Estimated number of compactions remaining to perform. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Compaction,name=PendingTasks","Value"] |
| Apache Cassandra: Commitlog - Pending tasks | Number of commit log messages written but yet to be fsync'd. |
JMX agent | jmx["org.apache.cassandra.metrics:name=PendingTasks,type=CommitLog","Value"] |
| Apache Cassandra: Commitlog - Total size | Current size, in bytes, used by all the commit log segments. |
JMX agent | jmx["org.apache.cassandra.metrics:name=TotalCommitLogSize,type=CommitLog","Value"] |
| Apache Cassandra: Latency - Read median | Latency read from disk in milliseconds - median. |
JMX agent | jmx["org.apache.cassandra.metrics:name=ReadLatency,type=Table","50thPercentile"] Preprocessing
|
| Apache Cassandra: Latency - Read 75 percentile | Latency read from disk in milliseconds - p75. |
JMX agent | jmx["org.apache.cassandra.metrics:name=ReadLatency,type=Table","75thPercentile"] Preprocessing
|
| Apache Cassandra: Latency - Read 95 percentile | Latency read from disk in milliseconds - p95. |
JMX agent | jmx["org.apache.cassandra.metrics:name=ReadLatency,type=Table","95thPercentile"] Preprocessing
|
| Apache Cassandra: Latency - Write median | Latency write to disk in milliseconds - median. |
JMX agent | jmx["org.apache.cassandra.metrics:name=WriteLatency,type=Table","50thPercentile"] Preprocessing
|
| Apache Cassandra: Latency - Write 75 percentile | Latency write to disk in milliseconds - p75. |
JMX agent | jmx["org.apache.cassandra.metrics:name=WriteLatency,type=Table","75thPercentile"] Preprocessing
|
| Apache Cassandra: Latency - Write 95 percentile | Latency write to disk in milliseconds - p95. |
JMX agent | jmx["org.apache.cassandra.metrics:name=WriteLatency,type=Table","95thPercentile"] Preprocessing
|
| Apache Cassandra: Latency - Client request read median | Total latency serving data to clients in milliseconds - median. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Read,name=Latency","50thPercentile"] Preprocessing
|
| Apache Cassandra: Latency - Client request read 75 percentile | Total latency serving data to clients in milliseconds - p75. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Read,name=Latency","75thPercentile"] Preprocessing
|
| Apache Cassandra: Latency - Client request read 95 percentile | Total latency serving data to clients in milliseconds - p95. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Read,name=Latency","95thPercentile"] Preprocessing
|
| Apache Cassandra: Latency - Client request write median | Total latency serving write requests from clients in milliseconds - median. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Write,name=Latency","50thPercentile"] Preprocessing
|
| Apache Cassandra: Latency - Client request write 75 percentile | Total latency serving write requests from clients in milliseconds - p75. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Write,name=Latency","75thPercentile"] Preprocessing
|
| Apache Cassandra: Latency - Client request write 95 percentile | Total latency serving write requests from clients in milliseconds - p95. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Write,name=Latency","95thPercentile"] Preprocessing
|
| Apache Cassandra: KeyCache - Capacity | Cache capacity in bytes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=Capacity","Value"] Preprocessing
|
| Apache Cassandra: KeyCache - Entries | Total number of cache entries. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=Entries","Value"] |
| Apache Cassandra: KeyCache - HitRate | All time cache hit rate. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=HitRate","Value"] Preprocessing
|
| Apache Cassandra: KeyCache - Hits per second | Rate of cache hits. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=Hits","Count"] Preprocessing
|
| Apache Cassandra: KeyCache - requests per second | Rate of cache requests. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=Requests","Count"] Preprocessing
|
| Apache Cassandra: KeyCache - Size | Total size of occupied cache, in bytes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=Size","Value"] |
| Apache Cassandra: Client connections - Native | Number of clients connected to this nodes native protocol server. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Client,name=connectedNativeClients","Value"] |
| Apache Cassandra: Client connections - Trifts | Number of connected to this nodes thrift clients. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Client,name=connectedThriftClients","Value"] |
| Apache Cassandra: Client request - Read per second | The number of client requests per second. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Read,name=Latency","Count"] Preprocessing
|
| Apache Cassandra: Client request - Write per second | The number of local write requests per second. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Write,name=Latency","Count"] Preprocessing
|
| Apache Cassandra: Client request - Write Timeouts | Number of write requests timeouts encountered. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Write,name=Timeouts","Count"] |
| Apache Cassandra: Thread pool.MutationStage - Pending tasks | Number of queued tasks queued up on this pool. MutationStage: Responsible for writes (exclude materialized and counter writes). |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=MutationStage,name=PendingTasks","Value"] |
| Apache Cassandra: Thread pool MutationStage - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. MutationStage: Responsible for writes (exclude materialized and counter writes). |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=MutationStage,name=CurrentlyBlockedTasks","Count"] |
| Apache Cassandra: Thread pool MutationStage - Total blocked tasks | Number of tasks that were blocked due to queue saturation. MutationStage: Responsible for writes (exclude materialized and counter writes). |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=MutationStage,name=TotalBlockedTasks","Count"] |
| Apache Cassandra: Thread pool CounterMutationStage - Pending tasks | Number of queued tasks queued up on this pool. CounterMutationStage: Responsible for counter writes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=CounterMutationStage,name=PendingTasks","Value"] |
| Apache Cassandra: Thread pool CounterMutationStage - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. CounterMutationStage: Responsible for counter writes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=CounterMutationStage,name=CurrentlyBlockedTasks","Count"] |
| Apache Cassandra: Thread pool CounterMutationStage - Total blocked tasks | Number of tasks that were blocked due to queue saturation. CounterMutationStage: Responsible for counter writes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=CounterMutationStage,name=TotalBlockedTasks","Count"] |
| Apache Cassandra: Thread pool ReadStage - Pending tasks | Number of queued tasks queued up on this pool. ReadStage: Local reads run on this thread pool. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ReadStage,name=PendingTasks","Value"] |
| Apache Cassandra: Thread pool ReadStage - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. ReadStage: Local reads run on this thread pool. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ReadStage,name=CurrentlyBlockedTasks","Count"] |
| Apache Cassandra: Thread pool ReadStage - Total blocked tasks | Number of tasks that were blocked due to queue saturation. ReadStage: Local reads run on this thread pool. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ReadStage,name=TotalBlockedTasks","Count"] |
| Apache Cassandra: Thread pool ViewMutationStage - Pending tasks | Number of queued tasks queued up on this pool. ViewMutationStage: Responsible for materialized view writes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ViewMutationStage,name=PendingTasks","Value"] |
| Apache Cassandra: Thread pool ViewMutationStage - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. ViewMutationStage: Responsible for materialized view writes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ViewMutationStage,name=CurrentlyBlockedTasks","Count"] |
| Apache Cassandra: Thread pool ViewMutationStage - Total blocked tasks | Number of tasks that were blocked due to queue saturation. ViewMutationStage: Responsible for materialized view writes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ViewMutationStage,name=TotalBlockedTasks","Count"] |
| Apache Cassandra: Thread pool MemtableFlushWriter - Pending tasks | Number of queued tasks queued up on this pool. MemtableFlushWriter: Writes memtables to disk. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtableFlushWriter,name=PendingTasks","Value"] |
| Apache Cassandra: Thread pool MemtableFlushWriter - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. MemtableFlushWriter: Writes memtables to disk. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtableFlushWriter,name=CurrentlyBlockedTasks","Count"] |
| Apache Cassandra: Thread pool MemtableFlushWriter - Total blocked tasks | Number of tasks that were blocked due to queue saturation. MemtableFlushWriter: Writes memtables to disk. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtableFlushWriter,name=TotalBlockedTasks","Count"] |
| Apache Cassandra: Thread pool HintsDispatcher - Pending tasks | Number of queued tasks queued up on this pool. HintsDispatcher: Performs hinted handoff. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=HintsDispatcher,name=PendingTasks","Value"] |
| Apache Cassandra: Thread pool HintsDispatcher - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. HintsDispatcher: Performs hinted handoff. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=HintsDispatcher,name=CurrentlyBlockedTasks","Count"] |
| Apache Cassandra: Thread pool HintsDispatcher - Total blocked tasks | Number of tasks that were blocked due to queue saturation. HintsDispatcher: Performs hinted handoff. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=HintsDispatcher,name=TotalBlockedTasks","Count"] |
| Apache Cassandra: Thread pool MemtablePostFlush - Pending tasks | Number of queued tasks queued up on this pool. MemtablePostFlush: Cleans up commit log after memtable is written to disk. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtablePostFlush,name=PendingTasks","Value"] |
| Apache Cassandra: Thread pool MemtablePostFlush - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. MemtablePostFlush: Cleans up commit log after memtable is written to disk. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtablePostFlush,name=CurrentlyBlockedTasks","Count"] |
| Apache Cassandra: Thread pool MemtablePostFlush - Total blocked tasks | Number of tasks that were blocked due to queue saturation. MemtablePostFlush: Cleans up commit log after memtable is written to disk. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtablePostFlush,name=TotalBlockedTasks","Count"] |
| Apache Cassandra: Thread pool MigrationStage - Pending tasks | Number of queued tasks queued up on this pool. MigrationStage: Runs schema migrations. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MigrationStage,name=PendingTasks","Value"] |
| Apache Cassandra: Thread pool MigrationStage - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. MigrationStage: Runs schema migrations. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MigrationStage,name=CurrentlyBlockedTasks","Count"] |
| Apache Cassandra: Thread pool MigrationStage - Total blocked tasks | Number of tasks that were blocked due to queue saturation. MigrationStage: Runs schema migrations. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MigrationStage,name=TotalBlockedTasks","Count"] |
| Apache Cassandra: Thread pool MiscStage - Pending tasks | Number of queued tasks queued up on this pool. MiscStage: Miscellaneous tasks run here. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MiscStage,name=PendingTasks","Value"] |
| Apache Cassandra: Thread pool MiscStage - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. MiscStage: Miscellaneous tasks run here. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MiscStage,name=CurrentlyBlockedTasks","Count"] |
| Apache Cassandra: Thread pool MiscStage - Total blocked tasks | Number of tasks that were blocked due to queue saturation. MiscStage: Miscellaneous tasks run here. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MiscStage,name=TotalBlockedTasks","Count"] |
| Apache Cassandra: Thread pool SecondaryIndexManagement - Pending tasks | Number of queued tasks queued up on this pool. SecondaryIndexManagement: Performs updates to secondary indexes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=SecondaryIndexManagement,name=PendingTasks","Value"] |
| Apache Cassandra: Thread pool SecondaryIndexManagement - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. SecondaryIndexManagement: Performs updates to secondary indexes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=SecondaryIndexManagement,name=CurrentlyBlockedTasks","Count"] |
| Apache Cassandra: Thread pool SecondaryIndexManagement - Total blocked tasks | Number of tasks that were blocked due to queue saturation. SecondaryIndexManagement: Performs updates to secondary indexes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=SecondaryIndexManagement,name=TotalBlockedTasks","Count"] |
Triggers
| Name | Description | Expression | Severity | Dependencies and additional info |
|---|---|---|---|---|
| Apache Cassandra: There are down nodes in cluster | last(/Apache Cassandra by JMX/jmx["org.apache.cassandra.net:type=FailureDetector","DownEndpointCount"])>0 |
Average | ||
| Apache Cassandra: Version has changed | Cassandra version has changed. Acknowledge to close the problem manually. |
last(/Apache Cassandra by JMX/jmx["org.apache.cassandra.db:type=StorageService","ReleaseVersion"],#1)<>last(/Apache Cassandra by JMX/jmx["org.apache.cassandra.db:type=StorageService","ReleaseVersion"],#2) and length(last(/Apache Cassandra by JMX/jmx["org.apache.cassandra.db:type=StorageService","ReleaseVersion"]))>0 |
Info | Manual close: Yes |
| Apache Cassandra: Failed to fetch info data | Zabbix has not received data for items for the last 15 minutes |
nodata(/Apache Cassandra by JMX/jmx["org.apache.cassandra.metrics:type=Storage,name=Load","Count"],15m)=1 |
Warning | |
| Apache Cassandra: Too many storage exceptions | min(/Apache Cassandra by JMX/jmx["org.apache.cassandra.metrics:type=Storage,name=Exceptions","Count"],5m)>0 |
Warning | ||
| Apache Cassandra: Many pending tasks | min(/Apache Cassandra by JMX/jmx["org.apache.cassandra.metrics:type=Compaction,name=PendingTasks","Value"],15m)>{$CASSANDRA.PENDING_TASKS.MAX.WARN} |
Warning | Depends on:
|
|
| Apache Cassandra: Too many pending tasks | min(/Apache Cassandra by JMX/jmx["org.apache.cassandra.metrics:type=Compaction,name=PendingTasks","Value"],15m)>{$CASSANDRA.PENDING_TASKS.MAX.HIGH} |
Average |
LLD rule Tables
| Name | Description | Type | Key and additional info |
|---|---|---|---|
| Tables | Info about keyspaces and tables |
JMX agent | jmx.discovery[beans,"org.apache.cassandra.metrics:type=Table,keyspace=,scope=,name=ReadLatency"] |
Item prototypes for Tables
| Name | Description | Type | Key and additional info |
|---|---|---|---|
| {#JMXKEYSPACE}.{#JMXSCOPE}: SS Tables per read 75 percentile | The number of SSTable data files accessed per read - p75. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=SSTablesPerReadHistogram","75thPercentile"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: SS Tables per read 95 percentile | The number of SSTable data files accessed per read - p95. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=SSTablesPerReadHistogram","95thPercentile"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Tombstone scanned 75 percentile | Number of tombstones scanned per read - p75. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=TombstoneScannedHistogram","75thPercentile"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Tombstone scanned 95 percentile | Number of tombstones scanned per read - p95. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=TombstoneScannedHistogram","95thPercentile"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Waiting on free memtable space 75 percentile | The time spent waiting for free memtable space either on- or off-heap - p75. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=WaitingOnFreeMemtableSpace","75thPercentile"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Waiting on free memtable space95 percentile | The time spent waiting for free memtable space either on- or off-heap - p95. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=WaitingOnFreeMemtableSpace","95thPercentile"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Col update time delta75 percentile | The column update time delta - p75. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=ColUpdateTimeDeltaHistogram","75thPercentile"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Col update time delta 95 percentile | The column update time delta - p95. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=ColUpdateTimeDeltaHistogram","95thPercentile"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Bloom filter false ratio | The ratio of Bloom filter false positives to total checks. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=BloomFilterFalseRatio","Value"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Compression ratio | The compression ratio for all SSTables. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=CompressionRatio","Value"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: KeyCache hit rate | The key cache hit rate. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=KeyCacheHitRate","Value"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Live SS Table | Number of "live" (in use) SSTables. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=LiveSSTableCount","Value"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Max partition size | The size of the largest compacted partition. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=MaxPartitionSize","Value"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Mean partition size | The average size of compacted partition. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=MeanPartitionSize","Value"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Pending compactions | The number of pending compactions. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=PendingCompactions","Value"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Snapshots size | The disk space truly used by snapshots. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=SnapshotsSize","Value"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Compaction bytes written | The amount of data that was compacted since (re)start. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=CompactionBytesWritten","Count"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Bytes flushed | The amount of data that was flushed since (re)start. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=BytesFlushed","Count"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Pending flushes | The number of pending flushes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=PendingFlushes","Count"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Live disk space used | The disk space used by "live" SSTables (only counts in use files). |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=LiveDiskSpaceUsed","Count"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Disk space used | Disk space used. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=TotalDiskSpaceUsed","Count"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Out of row cache hits | The number of row cache hits that do not satisfy the query filter and went to disk. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=RowCacheHitOutOfRange","Count"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Row cache hits | The number of row cache hits. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=RowCacheHit","Count"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Row cache misses | The number of table row cache misses. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=RowCacheMiss","Count"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Read latency 75 percentile | Latency read from disk in milliseconds. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=ReadLatency","75thPercentile"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Read latency 95 percentile | Latency read from disk in milliseconds. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=ReadLatency","95thPercentile"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Read per second | The number of client requests per second. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=ReadLatency","Count"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Write latency 75 percentile | Latency write to disk in milliseconds. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=WriteLatency","75thPercentile"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Write latency 95 percentile | Latency write to disk in milliseconds. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=WriteLatency","95thPercentile"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Write per second | The number of local write requests per second. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=WriteLatency","Count"] Preprocessing
|
Feedback
Please report any issues with the template at https://support.zabbix.com
You can also provide feedback, discuss the template, or ask for help at ZABBIX forums
Apache Cassandra by JMX
Overview
For Zabbix version: 6.2 and higher
Official JMX Template for Apache Cassandra DBSM.
This template was tested on:
- Apache Cassandra, version 3.11.8
Setup
See Zabbix template operation for basic instructions.
This template works with standalone and cluster instances. Metrics are collected by JMX.
- Enable and configure JMX access to Apache cassandra. See documentation for instructions.
- Set the user name and password in host macros {$CASSANDRA.USER} and {$CASSANDRA.PASSWORD}.
Zabbix configuration
No specific Zabbix configuration is required.
Macros used
| Name | Description | Default |
|---|---|---|
| {$CASSANDRA.KEY_SPACE.MATCHES} | Filter of discoverable key spaces |
.* |
| {$CASSANDRA.KEY_SPACE.NOT_MATCHES} | Filter to exclude discovered key spaces |
`(system |
| {$CASSANDRA.PASSWORD} | - |
zabbix |
| {$CASSANDRA.PENDING_TASKS.MAX.HIGH} | - |
500 |
| {$CASSANDRA.PENDING_TASKS.MAX.WARN} | - |
350 |
| {$CASSANDRA.USER} | - |
zabbix |
Template links
There are no template links in this template.
Discovery rules
| Name | Description | Type | Key and additional info |
|---|---|---|---|
| Tables | Info about keyspaces and tables |
JMX | jmx.discovery[beans,"org.apache.cassandra.metrics:type=Table,keyspace=,scope=,name=ReadLatency"] Filter: AND- {#JMXKEYSPACE} MATCHES_REGEX - {#JMXKEYSPACE} NOT_MATCHES_REGEX |
Items collected
| Group | Name | Description | Type | Key and additional info |
|---|---|---|---|---|
| Cassandra | Cluster: Nodes down | - |
JMX | jmx["org.apache.cassandra.net:type=FailureDetector","DownEndpointCount"] Preprocessing: - DISCARD_UNCHANGED_HEARTBEAT: |
| Cassandra | Cluster: Nodes up | - |
JMX | jmx["org.apache.cassandra.net:type=FailureDetector","UpEndpointCount"] Preprocessing: - DISCARD_UNCHANGED_HEARTBEAT: |
| Cassandra | Cluster: Name | - |
JMX | jmx["org.apache.cassandra.db:type=StorageService","ClusterName"] Preprocessing: - DISCARD_UNCHANGED_HEARTBEAT: |
| Cassandra | Version | - |
JMX | jmx["org.apache.cassandra.db:type=StorageService","ReleaseVersion"] Preprocessing: - DISCARD_UNCHANGED_HEARTBEAT: |
| Cassandra | Dropped messages: Write (Mutation) | Number of dropped regular writes messages. |
JMX | jmx["org.apache.cassandra.metrics:type=DroppedMessage,scope=MUTATION,name=Dropped","Count"] |
| Cassandra | Dropped messages: Read | Number of dropped regular reads messages. |
JMX | jmx["org.apache.cassandra.metrics:type=DroppedMessage,scope=READ,name=Dropped","Count"] |
| Cassandra | Storage: Used (bytes) | Size, in bytes, of the on disk data size this node manages. |
JMX | jmx["org.apache.cassandra.metrics:type=Storage,name=Load","Count"] |
| Cassandra | Storage: Errors | Number of internal exceptions caught. Under normal exceptions this should be zero. |
JMX | jmx["org.apache.cassandra.metrics:type=Storage,name=Exceptions","Count"] |
| Cassandra | Storage: Hints | Number of hint messages written to this node since [re]start. Includes one entry for each host to be hinted per hint. |
JMX | jmx["org.apache.cassandra.metrics:type=Storage,name=TotalHints","Count"] |
| Cassandra | Compaction: Number of completed tasks | Number of completed compactions since server [re]start. |
JMX | jmx["org.apache.cassandra.metrics:name=CompletedTasks,type=Compaction","Value"] |
| Cassandra | Compaction: Total compactions completed | Throughput of completed compactions since server [re]start. |
JMX | jmx["org.apache.cassandra.metrics:name=TotalCompactionsCompleted,type=Compaction","Count"] |
| Cassandra | Compaction: Pending tasks | Estimated number of compactions remaining to perform. |
JMX | jmx["org.apache.cassandra.metrics:type=Compaction,name=PendingTasks","Value"] |
| Cassandra | Commitlog: Pending tasks | Number of commit log messages written but yet to be fsync'd. |
JMX | jmx["org.apache.cassandra.metrics:name=PendingTasks,type=CommitLog","Value"] |
| Cassandra | Commitlog: Total size | Current size, in bytes, used by all the commit log segments. |
JMX | jmx["org.apache.cassandra.metrics:name=TotalCommitLogSize,type=CommitLog","Value"] |
| Cassandra | Latency: Read median | Latency read from disk in milliseconds - median. |
JMX | jmx["org.apache.cassandra.metrics:name=ReadLatency,type=Table","50thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | Latency: Read 75 percentile | Latency read from disk in milliseconds - p75. |
JMX | jmx["org.apache.cassandra.metrics:name=ReadLatency,type=Table","75thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | Latency: Read 95 percentile | Latency read from disk in milliseconds - p95. |
JMX | jmx["org.apache.cassandra.metrics:name=ReadLatency,type=Table","95thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | Latency: Write median | Latency write to disk in milliseconds - median. |
JMX | jmx["org.apache.cassandra.metrics:name=WriteLatency,type=Table","50thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | Latency: Write 75 percentile | Latency write to disk in milliseconds - p75. |
JMX | jmx["org.apache.cassandra.metrics:name=WriteLatency,type=Table","75thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | Latency: Write 95 percentile | Latency write to disk in milliseconds - p95. |
JMX | jmx["org.apache.cassandra.metrics:name=WriteLatency,type=Table","95thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | Latency: Client request read median | Total latency serving data to clients in milliseconds - median. |
JMX | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Read,name=Latency","50thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | Latency: Client request read 75 percentile | Total latency serving data to clients in milliseconds - p75. |
JMX | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Read,name=Latency","75thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | Latency: Client request read 95 percentile | Total latency serving data to clients in milliseconds - p95. |
JMX | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Read,name=Latency","95thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | Latency: Client request write median | Total latency serving write requests from clients in milliseconds - median. |
JMX | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Write,name=Latency","50thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | Latency: Client request write 75 percentile | Total latency serving write requests from clients in milliseconds - p75. |
JMX | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Write,name=Latency","75thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | Latency: Client request write 95 percentile | Total latency serving write requests from clients in milliseconds - p95. |
JMX | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Write,name=Latency","95thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | KeyCache: Capacity | Cache capacity in bytes. |
JMX | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=Capacity","Value"] Preprocessing: - DISCARD_UNCHANGED_HEARTBEAT: |
| Cassandra | KeyCache: Entries | Total number of cache entries. |
JMX | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=Entries","Value"] |
| Cassandra | KeyCache: HitRate | All time cache hit rate. |
JMX | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=HitRate","Value"] Preprocessing: - MULTIPLIER: |
| Cassandra | KeyCache: Hits per second | Rate of cache hits. |
JMX | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=Hits","Count"] Preprocessing: - CHANGE_PER_SECOND |
| Cassandra | KeyCache: requests per second | Rate of cache requests. |
JMX | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=Requests","Count"] Preprocessing: - CHANGE_PER_SECOND |
| Cassandra | KeyCache: Size | Total size of occupied cache, in bytes. |
JMX | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=Size","Value"] |
| Cassandra | Client connections: Native | Number of clients connected to this nodes native protocol server. |
JMX | jmx["org.apache.cassandra.metrics:type=Client,name=connectedNativeClients","Value"] |
| Cassandra | Client connections: Trifts | Number of connected to this nodes thrift clients. |
JMX | jmx["org.apache.cassandra.metrics:type=Client,name=connectedThriftClients","Value"] |
| Cassandra | Client request: Read per second | The number of client requests per second. |
JMX | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Read,name=Latency","Count"] Preprocessing: - CHANGE_PER_SECOND |
| Cassandra | Client request: Write per second | The number of local write requests per second. |
JMX | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Write,name=Latency","Count"] Preprocessing: - CHANGE_PER_SECOND |
| Cassandra | Client request: Write Timeouts | Number of write requests timeouts encountered. |
JMX | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Write,name=Timeouts","Count"] |
| Cassandra | Thread pool.MutationStage: Pending tasks | Number of queued tasks queued up on this pool. MutationStage: Responsible for writes (exclude materialized and counter writes). |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=MutationStage,name=PendingTasks","Value"] |
| Cassandra | Thread pool MutationStage: Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. MutationStage: Responsible for writes (exclude materialized and counter writes). |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=MutationStage,name=CurrentlyBlockedTasks","Count"] |
| Cassandra | Thread pool MutationStage: Total blocked tasks | Number of tasks that were blocked due to queue saturation. MutationStage: Responsible for writes (exclude materialized and counter writes). |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=MutationStage,name=TotalBlockedTasks","Count"] |
| Cassandra | Thread pool CounterMutationStage: Pending tasks | Number of queued tasks queued up on this pool. CounterMutationStage: Responsible for counter writes. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=CounterMutationStage,name=PendingTasks","Value"] |
| Cassandra | Thread pool CounterMutationStage: Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. CounterMutationStage: Responsible for counter writes. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=CounterMutationStage,name=CurrentlyBlockedTasks","Count"] |
| Cassandra | Thread pool CounterMutationStage: Total blocked tasks | Number of tasks that were blocked due to queue saturation. CounterMutationStage: Responsible for counter writes. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=CounterMutationStage,name=TotalBlockedTasks","Count"] |
| Cassandra | Thread pool ReadStage: Pending tasks | Number of queued tasks queued up on this pool. ReadStage: Local reads run on this thread pool. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ReadStage,name=PendingTasks","Value"] |
| Cassandra | Thread pool ReadStage: Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. ReadStage: Local reads run on this thread pool. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ReadStage,name=CurrentlyBlockedTasks","Count"] |
| Cassandra | Thread pool ReadStage: Total blocked tasks | Number of tasks that were blocked due to queue saturation. ReadStage: Local reads run on this thread pool. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ReadStage,name=TotalBlockedTasks","Count"] |
| Cassandra | Thread pool ViewMutationStage: Pending tasks | Number of queued tasks queued up on this pool. ViewMutationStage: Responsible for materialized view writes. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ViewMutationStage,name=PendingTasks","Value"] |
| Cassandra | Thread pool ViewMutationStage: Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. ViewMutationStage: Responsible for materialized view writes. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ViewMutationStage,name=CurrentlyBlockedTasks","Count"] |
| Cassandra | Thread pool ViewMutationStage: Total blocked tasks | Number of tasks that were blocked due to queue saturation. ViewMutationStage: Responsible for materialized view writes. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ViewMutationStage,name=TotalBlockedTasks","Count"] |
| Cassandra | Thread pool MemtableFlushWriter: Pending tasks | Number of queued tasks queued up on this pool. MemtableFlushWriter: Writes memtables to disk. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtableFlushWriter,name=PendingTasks","Value"] |
| Cassandra | Thread pool MemtableFlushWriter: Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. MemtableFlushWriter: Writes memtables to disk. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtableFlushWriter,name=CurrentlyBlockedTasks","Count"] |
| Cassandra | Thread pool MemtableFlushWriter: Total blocked tasks | Number of tasks that were blocked due to queue saturation. MemtableFlushWriter: Writes memtables to disk. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtableFlushWriter,name=TotalBlockedTasks","Count"] |
| Cassandra | Thread pool HintsDispatcher: Pending tasks | Number of queued tasks queued up on this pool. HintsDispatcher: Performs hinted handoff. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=HintsDispatcher,name=PendingTasks","Value"] |
| Cassandra | Thread pool HintsDispatcher: Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. HintsDispatcher: Performs hinted handoff. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=HintsDispatcher,name=CurrentlyBlockedTasks","Count"] |
| Cassandra | Thread pool HintsDispatcher: Total blocked tasks | Number of tasks that were blocked due to queue saturation. HintsDispatcher: Performs hinted handoff. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=HintsDispatcher,name=TotalBlockedTasks","Count"] |
| Cassandra | Thread pool MemtablePostFlush: Pending tasks | Number of queued tasks queued up on this pool. MemtablePostFlush: Cleans up commit log after memtable is written to disk. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtablePostFlush,name=PendingTasks","Value"] |
| Cassandra | Thread pool MemtablePostFlush: Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. MemtablePostFlush: Cleans up commit log after memtable is written to disk. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtablePostFlush,name=CurrentlyBlockedTasks","Count"] |
| Cassandra | Thread pool MemtablePostFlush: Total blocked tasks | Number of tasks that were blocked due to queue saturation. MemtablePostFlush: Cleans up commit log after memtable is written to disk. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtablePostFlush,name=TotalBlockedTasks","Count"] |
| Cassandra | Thread pool MigrationStage: Pending tasks | Number of queued tasks queued up on this pool. MigrationStage: Runs schema migrations. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MigrationStage,name=PendingTasks","Value"] |
| Cassandra | Thread pool MigrationStage: Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. MigrationStage: Runs schema migrations. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MigrationStage,name=CurrentlyBlockedTasks","Count"] |
| Cassandra | Thread pool MigrationStage: Total blocked tasks | Number of tasks that were blocked due to queue saturation. MigrationStage: Runs schema migrations. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MigrationStage,name=TotalBlockedTasks","Count"] |
| Cassandra | Thread pool MiscStage: Pending tasks | Number of queued tasks queued up on this pool. MiscStage: Miscellaneous tasks run here. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MiscStage,name=PendingTasks","Value"] |
| Cassandra | Thread pool MiscStage: Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. MiscStage: Miscellaneous tasks run here. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MiscStage,name=CurrentlyBlockedTasks","Count"] |
| Cassandra | Thread pool MiscStage: Total blocked tasks | Number of tasks that were blocked due to queue saturation. MiscStage: Miscellaneous tasks run here. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MiscStage,name=TotalBlockedTasks","Count"] |
| Cassandra | Thread pool SecondaryIndexManagement: Pending tasks | Number of queued tasks queued up on this pool. SecondaryIndexManagement: Performs updates to secondary indexes. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=SecondaryIndexManagement,name=PendingTasks","Value"] |
| Cassandra | Thread pool SecondaryIndexManagement: Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. SecondaryIndexManagement: Performs updates to secondary indexes. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=SecondaryIndexManagement,name=CurrentlyBlockedTasks","Count"] |
| Cassandra | Thread pool SecondaryIndexManagement: Total blocked tasks | Number of tasks that were blocked due to queue saturation. SecondaryIndexManagement: Performs updates to secondary indexes. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=SecondaryIndexManagement,name=TotalBlockedTasks","Count"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: SS Tables per read 75 percentile | The number of SSTable data files accessed per read - p75. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=SSTablesPerReadHistogram","75thPercentile"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: SS Tables per read 95 percentile | The number of SSTable data files accessed per read - p95. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=SSTablesPerReadHistogram","95thPercentile"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Tombstone scanned 75 percentile | Number of tombstones scanned per read - p75. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=TombstoneScannedHistogram","75thPercentile"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Tombstone scanned 95 percentile | Number of tombstones scanned per read - p95. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=TombstoneScannedHistogram","95thPercentile"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Waiting on free memtable space 75 percentile | The time spent waiting for free memtable space either on- or off-heap - p75. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=WaitingOnFreeMemtableSpace","75thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Waiting on free memtable space95 percentile | The time spent waiting for free memtable space either on- or off-heap - p95. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=WaitingOnFreeMemtableSpace","95thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Col update time delta75 percentile | The column update time delta - p75. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=ColUpdateTimeDeltaHistogram","75thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Col update time delta 95 percentile | The column update time delta - p95. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=ColUpdateTimeDeltaHistogram","95thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Bloom filter false ratio | The ratio of Bloom filter false positives to total checks. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=BloomFilterFalseRatio","Value"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Compression ratio | The compression ratio for all SSTables. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=CompressionRatio","Value"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: KeyCache hit rate | The key cache hit rate. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=KeyCacheHitRate","Value"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Live SS Table | Number of "live" (in use) SSTables. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=LiveSSTableCount","Value"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Max sartition size | The size of the largest compacted partition. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=MaxPartitionSize","Value"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Mean partition size | The average size of compacted partition. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=MeanPartitionSize","Value"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Pending compactions | The number of pending compactions. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=PendingCompactions","Value"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Snapshots size | The disk space truly used by snapshots. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=SnapshotsSize","Value"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Compaction bytes written | The amount of data that was compacted since (re)start. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=CompactionBytesWritten","Count"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Bytes flushed | The amount of data that was flushed since (re)start. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=BytesFlushed","Count"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Pending flushes | The number of pending flushes. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=PendingFlushes","Count"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Live disk space used | The disk space used by "live" SSTables (only counts in use files). |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=LiveDiskSpaceUsed","Count"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Disk space used | Disk space used. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=TotalDiskSpaceUsed","Count"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Out of row cache hits | The number of row cache hits that do not satisfy the query filter and went to disk. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=RowCacheHitOutOfRange","Count"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Row cache hits | The number of row cache hits. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=RowCacheHit","Count"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Row cache misses | The number of table row cache misses. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=RowCacheMiss","Count"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Read latency 75 percentile | Latency read from disk in milliseconds. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=ReadLatency","75thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Read latency 95 percentile | Latency read from disk in milliseconds. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=ReadLatency","95thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Read per second | The number of client requests per second. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=ReadLatency","Count"] Preprocessing: - CHANGE_PER_SECOND |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Write latency 75 percentile | Latency write to disk in milliseconds. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=WriteLatency","75thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Write latency 95 percentile | Latency write to disk in milliseconds. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=WriteLatency","95thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Write per second | The number of local write requests per second. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=WriteLatency","Count"] Preprocessing: - CHANGE_PER_SECOND |
Triggers
| Name | Description | Expression | Severity | Dependencies and additional info |
|---|---|---|---|---|
| There are down nodes in cluster | - |
last(/Apache Cassandra by JMX/jmx["org.apache.cassandra.net:type=FailureDetector","DownEndpointCount"])>0 |
AVERAGE | |
| Version has changed | Cassandra version has changed. Ack to close. |
last(/Apache Cassandra by JMX/jmx["org.apache.cassandra.db:type=StorageService","ReleaseVersion"],#1)<>last(/Apache Cassandra by JMX/jmx["org.apache.cassandra.db:type=StorageService","ReleaseVersion"],#2) and length(last(/Apache Cassandra by JMX/jmx["org.apache.cassandra.db:type=StorageService","ReleaseVersion"]))>0 |
INFO | Manual close: YES |
| Failed to fetch info data | Zabbix has not received data for items for the last 15 minutes |
nodata(/Apache Cassandra by JMX/jmx["org.apache.cassandra.metrics:type=Storage,name=Load","Count"],15m)=1 |
WARNING | |
| Too many storage exceptions | - |
min(/Apache Cassandra by JMX/jmx["org.apache.cassandra.metrics:type=Storage,name=Exceptions","Count"],5m)>0 |
WARNING | |
| Many pending tasks | - |
min(/Apache Cassandra by JMX/jmx["org.apache.cassandra.metrics:type=Compaction,name=PendingTasks","Value"],15m)>{$CASSANDRA.PENDING_TASKS.MAX.WARN} |
WARNING | Depends on: - Too many pending tasks |
| Too many pending tasks | - |
min(/Apache Cassandra by JMX/jmx["org.apache.cassandra.metrics:type=Compaction,name=PendingTasks","Value"],15m)>{$CASSANDRA.PENDING_TASKS.MAX.HIGH} |
AVERAGE |
Feedback
Please report any issues with the template at https://support.zabbix.com
You can also provide feedback, discuss the template or ask for help with it at ZABBIX forums.
Apache Cassandra by JMX
Overview
This template is designed for the effortless deployment of Apache Cassandra monitoring by Zabbix via JMX and doesn't require any external scripts.
Requirements
Zabbix version: 6.0 and higher.
Tested versions
This template has been tested on:
- Apache Cassandra 3.11.8
Configuration
Zabbix should be configured according to the instructions in the Templates out of the box section.
Setup
This template works with standalone and cluster instances. Metrics are collected by JMX.
- Enable and configure JMX access to Apache cassandra. See documentation for instructions.
- Set the user name and password in host macros {$CASSANDRA.USER} and {$CASSANDRA.PASSWORD}.
Macros used
| Name | Description | Default |
|---|---|---|
| {$CASSANDRA.USER} | zabbix |
|
| {$CASSANDRA.PASSWORD} | zabbix |
|
| {$CASSANDRA.KEY_SPACE.MATCHES} | Filter of discoverable key spaces |
.* |
| {$CASSANDRA.KEY_SPACE.NOT_MATCHES} | Filter to exclude discovered key spaces |
(system|system_auth|system_distributed|system_schema) |
| {$CASSANDRA.PENDING_TASKS.MAX.HIGH} | 500 |
|
| {$CASSANDRA.PENDING_TASKS.MAX.WARN} | 350 |
Items
| Name | Description | Type | Key and additional info |
|---|---|---|---|
| Apache Cassandra: Cluster - Nodes down | JMX agent | jmx["org.apache.cassandra.net:type=FailureDetector","DownEndpointCount"] Preprocessing
|
|
| Apache Cassandra: Cluster - Nodes up | JMX agent | jmx["org.apache.cassandra.net:type=FailureDetector","UpEndpointCount"] Preprocessing
|
|
| Apache Cassandra: Cluster - Name | JMX agent | jmx["org.apache.cassandra.db:type=StorageService","ClusterName"] Preprocessing
|
|
| Apache Cassandra: Version | JMX agent | jmx["org.apache.cassandra.db:type=StorageService","ReleaseVersion"] Preprocessing
|
|
| Apache Cassandra: Dropped messages - Write (Mutation) | Number of dropped regular writes messages. |
JMX agent | jmx["org.apache.cassandra.metrics:type=DroppedMessage,scope=MUTATION,name=Dropped","Count"] |
| Apache Cassandra: Dropped messages - Read | Number of dropped regular reads messages. |
JMX agent | jmx["org.apache.cassandra.metrics:type=DroppedMessage,scope=READ,name=Dropped","Count"] |
| Apache Cassandra: Storage - Used (bytes) | Size, in bytes, of the on disk data size this node manages. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Storage,name=Load","Count"] |
| Apache Cassandra: Storage - Errors | Number of internal exceptions caught. Under normal exceptions this should be zero. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Storage,name=Exceptions","Count"] |
| Apache Cassandra: Storage - Hints | Number of hint messages written to this node since [re]start. Includes one entry for each host to be hinted per hint. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Storage,name=TotalHints","Count"] |
| Apache Cassandra: Compaction - Number of completed tasks | Number of completed compactions since server [re]start. |
JMX agent | jmx["org.apache.cassandra.metrics:name=CompletedTasks,type=Compaction","Value"] |
| Apache Cassandra: Compaction - Total compactions completed | Throughput of completed compactions since server [re]start. |
JMX agent | jmx["org.apache.cassandra.metrics:name=TotalCompactionsCompleted,type=Compaction","Count"] |
| Apache Cassandra: Compaction - Pending tasks | Estimated number of compactions remaining to perform. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Compaction,name=PendingTasks","Value"] |
| Apache Cassandra: Commitlog - Pending tasks | Number of commit log messages written but yet to be fsync'd. |
JMX agent | jmx["org.apache.cassandra.metrics:name=PendingTasks,type=CommitLog","Value"] |
| Apache Cassandra: Commitlog - Total size | Current size, in bytes, used by all the commit log segments. |
JMX agent | jmx["org.apache.cassandra.metrics:name=TotalCommitLogSize,type=CommitLog","Value"] |
| Apache Cassandra: Latency - Read median | Latency read from disk in milliseconds - median. |
JMX agent | jmx["org.apache.cassandra.metrics:name=ReadLatency,type=Table","50thPercentile"] Preprocessing
|
| Apache Cassandra: Latency - Read 75 percentile | Latency read from disk in milliseconds - p75. |
JMX agent | jmx["org.apache.cassandra.metrics:name=ReadLatency,type=Table","75thPercentile"] Preprocessing
|
| Apache Cassandra: Latency - Read 95 percentile | Latency read from disk in milliseconds - p95. |
JMX agent | jmx["org.apache.cassandra.metrics:name=ReadLatency,type=Table","95thPercentile"] Preprocessing
|
| Apache Cassandra: Latency - Write median | Latency write to disk in milliseconds - median. |
JMX agent | jmx["org.apache.cassandra.metrics:name=WriteLatency,type=Table","50thPercentile"] Preprocessing
|
| Apache Cassandra: Latency - Write 75 percentile | Latency write to disk in milliseconds - p75. |
JMX agent | jmx["org.apache.cassandra.metrics:name=WriteLatency,type=Table","75thPercentile"] Preprocessing
|
| Apache Cassandra: Latency - Write 95 percentile | Latency write to disk in milliseconds - p95. |
JMX agent | jmx["org.apache.cassandra.metrics:name=WriteLatency,type=Table","95thPercentile"] Preprocessing
|
| Apache Cassandra: Latency - Client request read median | Total latency serving data to clients in milliseconds - median. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Read,name=Latency","50thPercentile"] Preprocessing
|
| Apache Cassandra: Latency - Client request read 75 percentile | Total latency serving data to clients in milliseconds - p75. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Read,name=Latency","75thPercentile"] Preprocessing
|
| Apache Cassandra: Latency - Client request read 95 percentile | Total latency serving data to clients in milliseconds - p95. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Read,name=Latency","95thPercentile"] Preprocessing
|
| Apache Cassandra: Latency - Client request write median | Total latency serving write requests from clients in milliseconds - median. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Write,name=Latency","50thPercentile"] Preprocessing
|
| Apache Cassandra: Latency - Client request write 75 percentile | Total latency serving write requests from clients in milliseconds - p75. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Write,name=Latency","75thPercentile"] Preprocessing
|
| Apache Cassandra: Latency - Client request write 95 percentile | Total latency serving write requests from clients in milliseconds - p95. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Write,name=Latency","95thPercentile"] Preprocessing
|
| Apache Cassandra: KeyCache - Capacity | Cache capacity in bytes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=Capacity","Value"] Preprocessing
|
| Apache Cassandra: KeyCache - Entries | Total number of cache entries. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=Entries","Value"] |
| Apache Cassandra: KeyCache - HitRate | All time cache hit rate. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=HitRate","Value"] Preprocessing
|
| Apache Cassandra: KeyCache - Hits per second | Rate of cache hits. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=Hits","Count"] Preprocessing
|
| Apache Cassandra: KeyCache - requests per second | Rate of cache requests. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=Requests","Count"] Preprocessing
|
| Apache Cassandra: KeyCache - Size | Total size of occupied cache, in bytes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=Size","Value"] |
| Apache Cassandra: Client connections - Native | Number of clients connected to this nodes native protocol server. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Client,name=connectedNativeClients","Value"] |
| Apache Cassandra: Client connections - Trifts | Number of connected to this nodes thrift clients. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Client,name=connectedThriftClients","Value"] |
| Apache Cassandra: Client request - Read per second | The number of client requests per second. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Read,name=Latency","Count"] Preprocessing
|
| Apache Cassandra: Client request - Write per second | The number of local write requests per second. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Write,name=Latency","Count"] Preprocessing
|
| Apache Cassandra: Client request - Write Timeouts | Number of write requests timeouts encountered. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Write,name=Timeouts","Count"] |
| Apache Cassandra: Thread pool.MutationStage - Pending tasks | Number of queued tasks queued up on this pool. MutationStage: Responsible for writes (exclude materialized and counter writes). |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=MutationStage,name=PendingTasks","Value"] |
| Apache Cassandra: Thread pool MutationStage - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. MutationStage: Responsible for writes (exclude materialized and counter writes). |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=MutationStage,name=CurrentlyBlockedTasks","Count"] |
| Apache Cassandra: Thread pool MutationStage - Total blocked tasks | Number of tasks that were blocked due to queue saturation. MutationStage: Responsible for writes (exclude materialized and counter writes). |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=MutationStage,name=TotalBlockedTasks","Count"] |
| Apache Cassandra: Thread pool CounterMutationStage - Pending tasks | Number of queued tasks queued up on this pool. CounterMutationStage: Responsible for counter writes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=CounterMutationStage,name=PendingTasks","Value"] |
| Apache Cassandra: Thread pool CounterMutationStage - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. CounterMutationStage: Responsible for counter writes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=CounterMutationStage,name=CurrentlyBlockedTasks","Count"] |
| Apache Cassandra: Thread pool CounterMutationStage - Total blocked tasks | Number of tasks that were blocked due to queue saturation. CounterMutationStage: Responsible for counter writes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=CounterMutationStage,name=TotalBlockedTasks","Count"] |
| Apache Cassandra: Thread pool ReadStage - Pending tasks | Number of queued tasks queued up on this pool. ReadStage: Local reads run on this thread pool. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ReadStage,name=PendingTasks","Value"] |
| Apache Cassandra: Thread pool ReadStage - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. ReadStage: Local reads run on this thread pool. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ReadStage,name=CurrentlyBlockedTasks","Count"] |
| Apache Cassandra: Thread pool ReadStage - Total blocked tasks | Number of tasks that were blocked due to queue saturation. ReadStage: Local reads run on this thread pool. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ReadStage,name=TotalBlockedTasks","Count"] |
| Apache Cassandra: Thread pool ViewMutationStage - Pending tasks | Number of queued tasks queued up on this pool. ViewMutationStage: Responsible for materialized view writes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ViewMutationStage,name=PendingTasks","Value"] |
| Apache Cassandra: Thread pool ViewMutationStage - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. ViewMutationStage: Responsible for materialized view writes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ViewMutationStage,name=CurrentlyBlockedTasks","Count"] |
| Apache Cassandra: Thread pool ViewMutationStage - Total blocked tasks | Number of tasks that were blocked due to queue saturation. ViewMutationStage: Responsible for materialized view writes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ViewMutationStage,name=TotalBlockedTasks","Count"] |
| Apache Cassandra: Thread pool MemtableFlushWriter - Pending tasks | Number of queued tasks queued up on this pool. MemtableFlushWriter: Writes memtables to disk. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtableFlushWriter,name=PendingTasks","Value"] |
| Apache Cassandra: Thread pool MemtableFlushWriter - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. MemtableFlushWriter: Writes memtables to disk. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtableFlushWriter,name=CurrentlyBlockedTasks","Count"] |
| Apache Cassandra: Thread pool MemtableFlushWriter - Total blocked tasks | Number of tasks that were blocked due to queue saturation. MemtableFlushWriter: Writes memtables to disk. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtableFlushWriter,name=TotalBlockedTasks","Count"] |
| Apache Cassandra: Thread pool HintsDispatcher - Pending tasks | Number of queued tasks queued up on this pool. HintsDispatcher: Performs hinted handoff. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=HintsDispatcher,name=PendingTasks","Value"] |
| Apache Cassandra: Thread pool HintsDispatcher - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. HintsDispatcher: Performs hinted handoff. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=HintsDispatcher,name=CurrentlyBlockedTasks","Count"] |
| Apache Cassandra: Thread pool HintsDispatcher - Total blocked tasks | Number of tasks that were blocked due to queue saturation. HintsDispatcher: Performs hinted handoff. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=HintsDispatcher,name=TotalBlockedTasks","Count"] |
| Apache Cassandra: Thread pool MemtablePostFlush - Pending tasks | Number of queued tasks queued up on this pool. MemtablePostFlush: Cleans up commit log after memtable is written to disk. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtablePostFlush,name=PendingTasks","Value"] |
| Apache Cassandra: Thread pool MemtablePostFlush - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. MemtablePostFlush: Cleans up commit log after memtable is written to disk. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtablePostFlush,name=CurrentlyBlockedTasks","Count"] |
| Apache Cassandra: Thread pool MemtablePostFlush - Total blocked tasks | Number of tasks that were blocked due to queue saturation. MemtablePostFlush: Cleans up commit log after memtable is written to disk. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtablePostFlush,name=TotalBlockedTasks","Count"] |
| Apache Cassandra: Thread pool MigrationStage - Pending tasks | Number of queued tasks queued up on this pool. MigrationStage: Runs schema migrations. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MigrationStage,name=PendingTasks","Value"] |
| Apache Cassandra: Thread pool MigrationStage - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. MigrationStage: Runs schema migrations. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MigrationStage,name=CurrentlyBlockedTasks","Count"] |
| Apache Cassandra: Thread pool MigrationStage - Total blocked tasks | Number of tasks that were blocked due to queue saturation. MigrationStage: Runs schema migrations. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MigrationStage,name=TotalBlockedTasks","Count"] |
| Apache Cassandra: Thread pool MiscStage - Pending tasks | Number of queued tasks queued up on this pool. MiscStage: Miscellaneous tasks run here. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MiscStage,name=PendingTasks","Value"] |
| Apache Cassandra: Thread pool MiscStage - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. MiscStage: Miscellaneous tasks run here. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MiscStage,name=CurrentlyBlockedTasks","Count"] |
| Apache Cassandra: Thread pool MiscStage - Total blocked tasks | Number of tasks that were blocked due to queue saturation. MiscStage: Miscellaneous tasks run here. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MiscStage,name=TotalBlockedTasks","Count"] |
| Apache Cassandra: Thread pool SecondaryIndexManagement - Pending tasks | Number of queued tasks queued up on this pool. SecondaryIndexManagement: Performs updates to secondary indexes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=SecondaryIndexManagement,name=PendingTasks","Value"] |
| Apache Cassandra: Thread pool SecondaryIndexManagement - Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. SecondaryIndexManagement: Performs updates to secondary indexes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=SecondaryIndexManagement,name=CurrentlyBlockedTasks","Count"] |
| Apache Cassandra: Thread pool SecondaryIndexManagement - Total blocked tasks | Number of tasks that were blocked due to queue saturation. SecondaryIndexManagement: Performs updates to secondary indexes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=SecondaryIndexManagement,name=TotalBlockedTasks","Count"] |
Triggers
| Name | Description | Expression | Severity | Dependencies and additional info |
|---|---|---|---|---|
| Apache Cassandra: There are down nodes in cluster | last(/Apache Cassandra by JMX/jmx["org.apache.cassandra.net:type=FailureDetector","DownEndpointCount"])>0 |
Average | ||
| Apache Cassandra: Version has changed | Cassandra version has changed. Acknowledge to close the problem manually. |
last(/Apache Cassandra by JMX/jmx["org.apache.cassandra.db:type=StorageService","ReleaseVersion"],#1)<>last(/Apache Cassandra by JMX/jmx["org.apache.cassandra.db:type=StorageService","ReleaseVersion"],#2) and length(last(/Apache Cassandra by JMX/jmx["org.apache.cassandra.db:type=StorageService","ReleaseVersion"]))>0 |
Info | Manual close: Yes |
| Apache Cassandra: Failed to fetch info data | Zabbix has not received data for items for the last 15 minutes |
nodata(/Apache Cassandra by JMX/jmx["org.apache.cassandra.metrics:type=Storage,name=Load","Count"],15m)=1 |
Warning | |
| Apache Cassandra: Too many storage exceptions | min(/Apache Cassandra by JMX/jmx["org.apache.cassandra.metrics:type=Storage,name=Exceptions","Count"],5m)>0 |
Warning | ||
| Apache Cassandra: Many pending tasks | min(/Apache Cassandra by JMX/jmx["org.apache.cassandra.metrics:type=Compaction,name=PendingTasks","Value"],15m)>{$CASSANDRA.PENDING_TASKS.MAX.WARN} |
Warning | Depends on:
|
|
| Apache Cassandra: Too many pending tasks | min(/Apache Cassandra by JMX/jmx["org.apache.cassandra.metrics:type=Compaction,name=PendingTasks","Value"],15m)>{$CASSANDRA.PENDING_TASKS.MAX.HIGH} |
Average |
LLD rule Tables
| Name | Description | Type | Key and additional info |
|---|---|---|---|
| Tables | Info about keyspaces and tables |
JMX agent | jmx.discovery[beans,"org.apache.cassandra.metrics:type=Table,keyspace=,scope=,name=ReadLatency"] |
Item prototypes for Tables
| Name | Description | Type | Key and additional info |
|---|---|---|---|
| {#JMXKEYSPACE}.{#JMXSCOPE}: SS Tables per read 75 percentile | The number of SSTable data files accessed per read - p75. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=SSTablesPerReadHistogram","75thPercentile"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: SS Tables per read 95 percentile | The number of SSTable data files accessed per read - p95. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=SSTablesPerReadHistogram","95thPercentile"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Tombstone scanned 75 percentile | Number of tombstones scanned per read - p75. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=TombstoneScannedHistogram","75thPercentile"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Tombstone scanned 95 percentile | Number of tombstones scanned per read - p95. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=TombstoneScannedHistogram","95thPercentile"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Waiting on free memtable space 75 percentile | The time spent waiting for free memtable space either on- or off-heap - p75. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=WaitingOnFreeMemtableSpace","75thPercentile"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Waiting on free memtable space95 percentile | The time spent waiting for free memtable space either on- or off-heap - p95. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=WaitingOnFreeMemtableSpace","95thPercentile"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Col update time delta75 percentile | The column update time delta - p75. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=ColUpdateTimeDeltaHistogram","75thPercentile"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Col update time delta 95 percentile | The column update time delta - p95. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=ColUpdateTimeDeltaHistogram","95thPercentile"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Bloom filter false ratio | The ratio of Bloom filter false positives to total checks. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=BloomFilterFalseRatio","Value"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Compression ratio | The compression ratio for all SSTables. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=CompressionRatio","Value"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: KeyCache hit rate | The key cache hit rate. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=KeyCacheHitRate","Value"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Live SS Table | Number of "live" (in use) SSTables. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=LiveSSTableCount","Value"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Max partition size | The size of the largest compacted partition. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=MaxPartitionSize","Value"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Mean partition size | The average size of compacted partition. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=MeanPartitionSize","Value"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Pending compactions | The number of pending compactions. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=PendingCompactions","Value"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Snapshots size | The disk space truly used by snapshots. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=SnapshotsSize","Value"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Compaction bytes written | The amount of data that was compacted since (re)start. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=CompactionBytesWritten","Count"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Bytes flushed | The amount of data that was flushed since (re)start. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=BytesFlushed","Count"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Pending flushes | The number of pending flushes. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=PendingFlushes","Count"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Live disk space used | The disk space used by "live" SSTables (only counts in use files). |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=LiveDiskSpaceUsed","Count"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Disk space used | Disk space used. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=TotalDiskSpaceUsed","Count"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Out of row cache hits | The number of row cache hits that do not satisfy the query filter and went to disk. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=RowCacheHitOutOfRange","Count"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Row cache hits | The number of row cache hits. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=RowCacheHit","Count"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Row cache misses | The number of table row cache misses. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=RowCacheMiss","Count"] |
| {#JMXKEYSPACE}.{#JMXSCOPE}: Read latency 75 percentile | Latency read from disk in milliseconds. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=ReadLatency","75thPercentile"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Read latency 95 percentile | Latency read from disk in milliseconds. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=ReadLatency","95thPercentile"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Read per second | The number of client requests per second. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=ReadLatency","Count"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Write latency 75 percentile | Latency write to disk in milliseconds. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=WriteLatency","75thPercentile"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Write latency 95 percentile | Latency write to disk in milliseconds. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=WriteLatency","95thPercentile"] Preprocessing
|
| {#JMXKEYSPACE}.{#JMXSCOPE}: Write per second | The number of local write requests per second. |
JMX agent | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=WriteLatency","Count"] Preprocessing
|
Feedback
Please report any issues with the template at https://support.zabbix.com
You can also provide feedback, discuss the template, or ask for help at ZABBIX forums
Apache Cassandra by JMX
Overview
For Zabbix version: 5.4 and higher
Official JMX Template for Apache Cassandra DBSM.
This template was tested on:
- Apache Cassandra, version 3.11.8
Setup
See Zabbix template operation for basic instructions.
This template works with standalone and cluster instances. Metrics are collected by JMX.
- Enable and configure JMX access to Apache cassandra. See documentation for instructions.
- Set the user name and password in host macros {$CASSANDRA.USER} and {$CASSANDRA.PASSWORD}.
Zabbix configuration
No specific Zabbix configuration is required.
Macros used
| Name | Description | Default |
|---|---|---|
| {$CASSANDRA.KEY_SPACE.MATCHES} | Filter of discoverable key spaces |
.* |
| {$CASSANDRA.KEY_SPACE.NOT_MATCHES} | Filter to exclude discovered key spaces |
`(system |
| {$CASSANDRA.PASSWORD} | - |
zabbix |
| {$CASSANDRA.PENDING_TASKS.MAX.HIGH} | - |
500 |
| {$CASSANDRA.PENDING_TASKS.MAX.WARN} | - |
350 |
| {$CASSANDRA.USER} | - |
zabbix |
Template links
There are no template links in this template.
Discovery rules
| Name | Description | Type | Key and additional info |
|---|---|---|---|
| Tables | Info about keyspaces and tables |
JMX | jmx.discovery[beans,"org.apache.cassandra.metrics:type=Table,keyspace=,scope=,name=ReadLatency"] Filter: AND- {#JMXKEYSPACE} MATCHES_REGEX - {#JMXKEYSPACE} NOT_MATCHES_REGEX |
Items collected
| Group | Name | Description | Type | Key and additional info |
|---|---|---|---|---|
| Cassandra | Cluster: Nodes down | - |
JMX | jmx["org.apache.cassandra.net:type=FailureDetector","DownEndpointCount"] Preprocessing: - DISCARD_UNCHANGED_HEARTBEAT: |
| Cassandra | Cluster: Nodes up | - |
JMX | jmx["org.apache.cassandra.net:type=FailureDetector","UpEndpointCount"] Preprocessing: - DISCARD_UNCHANGED_HEARTBEAT: |
| Cassandra | Cluster: Name | - |
JMX | jmx["org.apache.cassandra.db:type=StorageService","ClusterName"] Preprocessing: - DISCARD_UNCHANGED_HEARTBEAT: |
| Cassandra | Version | - |
JMX | jmx["org.apache.cassandra.db:type=StorageService","ReleaseVersion"] Preprocessing: - DISCARD_UNCHANGED_HEARTBEAT: |
| Cassandra | Dropped messages: Write (Mutation) | Number of dropped regular writes messages. |
JMX | jmx["org.apache.cassandra.metrics:type=DroppedMessage,scope=MUTATION,name=Dropped","Count"] |
| Cassandra | Dropped messages: Read | Number of dropped regular reads messages. |
JMX | jmx["org.apache.cassandra.metrics:type=DroppedMessage,scope=READ,name=Dropped","Count"] |
| Cassandra | Storage: Used (bytes) | Size, in bytes, of the on disk data size this node manages. |
JMX | jmx["org.apache.cassandra.metrics:type=Storage,name=Load","Count"] |
| Cassandra | Storage: Errors | Number of internal exceptions caught. Under normal exceptions this should be zero. |
JMX | jmx["org.apache.cassandra.metrics:type=Storage,name=Exceptions","Count"] |
| Cassandra | Storage: Hints | Number of hint messages written to this node since [re]start. Includes one entry for each host to be hinted per hint. |
JMX | jmx["org.apache.cassandra.metrics:type=Storage,name=TotalHints","Count"] |
| Cassandra | Compaction: Number of completed tasks | Number of completed compactions since server [re]start. |
JMX | jmx["org.apache.cassandra.metrics:name=CompletedTasks,type=Compaction","Value"] |
| Cassandra | Compaction: Total compactions completed | Throughput of completed compactions since server [re]start. |
JMX | jmx["org.apache.cassandra.metrics:name=TotalCompactionsCompleted,type=Compaction","Count"] |
| Cassandra | Compaction: Pending tasks | Estimated number of compactions remaining to perform. |
JMX | jmx["org.apache.cassandra.metrics:type=Compaction,name=PendingTasks","Value"] |
| Cassandra | Commitlog: Pending tasks | Number of commit log messages written but yet to be fsync'd. |
JMX | jmx["org.apache.cassandra.metrics:name=PendingTasks,type=CommitLog","Value"] |
| Cassandra | Commitlog: Total size | Current size, in bytes, used by all the commit log segments. |
JMX | jmx["org.apache.cassandra.metrics:name=TotalCommitLogSize,type=CommitLog","Value"] |
| Cassandra | Latency: Read median | Latency read from disk in milliseconds - median. |
JMX | jmx["org.apache.cassandra.metrics:name=ReadLatency,type=Table","50thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | Latency: Read 75 percentile | Latency read from disk in milliseconds - p75. |
JMX | jmx["org.apache.cassandra.metrics:name=ReadLatency,type=Table","75thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | Latency: Read 95 percentile | Latency read from disk in milliseconds - p95. |
JMX | jmx["org.apache.cassandra.metrics:name=ReadLatency,type=Table","95thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | Latency: Write median | Latency write to disk in milliseconds - median. |
JMX | jmx["org.apache.cassandra.metrics:name=WriteLatency,type=Table","50thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | Latency: Write 75 percentile | Latency write to disk in milliseconds - p75. |
JMX | jmx["org.apache.cassandra.metrics:name=WriteLatency,type=Table","75thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | Latency: Write 95 percentile | Latency write to disk in milliseconds - p95. |
JMX | jmx["org.apache.cassandra.metrics:name=WriteLatency,type=Table","95thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | Latency: Client request read median | Total latency serving data to clients in milliseconds - median. |
JMX | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Read,name=Latency","50thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | Latency: Client request read 75 percentile | Total latency serving data to clients in milliseconds - p75. |
JMX | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Read,name=Latency","75thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | Latency: Client request read 95 percentile | Total latency serving data to clients in milliseconds - p95. |
JMX | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Read,name=Latency","95thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | Latency: Client request write median | Total latency serving write requests from clients in milliseconds - median. |
JMX | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Write,name=Latency","50thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | Latency: Client request write 75 percentile | Total latency serving write requests from clients in milliseconds - p75. |
JMX | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Write,name=Latency","75thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | Latency: Client request write 95 percentile | Total latency serving write requests from clients in milliseconds - p95. |
JMX | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Write,name=Latency","95thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | KeyCache: Capacity | Cache capacity in bytes. |
JMX | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=Capacity","Value"] Preprocessing: - DISCARD_UNCHANGED_HEARTBEAT: |
| Cassandra | KeyCache: Entries | Total number of cache entries. |
JMX | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=Entries","Value"] |
| Cassandra | KeyCache: HitRate | All time cache hit rate. |
JMX | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=HitRate","Value"] Preprocessing: - MULTIPLIER: |
| Cassandra | KeyCache: Hits per second | Rate of cache hits. |
JMX | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=Hits","Count"] Preprocessing: - CHANGE_PER_SECOND |
| Cassandra | KeyCache: requests per second | Rate of cache requests. |
JMX | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=Requests","Count"] Preprocessing: - CHANGE_PER_SECOND |
| Cassandra | KeyCache: Size | Total size of occupied cache, in bytes. |
JMX | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=Size","Value"] |
| Cassandra | Client connections: Native | Number of clients connected to this nodes native protocol server. |
JMX | jmx["org.apache.cassandra.metrics:type=Client,name=connectedNativeClients","Value"] |
| Cassandra | Client connections: Trifts | Number of connected to this nodes thrift clients. |
JMX | jmx["org.apache.cassandra.metrics:type=Client,name=connectedThriftClients","Value"] |
| Cassandra | Client request: Read per second | The number of client requests per second. |
JMX | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Read,name=Latency","Count"] Preprocessing: - CHANGE_PER_SECOND |
| Cassandra | Client request: Write per second | The number of local write requests per second. |
JMX | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Write,name=Latency","Count"] Preprocessing: - CHANGE_PER_SECOND |
| Cassandra | Client request: Write Timeouts | Number of write requests timeouts encountered. |
JMX | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Write,name=Timeouts","Count"] |
| Cassandra | Thread pool.MutationStage: Pending tasks | Number of queued tasks queued up on this pool. MutationStage: Responsible for writes (exclude materialized and counter writes). |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=MutationStage,name=PendingTasks","Value"] |
| Cassandra | Thread pool MutationStage: Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. MutationStage: Responsible for writes (exclude materialized and counter writes). |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=MutationStage,name=CurrentlyBlockedTasks","Count"] |
| Cassandra | Thread pool MutationStage: Total blocked tasks | Number of tasks that were blocked due to queue saturation. MutationStage: Responsible for writes (exclude materialized and counter writes). |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=MutationStage,name=TotalBlockedTasks","Count"] |
| Cassandra | Thread pool CounterMutationStage: Pending tasks | Number of queued tasks queued up on this pool. CounterMutationStage: Responsible for counter writes. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=CounterMutationStage,name=PendingTasks","Value"] |
| Cassandra | Thread pool CounterMutationStage: Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. CounterMutationStage: Responsible for counter writes. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=CounterMutationStage,name=CurrentlyBlockedTasks","Count"] |
| Cassandra | Thread pool CounterMutationStage: Total blocked tasks | Number of tasks that were blocked due to queue saturation. CounterMutationStage: Responsible for counter writes. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=CounterMutationStage,name=TotalBlockedTasks","Count"] |
| Cassandra | Thread pool ReadStage: Pending tasks | Number of queued tasks queued up on this pool. ReadStage: Local reads run on this thread pool. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ReadStage,name=PendingTasks","Value"] |
| Cassandra | Thread pool ReadStage: Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. ReadStage: Local reads run on this thread pool. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ReadStage,name=CurrentlyBlockedTasks","Count"] |
| Cassandra | Thread pool ReadStage: Total blocked tasks | Number of tasks that were blocked due to queue saturation. ReadStage: Local reads run on this thread pool. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ReadStage,name=TotalBlockedTasks","Count"] |
| Cassandra | Thread pool ViewMutationStage: Pending tasks | Number of queued tasks queued up on this pool. ViewMutationStage: Responsible for materialized view writes. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ViewMutationStage,name=PendingTasks","Value"] |
| Cassandra | Thread pool ViewMutationStage: Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. ViewMutationStage: Responsible for materialized view writes. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ViewMutationStage,name=CurrentlyBlockedTasks","Count"] |
| Cassandra | Thread pool ViewMutationStage: Total blocked tasks | Number of tasks that were blocked due to queue saturation. ViewMutationStage: Responsible for materialized view writes. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ViewMutationStage,name=TotalBlockedTasks","Count"] |
| Cassandra | Thread pool MemtableFlushWriter: Pending tasks | Number of queued tasks queued up on this pool. MemtableFlushWriter: Writes memtables to disk. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtableFlushWriter,name=PendingTasks","Value"] |
| Cassandra | Thread pool MemtableFlushWriter: Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. MemtableFlushWriter: Writes memtables to disk. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtableFlushWriter,name=CurrentlyBlockedTasks","Count"] |
| Cassandra | Thread pool MemtableFlushWriter: Total blocked tasks | Number of tasks that were blocked due to queue saturation. MemtableFlushWriter: Writes memtables to disk. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtableFlushWriter,name=TotalBlockedTasks","Count"] |
| Cassandra | Thread pool HintsDispatcher: Pending tasks | Number of queued tasks queued up on this pool. HintsDispatcher: Performs hinted handoff. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=HintsDispatcher,name=PendingTasks","Value"] |
| Cassandra | Thread pool HintsDispatcher: Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. HintsDispatcher: Performs hinted handoff. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=HintsDispatcher,name=CurrentlyBlockedTasks","Count"] |
| Cassandra | Thread pool HintsDispatcher: Total blocked tasks | Number of tasks that were blocked due to queue saturation. HintsDispatcher: Performs hinted handoff. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=HintsDispatcher,name=TotalBlockedTasks","Count"] |
| Cassandra | Thread pool MemtablePostFlush: Pending tasks | Number of queued tasks queued up on this pool. MemtablePostFlush: Cleans up commit log after memtable is written to disk. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtablePostFlush,name=PendingTasks","Value"] |
| Cassandra | Thread pool MemtablePostFlush: Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. MemtablePostFlush: Cleans up commit log after memtable is written to disk. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtablePostFlush,name=CurrentlyBlockedTasks","Count"] |
| Cassandra | Thread pool MemtablePostFlush: Total blocked tasks | Number of tasks that were blocked due to queue saturation. MemtablePostFlush: Cleans up commit log after memtable is written to disk. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtablePostFlush,name=TotalBlockedTasks","Count"] |
| Cassandra | Thread pool MigrationStage: Pending tasks | Number of queued tasks queued up on this pool. MigrationStage: Runs schema migrations. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MigrationStage,name=PendingTasks","Value"] |
| Cassandra | Thread pool MigrationStage: Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. MigrationStage: Runs schema migrations. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MigrationStage,name=CurrentlyBlockedTasks","Count"] |
| Cassandra | Thread pool MigrationStage: Total blocked tasks | Number of tasks that were blocked due to queue saturation. MigrationStage: Runs schema migrations. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MigrationStage,name=TotalBlockedTasks","Count"] |
| Cassandra | Thread pool MiscStage: Pending tasks | Number of queued tasks queued up on this pool. MiscStage: Misceleneous tasks run here. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MiscStage,name=PendingTasks","Value"] |
| Cassandra | Thread pool MiscStage: Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. MiscStage: Misceleneous tasks run here. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MiscStage,name=CurrentlyBlockedTasks","Count"] |
| Cassandra | Thread pool MiscStage: Total blocked tasks | Number of tasks that were blocked due to queue saturation. MiscStage: Misceleneous tasks run here. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MiscStage,name=TotalBlockedTasks","Count"] |
| Cassandra | Thread pool SecondaryIndexManagement: Pending tasks | Number of queued tasks queued up on this pool. SecondaryIndexManagement: Performs updates to secondary indexes. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=SecondaryIndexManagement,name=PendingTasks","Value"] |
| Cassandra | Thread pool SecondaryIndexManagement: Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. SecondaryIndexManagement: Performs updates to secondary indexes. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=SecondaryIndexManagement,name=CurrentlyBlockedTasks","Count"] |
| Cassandra | Thread pool SecondaryIndexManagement: Total blocked tasks | Number of tasks that were blocked due to queue saturation. SecondaryIndexManagement: Performs updates to secondary indexes. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=SecondaryIndexManagement,name=TotalBlockedTasks","Count"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: SS Tables per read 75 percentile | The number of SSTable data files accessed per read - p75. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=SSTablesPerReadHistogram","75thPercentile"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: SS Tables per read 95 percentile | The number of SSTable data files accessed per read - p95. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=SSTablesPerReadHistogram","95thPercentile"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Tombstone scanned 75 percentile | Number of tombstones scanned per read - p75. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=TombstoneScannedHistogram","75thPercentile"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Tombstone scanned 95 percentile | Number of tombstones scanned per read - p95. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=TombstoneScannedHistogram","95thPercentile"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Waiting on free memtable space 75 percentile | The time spent waiting for free memtable space either on- or off-heap - p75. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=WaitingOnFreeMemtableSpace","75thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Waiting on free memtable space95 percentile | The time spent waiting for free memtable space either on- or off-heap - p95. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=WaitingOnFreeMemtableSpace","95thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Col update time delta75 percentile | The column update time delta - p75. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=ColUpdateTimeDeltaHistogram","75thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Col update time delta 95 percentile | The column update time delta - p95. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=ColUpdateTimeDeltaHistogram","95thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Bloom filter false ratio | The ratio of Bloom filter false positives to total checks. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=BloomFilterFalseRatio","Value"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Compression ratio | The compression ratio for all SSTables. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=CompressionRatio","Value"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: KeyCache hit rate | The key cache hit rate. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=KeyCacheHitRate","Value"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Live SS Table | Number of "live" (in use) SSTables. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=LiveSSTableCount","Value"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Max sartition size | The size of the largest compacted partition. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=MaxPartitionSize","Value"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Mean partition size | The average size of compacted partition. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=MeanPartitionSize","Value"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Pending compactions | The number of pending compactions. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=PendingCompactions","Value"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Snapshots size | The disk space truly used by snapshots. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=SnapshotsSize","Value"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Compaction bytes written | The amount of data that was compacted since (re)start. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=CompactionBytesWritten","Count"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Bytes flushed | The amount of data that was flushed since (re)start. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=BytesFlushed","Count"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Pending flushes | The number of pending flushes. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=PendingFlushes","Count"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Live disk space used | The disk space used by "live" SSTables (only counts in use files). |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=LiveDiskSpaceUsed","Count"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Disk space used | Disk space used. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=TotalDiskSpaceUsed","Count"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Out of row cache hits | The number of row cache hits that do not satisfy the query filter and went to disk. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=RowCacheHitOutOfRange","Count"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Row cache hits | The number of row cache hits. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=RowCacheHit","Count"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Row cache misses | The number of table row cache misses. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=RowCacheMiss","Count"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Read latency 75 percentile | Latency read from disk in milliseconds. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=ReadLatency","75thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Read latency 95 percentile | Latency read from disk in milliseconds. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=ReadLatency","95thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Read per second | The number of client requests per second. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=ReadLatency","Count"] Preprocessing: - CHANGE_PER_SECOND |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Write latency 75 percentile | Latency write to disk in milliseconds. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=WriteLatency","75thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Write latency 95 percentile | Latency write to disk in milliseconds. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=WriteLatency","95thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Write per second | The number of local write requests per second. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=WriteLatency","Count"] Preprocessing: - CHANGE_PER_SECOND |
Triggers
| Name | Description | Expression | Severity | Dependencies and additional info |
|---|---|---|---|---|
| There are down nodes in cluster | - |
last(/Apache Cassandra by JMX/jmx["org.apache.cassandra.net:type=FailureDetector","DownEndpointCount"])>0 |
AVERAGE | |
| Version has changed (new version: {ITEM.VALUE}) | Cassandra version has changed. Ack to close. |
last(/Apache Cassandra by JMX/jmx["org.apache.cassandra.db:type=StorageService","ReleaseVersion"],#1)<>last(/Apache Cassandra by JMX/jmx["org.apache.cassandra.db:type=StorageService","ReleaseVersion"],#2) and length(last(/Apache Cassandra by JMX/jmx["org.apache.cassandra.db:type=StorageService","ReleaseVersion"]))>0 |
INFO | Manual close: YES |
| Failed to fetch info data (or no data for 15m) | Zabbix has not received data for items for the last 15 minutes |
nodata(/Apache Cassandra by JMX/jmx["org.apache.cassandra.metrics:type=Storage,name=Load","Count"],15m)=1 |
WARNING | |
| Too many storage exceptions | - |
min(/Apache Cassandra by JMX/jmx["org.apache.cassandra.metrics:type=Storage,name=Exceptions","Count"],5m)>0 |
WARNING | |
| Many pending tasks (over {$CASSANDRA.PENDING_TASKS.MAX.WARN} for 15m) | - |
min(/Apache Cassandra by JMX/jmx["org.apache.cassandra.metrics:type=Compaction,name=PendingTasks","Value"],15m)>{$CASSANDRA.PENDING_TASKS.MAX.WARN} |
WARNING | Depends on: - Too many pending tasks (over {$CASSANDRA.PENDING_TASKS.MAX.HIGH} for 15m) |
| Too many pending tasks (over {$CASSANDRA.PENDING_TASKS.MAX.HIGH} for 15m) | - |
min(/Apache Cassandra by JMX/jmx["org.apache.cassandra.metrics:type=Compaction,name=PendingTasks","Value"],15m)>{$CASSANDRA.PENDING_TASKS.MAX.HIGH} |
AVERAGE |
Feedback
Please report any issues with the template at https://support.zabbix.com
You can also provide a feedback, discuss the template or ask for help with it at ZABBIX forums.
Template DB Apache Cassandra by JMX
Overview
For Zabbix version: 5.0 and higher
Official JMX Template for Apache Cassandra DBSM.
This template was tested on:
- Apache Cassandra, version 3.11.8
- Zabbix, version 5.0, 5.2
Setup
See Zabbix template operation for basic instructions.
This template works with standalone and cluster instances. Metrics are collected by JMX.
- Enable and configure JMX access to Apache cassandra. See documentation for instructions.
- Set the user name and password in host macros {$CASSANDRA.USER} and {$CASSANDRA.PASSWORD}.
Zabbix configuration
No specific Zabbix configuration is required.
Macros used
| Name | Description | Default |
|---|---|---|
| {$CASSANDRA.KEY_SPACE.MATCHES} | Filter of discoverable key spaces |
.* |
| {$CASSANDRA.KEY_SPACE.NOT_MATCHES} | Filter to exclude discovered key spaces |
`(system |
| {$CASSANDRA.PASSWORD} | - |
zabbix |
| {$CASSANDRA.PENDING_TASKS.MAX.HIGH} | - |
500 |
| {$CASSANDRA.PENDING_TASKS.MAX.WARN} | - |
350 |
| {$CASSANDRA.USER} | - |
zabbix |
Template links
There are no template links in this template.
Discovery rules
| Name | Description | Type | Key and additional info |
|---|---|---|---|
| Tables | Info about keyspaces and tables |
JMX | jmx.discovery[beans,"org.apache.cassandra.metrics:type=Table,keyspace=,scope=,name=ReadLatency"] Filter: AND- A: {#JMXKEYSPACE} MATCHES_REGEX - B: {#JMXKEYSPACE} NOT_MATCHES_REGEX |
Items collected
| Group | Name | Description | Type | Key and additional info |
|---|---|---|---|---|
| Cassandra | Cluster: Nodes down | - |
JMX | jmx["org.apache.cassandra.net:type=FailureDetector","DownEndpointCount"] Preprocessing: - DISCARD_UNCHANGED_HEARTBEAT: |
| Cassandra | Cluster: Nodes up | - |
JMX | jmx["org.apache.cassandra.net:type=FailureDetector","UpEndpointCount"] Preprocessing: - DISCARD_UNCHANGED_HEARTBEAT: |
| Cassandra | Cluster: Name | - |
JMX | jmx["org.apache.cassandra.db:type=StorageService","ClusterName"] Preprocessing: - DISCARD_UNCHANGED_HEARTBEAT: |
| Cassandra | Version | - |
JMX | jmx["org.apache.cassandra.db:type=StorageService","ReleaseVersion"] Preprocessing: - DISCARD_UNCHANGED_HEARTBEAT: |
| Cassandra | Dropped messages: Write (Mutation) | Number of dropped regular writes messages. |
JMX | jmx["org.apache.cassandra.metrics:type=DroppedMessage,scope=MUTATION,name=Dropped","Count"] |
| Cassandra | Dropped messages: Read | Number of dropped regular reads messages. |
JMX | jmx["org.apache.cassandra.metrics:type=DroppedMessage,scope=READ,name=Dropped","Count"] |
| Cassandra | Storage: Used (bytes) | Size, in bytes, of the on disk data size this node manages. |
JMX | jmx["org.apache.cassandra.metrics:type=Storage,name=Load","Count"] |
| Cassandra | Storage: Errors | Number of internal exceptions caught. Under normal exceptions this should be zero. |
JMX | jmx["org.apache.cassandra.metrics:type=Storage,name=Exceptions","Count"] |
| Cassandra | Storage: Hints | Number of hint messages written to this node since [re]start. Includes one entry for each host to be hinted per hint. |
JMX | jmx["org.apache.cassandra.metrics:type=Storage,name=TotalHints","Count"] |
| Cassandra | Compaction: Number of completed tasks | Number of completed compactions since server [re]start. |
JMX | jmx["org.apache.cassandra.metrics:name=CompletedTasks,type=Compaction","Value"] |
| Cassandra | Compaction: Total compactions completed | Throughput of completed compactions since server [re]start. |
JMX | jmx["org.apache.cassandra.metrics:name=TotalCompactionsCompleted,type=Compaction","Count"] |
| Cassandra | Compaction: Pending tasks | Estimated number of compactions remaining to perform. |
JMX | jmx["org.apache.cassandra.metrics:type=Compaction,name=PendingTasks","Value"] |
| Cassandra | Commitlog: Pending tasks | Number of commit log messages written but yet to be fsync'd. |
JMX | jmx["org.apache.cassandra.metrics:name=PendingTasks,type=CommitLog","Value"] |
| Cassandra | Commitlog: Total size | Current size, in bytes, used by all the commit log segments. |
JMX | jmx["org.apache.cassandra.metrics:name=TotalCommitLogSize,type=CommitLog","Value"] |
| Cassandra | Latency: Read median | Latency read from disk in milliseconds - median. |
JMX | jmx["org.apache.cassandra.metrics:name=ReadLatency,type=Table","50thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | Latency: Read 75 percentile | Latency read from disk in milliseconds - p75. |
JMX | jmx["org.apache.cassandra.metrics:name=ReadLatency,type=Table","75thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | Latency: Read 95 percentile | Latency read from disk in milliseconds - p95. |
JMX | jmx["org.apache.cassandra.metrics:name=ReadLatency,type=Table","95thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | Latency: Write median | Latency write to disk in milliseconds - median. |
JMX | jmx["org.apache.cassandra.metrics:name=WriteLatency,type=Table","50thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | Latency: Write 75 percentile | Latency write to disk in milliseconds - p75. |
JMX | jmx["org.apache.cassandra.metrics:name=WriteLatency,type=Table","75thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | Latency: Write 95 percentile | Latency write to disk in milliseconds - p95. |
JMX | jmx["org.apache.cassandra.metrics:name=WriteLatency,type=Table","95thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | Latency: Client request read median | Total latency serving data to clients in milliseconds - median. |
JMX | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Read,name=Latency","50thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | Latency: Client request read 75 percentile | Total latency serving data to clients in milliseconds - p75. |
JMX | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Read,name=Latency","75thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | Latency: Client request read 95 percentile | Total latency serving data to clients in milliseconds - p95. |
JMX | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Read,name=Latency","95thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | Latency: Client request write median | Total latency serving write requests from clients in milliseconds - median. |
JMX | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Write,name=Latency","50thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | Latency: Client request write 75 percentile | Total latency serving write requests from clients in milliseconds - p75. |
JMX | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Write,name=Latency","75thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | Latency: Client request write 95 percentile | Total latency serving write requests from clients in milliseconds - p95. |
JMX | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Write,name=Latency","95thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | KeyCache: Capacity | Cache capacity in bytes. |
JMX | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=Capacity","Value"] Preprocessing: - DISCARD_UNCHANGED_HEARTBEAT: |
| Cassandra | KeyCache: Entries | Total number of cache entries. |
JMX | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=Entries","Value"] |
| Cassandra | KeyCache: HitRate | All time cache hit rate. |
JMX | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=HitRate","Value"] Preprocessing: - MULTIPLIER: |
| Cassandra | KeyCache: Hits per second | Rate of cache hits. |
JMX | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=Hits","Count"] Preprocessing: - CHANGE_PER_SECOND |
| Cassandra | KeyCache: requests per second | Rate of cache requests. |
JMX | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=Requests","Count"] Preprocessing: - CHANGE_PER_SECOND |
| Cassandra | KeyCache: Size | Total size of occupied cache, in bytes. |
JMX | jmx["org.apache.cassandra.metrics:type=Cache,scope=KeyCache,name=Size","Value"] |
| Cassandra | Client connections: Native | Number of clients connected to this nodes native protocol server. |
JMX | jmx["org.apache.cassandra.metrics:type=Client,name=connectedNativeClients","Value"] |
| Cassandra | Client connections: Trifts | Number of connected to this nodes thrift clients. |
JMX | jmx["org.apache.cassandra.metrics:type=Client,name=connectedThriftClients","Value"] |
| Cassandra | Client request: Read per second | The number of client requests per second. |
JMX | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Read,name=Latency","Count"] Preprocessing: - CHANGE_PER_SECOND |
| Cassandra | Client request: Write per second | The number of local write requests per second. |
JMX | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Write,name=Latency","Count"] Preprocessing: - CHANGE_PER_SECOND |
| Cassandra | Client request: Write Timeouts | Number of write requests timeouts encountered. |
JMX | jmx["org.apache.cassandra.metrics:type=ClientRequest,scope=Write,name=Timeouts","Count"] |
| Cassandra | Thread pool.MutationStage: Pending tasks | Number of queued tasks queued up on this pool. MutationStage: Responsible for writes (exclude materialized and counter writes). |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=MutationStage,name=PendingTasks","Value"] |
| Cassandra | Thread pool MutationStage: Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. MutationStage: Responsible for writes (exclude materialized and counter writes). |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=MutationStage,name=CurrentlyBlockedTasks","Count"] |
| Cassandra | Thread pool MutationStage: Total blocked tasks | Number of tasks that were blocked due to queue saturation. MutationStage: Responsible for writes (exclude materialized and counter writes). |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=MutationStage,name=TotalBlockedTasks","Count"] |
| Cassandra | Thread pool CounterMutationStage: Pending tasks | Number of queued tasks queued up on this pool. CounterMutationStage: Responsible for counter writes. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=CounterMutationStage,name=PendingTasks","Value"] |
| Cassandra | Thread pool CounterMutationStage: Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. CounterMutationStage: Responsible for counter writes. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=CounterMutationStage,name=CurrentlyBlockedTasks","Count"] |
| Cassandra | Thread pool CounterMutationStage: Total blocked tasks | Number of tasks that were blocked due to queue saturation. CounterMutationStage: Responsible for counter writes. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=CounterMutationStage,name=TotalBlockedTasks","Count"] |
| Cassandra | Thread pool ReadStage: Pending tasks | Number of queued tasks queued up on this pool. ReadStage: Local reads run on this thread pool. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ReadStage,name=PendingTasks","Value"] |
| Cassandra | Thread pool ReadStage: Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. ReadStage: Local reads run on this thread pool. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ReadStage,name=CurrentlyBlockedTasks","Count"] |
| Cassandra | Thread pool ReadStage: Total blocked tasks | Number of tasks that were blocked due to queue saturation. ReadStage: Local reads run on this thread pool. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ReadStage,name=TotalBlockedTasks","Count"] |
| Cassandra | Thread pool ViewMutationStage: Pending tasks | Number of queued tasks queued up on this pool. ViewMutationStage: Responsible for materialized view writes. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ViewMutationStage,name=PendingTasks","Value"] |
| Cassandra | Thread pool ViewMutationStage: Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. ViewMutationStage: Responsible for materialized view writes. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ViewMutationStage,name=CurrentlyBlockedTasks","Count"] |
| Cassandra | Thread pool ViewMutationStage: Total blocked tasks | Number of tasks that were blocked due to queue saturation. ViewMutationStage: Responsible for materialized view writes. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=request,scope=ViewMutationStage,name=TotalBlockedTasks","Count"] |
| Cassandra | Thread pool MemtableFlushWriter: Pending tasks | Number of queued tasks queued up on this pool. MemtableFlushWriter: Writes memtables to disk. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtableFlushWriter,name=PendingTasks","Value"] |
| Cassandra | Thread pool MemtableFlushWriter: Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. MemtableFlushWriter: Writes memtables to disk. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtableFlushWriter,name=CurrentlyBlockedTasks","Count"] |
| Cassandra | Thread pool MemtableFlushWriter: Total blocked tasks | Number of tasks that were blocked due to queue saturation. MemtableFlushWriter: Writes memtables to disk. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtableFlushWriter,name=TotalBlockedTasks","Count"] |
| Cassandra | Thread pool HintsDispatcher: Pending tasks | Number of queued tasks queued up on this pool. HintsDispatcher: Performs hinted handoff. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=HintsDispatcher,name=PendingTasks","Value"] |
| Cassandra | Thread pool HintsDispatcher: Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. HintsDispatcher: Performs hinted handoff. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=HintsDispatcher,name=CurrentlyBlockedTasks","Count"] |
| Cassandra | Thread pool HintsDispatcher: Total blocked tasks | Number of tasks that were blocked due to queue saturation. HintsDispatcher: Performs hinted handoff. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=HintsDispatcher,name=TotalBlockedTasks","Count"] |
| Cassandra | Thread pool MemtablePostFlush: Pending tasks | Number of queued tasks queued up on this pool. MemtablePostFlush: Cleans up commit log after memtable is written to disk. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtablePostFlush,name=PendingTasks","Value"] |
| Cassandra | Thread pool MemtablePostFlush: Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. MemtablePostFlush: Cleans up commit log after memtable is written to disk. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtablePostFlush,name=CurrentlyBlockedTasks","Count"] |
| Cassandra | Thread pool MemtablePostFlush: Total blocked tasks | Number of tasks that were blocked due to queue saturation. MemtablePostFlush: Cleans up commit log after memtable is written to disk. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MemtablePostFlush,name=TotalBlockedTasks","Count"] |
| Cassandra | Thread pool MigrationStage: Pending tasks | Number of queued tasks queued up on this pool. MigrationStage: Runs schema migrations. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MigrationStage,name=PendingTasks","Value"] |
| Cassandra | Thread pool MigrationStage: Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. MigrationStage: Runs schema migrations. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MigrationStage,name=CurrentlyBlockedTasks","Count"] |
| Cassandra | Thread pool MigrationStage: Total blocked tasks | Number of tasks that were blocked due to queue saturation. MigrationStage: Runs schema migrations. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MigrationStage,name=TotalBlockedTasks","Count"] |
| Cassandra | Thread pool MiscStage: Pending tasks | Number of queued tasks queued up on this pool. MiscStage: Miscellaneous tasks run here. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MiscStage,name=PendingTasks","Value"] |
| Cassandra | Thread pool MiscStage: Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. MiscStage: Miscellaneous tasks run here. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MiscStage,name=CurrentlyBlockedTasks","Count"] |
| Cassandra | Thread pool MiscStage: Total blocked tasks | Number of tasks that were blocked due to queue saturation. MiscStage: Miscellaneous tasks run here. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=MiscStage,name=TotalBlockedTasks","Count"] |
| Cassandra | Thread pool SecondaryIndexManagement: Pending tasks | Number of queued tasks queued up on this pool. SecondaryIndexManagement: Performs updates to secondary indexes. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=SecondaryIndexManagement,name=PendingTasks","Value"] |
| Cassandra | Thread pool SecondaryIndexManagement: Currently blocked task | Number of tasks that are currently blocked due to queue saturation but on retry will become unblocked. SecondaryIndexManagement: Performs updates to secondary indexes. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=SecondaryIndexManagement,name=CurrentlyBlockedTasks","Count"] |
| Cassandra | Thread pool SecondaryIndexManagement: Total blocked tasks | Number of tasks that were blocked due to queue saturation. SecondaryIndexManagement: Performs updates to secondary indexes. |
JMX | jmx["org.apache.cassandra.metrics:type=ThreadPools,path=internal,scope=SecondaryIndexManagement,name=TotalBlockedTasks","Count"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: SS Tables per read 75 percentile | The number of SSTable data files accessed per read - p75. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=SSTablesPerReadHistogram","75thPercentile"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: SS Tables per read 95 percentile | The number of SSTable data files accessed per read - p95. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=SSTablesPerReadHistogram","95thPercentile"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Tombstone scanned 75 percentile | Number of tombstones scanned per read - p75. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=TombstoneScannedHistogram","75thPercentile"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Tombstone scanned 95 percentile | Number of tombstones scanned per read - p95. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=TombstoneScannedHistogram","95thPercentile"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Waiting on free memtable space 75 percentile | The time spent waiting for free memtable space either on- or off-heap - p75. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=WaitingOnFreeMemtableSpace","75thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Waiting on free memtable space95 percentile | The time spent waiting for free memtable space either on- or off-heap - p95. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=WaitingOnFreeMemtableSpace","95thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Col update time delta75 percentile | The column update time delta - p75. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=ColUpdateTimeDeltaHistogram","75thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Col update time delta 95 percentile | The column update time delta - p95. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=ColUpdateTimeDeltaHistogram","95thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Bloom filter false ratio | The ratio of Bloom filter false positives to total checks. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=BloomFilterFalseRatio","Value"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Compression ratio | The compression ratio for all SSTables. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=CompressionRatio","Value"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: KeyCache hit rate | The key cache hit rate. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=KeyCacheHitRate","Value"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Live SS Table | Number of "live" (in use) SSTables. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=LiveSSTableCount","Value"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Max sartition size | The size of the largest compacted partition. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=MaxPartitionSize","Value"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Mean partition size | The average size of compacted partition. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=MeanPartitionSize","Value"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Pending compactions | The number of pending compactions. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=PendingCompactions","Value"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Snapshots size | The disk space truly used by snapshots. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=SnapshotsSize","Value"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Compaction bytes written | The amount of data that was compacted since (re)start. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=CompactionBytesWritten","Count"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Bytes flushed | The amount of data that was flushed since (re)start. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=BytesFlushed","Count"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Pending flushes | The number of pending flushes. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=PendingFlushes","Count"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Live disk space used | The disk space used by "live" SSTables (only counts in use files). |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=LiveDiskSpaceUsed","Count"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Disk space used | Disk space used. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=TotalDiskSpaceUsed","Count"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Out of row cache hits | The number of row cache hits that do not satisfy the query filter and went to disk. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=RowCacheHitOutOfRange","Count"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Row cache hits | The number of row cache hits. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=RowCacheHit","Count"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Row cache misses | The number of table row cache misses. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=RowCacheMiss","Count"] |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Read latency 75 percentile | Latency read from disk in milliseconds. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=ReadLatency","75thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Read latency 95 percentile | Latency read from disk in milliseconds. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=ReadLatency","95thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Read per second | The number of client requests per second. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=ReadLatency","Count"] Preprocessing: - CHANGE_PER_SECOND |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Write latency 75 percentile | Latency write to disk in milliseconds. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=WriteLatency","75thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Write latency 95 percentile | Latency write to disk in milliseconds. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=WriteLatency","95thPercentile"] Preprocessing: - MULTIPLIER: |
| Cassandra | {#JMXKEYSPACE}.{#JMXSCOPE}: Write per second | The number of local write requests per second. |
JMX | jmx["org.apache.cassandra.metrics:type=Table,keyspace={#JMXKEYSPACE},scope={#JMXSCOPE},name=WriteLatency","Count"] Preprocessing: - CHANGE_PER_SECOND |
Triggers
| Name | Description | Expression | Severity | Dependencies and additional info |
|---|---|---|---|---|
| There are down nodes in cluster | - |
{TEMPLATE_NAME:jmx["org.apache.cassandra.net:type=FailureDetector","DownEndpointCount"].last()}>0 |
AVERAGE | |
| Version has changed (new version: {ITEM.VALUE}) | Cassandra version has changed. Ack to close. |
{TEMPLATE_NAME:jmx["org.apache.cassandra.db:type=StorageService","ReleaseVersion"].diff()}=1 and {TEMPLATE_NAME:jmx["org.apache.cassandra.db:type=StorageService","ReleaseVersion"].strlen()}>0 |
INFO | Manual close: YES |
| Failed to fetch info data (or no data for 15m) | Zabbix has not received data for items for the last 15 minutes |
{TEMPLATE_NAME:jmx["org.apache.cassandra.metrics:type=Storage,name=Load","Count"].nodata(15m)}=1 |
WARNING | |
| Too many storage exceptions | - |
{TEMPLATE_NAME:jmx["org.apache.cassandra.metrics:type=Storage,name=Exceptions","Count"].min(5m)}>0 |
WARNING | |
| Many pending tasks (over {$CASSANDRA.PENDING_TASKS.MAX.WARN} for 15m) | - |
{TEMPLATE_NAME:jmx["org.apache.cassandra.metrics:type=Compaction,name=PendingTasks","Value"].min(15m)}>{$CASSANDRA.PENDING_TASKS.MAX.WARN} |
WARNING | Depends on: - Too many pending tasks (over {$CASSANDRA.PENDING_TASKS.MAX.HIGH} for 15m) |
| Too many pending tasks (over {$CASSANDRA.PENDING_TASKS.MAX.HIGH} for 15m) | - |
{TEMPLATE_NAME:jmx["org.apache.cassandra.metrics:type=Compaction,name=PendingTasks","Value"].min(15m)}>{$CASSANDRA.PENDING_TASKS.MAX.HIGH} |
AVERAGE |
Feedback
Please report any issues with the template at https://support.zabbix.com
You can also provide a feedback, discuss the template or ask for help with it at ZABBIX forums.
Vendor and Community integrations are created by third parties and are not verified by Zabbix. Zabbix is not responsible for their functionality or quality.
Community repositories
1 Independent projects on GitHubA Zabbix template for CassandraDB (cluster) monitoringBased on nagios checks and harisekhon's github repo