Apache Cassandra Monitoring

Overview

Applications Manager provides out-of-the-box performance metrics and helps you visualize the health and availability of your Apache Cassandra NoSQL database.

Creating a new Cassandra DB monitor

Supported Versions: Apache Cassandra 2.0 and above.

Prerequisite:Click here to know about the necessary prerequisites to monitor the Apache Cassandra database.

Using the REST API to add a new Cassandra monitor:Click here

To create a Cassandra database server monitor, follow the steps given below:

Click on the New Monitor link.
Select Cassandra.
Specify the Display Name of the Cassandra monitor
Enter the HostName or IP Address of the host where Cassandra server runs
Enter the JMX Port where the server is running. By default, it will be 7199; otherwise, check in cassandra-env .sh file for the JMX_PORT.
If you want to discover only this node, disable the option Discover all nodes in the Cluster. By default, it is enabled, which means all the nodes in the cluster are discovered by default
Check the Is Authentication Required field to give the JMX credentials to be used to connect to the Cassandra server. Now enter the UserName and Password of the credential
Specify the Polling Interval in minutes
If you are adding a new monitor from the Central Server, select a Probe Server.
Choose the Monitor Group with which you want to associate the Cassandra server from the combo box (optional). You can choose multiple groups to associate your monitor with
Click Add Monitor(s). This discovers the Cassandra server from the network and starts monitoring it

Note:
In case you are unable to add the monitor even after enabling JMX, try providing the below argument:
-Djava.rmi.server.hostname=[YOUR_IP]

Monitored Parameters

Click on the individual monitors listed to view the following information in the tabs below:

Monitor Information
Performance
Pending Tasks
Cluster Stats
Messages
Configurations

Monitor Information

This tab displays basic information, such as the server name, hostname, and the JMX port on which the server is running. Additional parameters like Token, Gossip Active, Load, Generation No, Uptime, DataCenter, and Rack Name are also displayed. These are the equivalent of the Nodetool result got using the command 'nodetool.bat/sh -h -p info.'

Performance

Parameters	Description	2 and below	3 and 4
Availability and Performance History	Displays the availability and performance history for the last six hours.	Yes	Yes
CPU Usage	Specifies the usage of the CPU in percentage.	Yes	Yes
Memory Utilization	Specifies the used, free, and total memory of the server in megabytes	Yes	Yes
Exceptions	Count of various exceptions such as not found, invalid, unavailable, timed out, etc.	Yes	No
Storage Stats	Specifies the storage load in GB.	Yes	No
Operation Stats	Number of range, read, and write operations per second since the executor started.	Yes	No
Operation Latency	The latency of range, read, and write operations since the last time the attribute was read.	Yes	No
Bloom Filter Statistics		Yes	Yes
Bloom Filter False Positives	Number of false positives (Occurs when the bloom filter says a non-existent row exists)	Yes	Yes
Bloom Filter False Positive Ratio	Fraction of all bloom filter checks resulting in a false positive	Yes	Yes
Bloom Filter Disk Space Used	The size of the bloom filter files on disk	Yes	Yes
Memtable Statistics		Yes	Partial
Memtable Columns Count	Total number of columns present in memtable	Yes	Yes
Memtable Data Size	Amount of data stored in memtable, including column-related overhead	Yes	No
Memtable Switch Count	Number of times flushing results in the memtable being switched out	Yes	Yes
Client Details		Yes	Partial
Connected Native Clients	Number of Native Clients currently connected to the server instance	Yes	Yes
Connected Thrift Clients	Number of Thrift Clients currently connected to the server instance	Yes	No
Average Operational Latency		Yes	No
Average Range Latency	The average latency per range operation since the last poll	Yes	No
Average Read Latency	The average latency per read operation since the last poll	Yes	No
Average Write Latency	The average latency per write operation since the last poll	Yes	No
Operational Timeouts		Yes	No
Recent Timeouts	Number of read, write, and range slice operation timeouts since the last poll	Yes	No

Pending Tasks

Parameters	Description	2 and below	3 and 4
COMMITLOG/COMPACTION - PENDING TASKS		Yes	Partial
Commitlog - Pending Tasks	Number of Commitlog tasks waiting in the queue to be executed.	Yes	Yes
Compaction - Pending Tasks	Number of Compaction tasks waiting in the queue to be executed.	Yes	No
COMMANDS/RESPONSES - PENDING TASKS		Yes	No
Commands - Pending Tasks	Number of Command tasks waiting in the queue to be executed.	Yes	No
Responses - Pending Tasks	Number of Response tasks waiting in the queue to be executed.	Yes	No
Task Statistics of Thread Pools	Status of various stages of thread pools, like active and pending tasks, completed and blocked tasks, is being displayed. These are equivalent to the Nodetool result got using the command 'nodetool.bat/sh -h <hostname> -p <portnumber> tpstats'.	Yes	No

Cluster Stats

Parameters	Description	2 and below	3 and 4
Cluster Details	Specifies details on live, leaving, moving, joining, and unreachable nodes.	Yes	Yes
Cluster Node Details	Health status and storage load (in GB) of the nodes in the cluster.	Yes	Yes

Messages

This tab contains the Dropped Message and Message Timeout statistics:

Parameter	Description	2 and below	3 and 4
Recent Total Timeouts	Number of timeouts since last poll	Yes	Yes

Configurations

This tab contains the configuration values of files that are part of cassandra.yaml config file.

The following metrics and descriptions are grouped by section and include version-based availability.

Configuration details

Parameters	Description	2 and below	3 and 4
Load	Total size of the node's data on disk (including all keyspaces).	Yes	Yes
Generation No	Timestamp or generation number used for identifying commit logs.	Yes	Yes
DataCenter Name	Name of the data center this Cassandra node belongs to.	Yes	Yes
Rack Name	Name of the rack in which the node resides, used for network topology awareness.	Yes	Yes
Compaction Throughput MB Per Second	Maximum throughput allowed for compaction operations.	Yes	Yes
Stream Throughput MB Per Second	Maximum throughput for streaming data during operations like bootstrap or repair.	Yes	Yes
RPC Timeout in milliseconds	Timeout for Remote Procedure Call (RPC) requests in milliseconds.	Yes	Yes
Max Hint Window in milliseconds	Time window during which hints are stored for unavailable replicas.	Yes	Yes
MaxHints In Progress	Maximum number of hint delivery processes allowed to run simultaneously.	Yes	Yes
Minimum Compaction Threshold	Minimum number of SSTables that must be eligible to trigger compaction.	Yes	No
Maximum Compaction Threshold	Maximum number of SSTables allowed to be compacted together.	Yes	No
Key Cache Save Period In Seconds	Time interval in seconds for saving the key cache to disk.	Yes	Yes
Row Cache Save Period In Seconds	Time interval in seconds for saving the row cache to disk.	Yes	Yes
Row Cache Keys To Save	Number of keys to retain when saving the row cache.	Yes	Yes
Storage Initialized	Indicates if storage services have been initialized on the node.	Yes	Yes
RPC Server Running	Indicates whether the RPC server is currently running.	Yes	No
All Data File Locations	Directories where Cassandra stores data files.	Yes	Yes
Commit Log Location	Directory where commit logs are stored.	Yes	Yes
Saved Caches Locations	Directory where saved caches are written.	Yes	Yes
Joined in a cluster	Indicates if the node has joined the Cassandra cluster.	Yes	Yes
Release Version	The version of Cassandra running on the node.	Yes	Yes
Operation Mode	Current operational mode of the node (e.g., NORMAL, JOINING, LEAVING).	Yes	Yes
Removal Status	Status of node removal from the cluster, if applicable.	Yes	Yes
Drain Progress	Progress of the drain operation (flushing memtables before shutdown).	Yes	Yes
Hinted Handoff Enabled	Indicates whether hinted handoff is enabled for the node.	Yes	Yes
Compaction Strategy Class	The class defines the strategy used for SSTable compaction.	Yes	No
EndpointSnitch - Badness Threshold	Threshold for accepting suboptimal replicas based on latency.	Yes	Yes
EndpointSnitch - Reset Interval in milliseconds	Interval to reset snitch decisions and latency scores.	Yes	Yes
EndpointSnitch - Update Interval in milliseconds	The frequency at which snitch updates node latencies.	Yes	Yes
EndpointSnitch - ClassName	The Java class name of the endpoint snitch in use.	Yes	Yes

Database details

Parameters	Description	2 and below	3 and 4
DATABASE CACHE DETAILS		Yes	Yes
Counter Cache Save Period	The frequency with which the counter cache is saved to disk.	Yes	Yes
Key Cache Hits	Number of table key cache hits.	Yes	No
Key Cache Requests	Total number of key cache requests.	Yes	No
Key Cache Recent Hit Rate	All-time key cache hit rate	Yes	No
Key Cache Save Period	Indicates how frequently the system saves or persists the contents of this key cache to a more permanent storage medium, such as disk or memory	Yes	Yes
Key Cache Capacity	Key Cache capacity	Yes	No
Key Cache Size	Total size of occupied key cache,	Yes	No
Key Cache Entries	Total number of key cache entries.	Yes	No
Row Cache Hits	Number of table row cache hits.	Yes	No
Row Cache Requests	Total number of row cache requests.	Yes	No
Row Cache Save Period	Indicates how frequently the system saves or persists the contents of this row cache to a more permanent storage medium, such as disk or memory	Yes	Yes
Row Cache Capacity	Row Cache capacity	Yes	No
Row Cache Size	Total size of occupied row cache,	Yes	No
Row Cache Entries	Total number of row cache entries.	Yes	No
DATABASE DYNAMIC ENDPOINT SNITCH DETAILS		Yes	Yes
Dynamic EndpointSnitch Severity	A measure of the severity of latency and instability between Cassandra nodes	Yes	Yes
Dynamic EndpointSnitch Update Interval	Indicates the frequency at which the Dynamic EndpointSnitch updates its penalties assigned to individual nodes	Yes	Yes
Dynamic EndpointSnitch Reset Interval	The time interval after which the Dynamic EndpointSnitch clears its penalty history for individual nodes.	Yes	Yes
DATABASE STORAGE PROXY DETAILS		Yes	Partial
Storage Proxy Hints in Progress	Number of hints attempting to be sent currently	Yes	Yes
Storage Proxy Range Operations	Number of range operations performed	Yes	No
Storage Proxy Read Operations	Number of read operations handled	Yes	No
Storage Proxy Read repair attempted	Number of times the storage proxy component has initiated read repair operations.	Yes	No
Storage Proxy Read Repair Repaired Background	Number of successful background read repair operations completed	Yes	Yes
Storage Proxy Read Repair Repaired Blocking	Number of successful read repair operations completed	Yes	Yes
Storage Proxy Recent Range Latency Micros	The recent latency of range operations handled	Yes	Yes
Storage Proxy Recent Read Latency Micros	The recent latency of read operations handled	Yes	No
Storage Proxy RPC Timeout	The duration it takes for an RPC initiated by the storage proxy to time out	Yes	Yes
Storage Proxy Total Hints	Number of hint messages written to this node since [re]start. Includes one entry for each host to be hinted per hint.	Yes	Yes
Storage Proxy Total Read Latency Micros	The total latency of read operations handled	Yes	No
Storage Proxy Total Range Latency Micros	The total latency of read operations handled	Yes	No
Storage Proxy Total Write Latency Micros	The total latency of write operations handled	Yes	No
Storage Proxy Truncate RPC Timeout	The duration it takes for a truncate operation initiated by the storage proxy to time out	Yes	Yes
Storage Proxy Write Operations	Number of write operations handled	Yes	No
Storage Proxy Write RPC Timeout	The duration it takes for an RPC initiated by the storage proxy to time out during write operations	Yes	Yes
Storage Proxy CAS Contention Timeout	The duration it takes for a CAS operation initiated by the storage proxy to time out due to contention.	Yes	Yes
Storage Proxy Counter Write RPC Timeout	The duration it takes for an RPC initiated by the storage proxy to time out during counter write operations	Yes	Yes
DATABASE COMPACTION MANAGER DETAILS		Yes	Partial
Compaction Manager Completed Tasks	Number of completed compactions since server [re]start.	Yes	No
Compaction Manager Pending Tasks	Estimated number of compactions remaining to perform.	Yes	No
Compaction Manager Total Bytes Compacted	Total number of bytes compacted since server [re]start.	Yes	No
Compaction Manager Total Compaction Completed	Throughput of completed compactions since server [re]start.	Yes	No
Compaction Manager Core Compactor Threads	Number of threads dedicated to handling compaction tasks within the compaction manager core.	Yes	Yes
Compaction Manager Maximum Compactor Threads	Maximum number of threads that can be allocated for handling compaction tasks	Yes	Yes
Compaction Manager Core Validation Threads	Number of threads dedicated to performing validation tasks within the compaction manager core.	Yes	Yes
DATABASE INDEX SUMMARIES DETAILS		Yes	Yes
Index Summaries Average Index Interval	Average distance between consecutive index summary entries within an SSTable	Yes	Yes
Index Summaries Memory Pool Capacity	Maximum amount of memory allocated for storing index summaries	Yes	Yes
Index Summaries Resize Interval	The frequency at which index summaries are resized or updated within an SSTable	Yes	Yes

Internal Details

Parameters	Description	2 and below	3 and 4
ANTI ENTROPY STAGE		Yes	No
Anti-Entropy Stage Active Count	Number of active anti-entropy repair sessions currently in progress within the system.	Yes	No
Anti-Entropy Stage Pending Tasks	Number of pending anti-entropy repair tasks that are awaiting execution within the system	Yes	No
Anti-Entropy Stage Blocked Tasks	Number of anti-entropy repair tasks that are currently blocked or unable to proceed due to resource constraints	Yes	No
Anti-Entropy Stage: Currently Blocked Tasks	Count of the anti-entropy repair tasks that are presently blocked or unable to proceed	Yes	No
COMMIT LOG ARCHIVER		Yes	No
CommitLog Archiver Active Count	Number of active threads currently engaged in archiving commit log segments	Yes	No
CommitLog Archiver Pending Tasks	Number of commit log messages written but yet to be fsync’d.	Yes	No
CommitLog Archiver Blocked Tasks	Number of tasks in the commit log archiver's queue that are blocked	Yes	No
CommitLog Archiver Currently Blocked Tasks	Number of tasks in the commit log archiver's queue that are currently blocked	Yes	No
GOSSIP STAGE		Yes	No
Gossip Stage Active Count	Number of active threads currently involved in the gossip stage of the gossip protocol	Yes	No
Gossip Stage Pending Tasks	Number of pending tasks in the gossip stage of the gossip protocol that are awaiting execution	Yes	No
Gossip Stage Blocked Tasks	number of tasks in the gossip stage of the gossip protocol that are blocked	Yes	No
Gossip Stage Currently Blocked Tasks	Number of tasks in the gossip stage of the gossip protocol that are currently blocked	Yes	No
INTERNAL RESPONSE STAGE		Yes	No
Internal Response Stage Active Count	Number of active threads currently engaged in processing internal responses within the system	Yes	No
Internal Response Stage Pending Tasks	Number of pending tasks in the internal response processing stage of the system	Yes	No
Internal Response Stage Blocked Tasks	Number of tasks in the internal response processing stage that are blocked	Yes	No
Internal Response Stage: Currently Blocked Tasks	Number of tasks in the internal response processing stage that are currently blocked	Yes	No
MEMTABLE POST FLUSH		Yes	No
Memtable Post Flush Active Count	Number of active threads currently involved in post-flush operations after flushing memtables to disk	Yes	No
Memtable Post Flush Pending Tasks	Number of pending tasks in the post-flush stage after memtables have been flushed to disk	Yes	No
Memtable Post Flush Blocked Tasks	Number of tasks in the post-flush stage after memtables have been flushed to disk that are blocked	Yes	No
Memtable Post Flush Currently Blocked Tasks	Number of tasks in the post-flush stage after memtables have been flushed to disk that are blocked	Yes	No
MIGRATION STAGE		Yes	No
Migration Stage Active Count	Number of active threads currently engaged in the migration stage of the system	Yes	No
Migration Stage Pending Tasks	Number of tasks in the post-flush stage after memtables have been flushed to disk that are blocked	Yes	No
Migration Stage Blocked Tasks	Number of tasks in the migration stage that are blocked	Yes	No
Migration Stage: Currently Blocked Tasks	Number of tasks in the migration stage that are currently blocked	Yes	No
PENDING RANGE CALCULATOR		Yes	No
Pending Range Calculator Active Count	Number of active threads currently engaged in the pending range calculation stage	Yes	No
Pending Range Calculator Pending Tasks	Number of pending tasks in the pending range calculation stage	Yes	No
Pending Range Calculator Blocked Tasks	Number of tasks in the pending range calculation stage that are blocked	Yes	No
Pending Range Calculator Currently Blocked Tasks	Number of tasks in the pending range calculation stage that are currently blocked	Yes	No
VALIDATION EXECUTOR DETAIL		Yes	No
Validation Executor Active Count	Number of active threads currently engaged in the validation executor stage	Yes	No
Validation Executor Pending Tasks	Number of validation tasks that are queued up for execution within the validation executor stage	Yes	No
Validation Executor Blocked Tasks	Number of validation tasks that are blocked or unable to proceed within the validation executor stage	Yes	No
Validation Executor Currently Blocked Tasks	The count of tasks within the validation executor stage that are presently obstructed	Yes	No
CACHE CLEANUP EXECUTER		Yes	No
Cache Cleanup Executor Active Count	Number of active threads currently engaged in the cache cleanup executor stage	Yes	No
Cache Cleanup Executor Pending Tasks	Number of pending tasks in the cache cleanup executor stage	Yes	No
Cache Cleanup Executor Blocked Tasks	Number of tasks in the cache cleanup executor stage that are blocked	Yes	No
Cache Cleanup Executor: Currently Blocked Tasks	Number of tasks in the cache cleanup executor stage that are currently blocked	Yes	No
COMPACTION EXECUTER		Yes	No
Compaction Executor Active Count	Number of active threads currently engaged in the compaction executor stage	Yes	No
Compaction Executor Pending Tasks	Number of compaction tasks that are queued up for execution within the compaction executor stage	Yes	No
Compaction Executor Blocked Tasks	Number of tasks within the compaction executor stage that are blocked	Yes	No
Compaction Executor Currently Blocked Tasks	Number of tasks within the compaction executor stage that are currently blocked	Yes	No
HINTED HANDOFF		Yes	No
Hinted Handoff Active Count	Number of active threads currently involved in the hinted handoff process	Yes	No
Hinted Handoff Pending Tasks	Number of tasks queued up for processing within the hinted handoff mechanism	Yes	No
Hinted Handoff Blocked Tasks	Number of tasks within the hinted handoff mechanism that are blocked	Yes	No
Hinted Handoff Currently Blocked Tasks	Number of tasks within the hinted handoff mechanism that are currently blocked	Yes	No
MEMTABLE FLUSH WRITER		Yes	No
Memtable Flash Writer Active Count	Number of active threads currently involved in flushing memtables to disk	Yes	No
Memtable Flash Writer Pending Tasks	Number of tasks that are queued up for processing within the memtable flush writer stage	Yes	No
Memtable Flash Writer Blocked Tasks	Number of tasks within the memtable flush writer stage that are blocked	Yes	No
Memtable Flash Writer Currently Blocked Tasks	Number of tasks within the memtable flush writer stage that are currently blocked	Yes	No
MEMTABLE RECLAIM MEMORY		Yes	No
Memtable Reclaim Memory Active Count	Number of active threads currently engaged in the process of reclaiming memory from memtables	Yes	No
Memtable Reclaim Memory Pending Tasks	Number of tasks that are queued up for processing within the memtable memory reclamation stage	Yes	No
Memtable Reclaim Memory Blocked Tasks	Number of tasks within the memtable memory reclamation stage that are blocked	Yes	No
Memtable Reclaim Memory Currently Blocked Tasks	Number of tasks within the memtable memory reclamation stage that are currently blocked	Yes	No
MISC STAGE		Yes	No
Misc Stage Active Count	Number of active threads currently engaged in miscellaneous tasks	Yes	No
Misc Stage Pending Tasks	Number of tasks that are queued up for processing within the miscellaneous stage	Yes	No
Misc Stage Blocked Tasks	Number of tasks within the miscellaneous stage of the system that are blocked	Yes	No
Misc Stage Currently Blocked Tasks	Number of tasks within the miscellaneous stage of the system that are currently blocked	Yes	No
SAMPLER DETAIL		Yes	No
Sampler Active Count	Number of active threads currently engaged in re-sampling the index summaries of SStables	Yes	No
Sampler Pending Tasks	Number of tasks that are currently queued for re-sampling the index summaries of SStables	Yes	No
Sampler Blocked Tasks	Number of tasks within the sampler stage that are blocked	Yes	No
Sampler Currently Blocked Tasks	Number of tasks within the sampler stage that are currently blocked	Yes	No

Request Details

Parameters	Description	2 and below	3 and 4
COUNTER MUTATION STAGE		Yes	No
Counter Mutation Stage Active Count	Number of active threads currently engaged in processing counter mutation writes	Yes	No
Counter Mutation Stage Pending Tasks	Number of pending tasks in the counter mutation stage	Yes	No
Counter Mutation Stage Blocked Tasks	Number of tasks in the counter mutation stage that are blocked	Yes	No
Counter Mutation Stage Currently Blocked Tasks	Number of tasks in the counter mutation stage that are currently blocked	Yes	No
READ REPAIR STAGE		Yes	No
Read Repair Stage, Active Count	Number of active read repair tasks currently being executed	Yes	No
Read Repair Stage Pending Tasks	Number of pending read repair tasks in the read repair stage	Yes	No
Read Repair Stage Blocked Tasks	Number of read repair tasks that are blocked	Yes	No
Read Repair Stage Currently Blocked Tasks	Number of read repair tasks that are currently blocked	Yes	No
READ REQUEST RESPONSE STAGE		Yes	No
Request Response Stage Active Count	Number of coordinator requests currently being processed in the request response stage	Yes	No
Request Response Stage Pending Tasks	Number of pending requests in the request response stage	Yes	No
Request Response Stage Blocked Tasks	Number of coordinator requests in the request response stage that are blocked	Yes	No
Request Response Stage: Currently Blocked Tasks	Number of coordinator requests in the request response stage that are currently blocked	Yes	No
MUTATION STAGE		Yes	No
Mutation Stage Active Count	Number of active writes currently being processed in the mutation stage	Yes	No
Mutation Stage Pending Tasks	Number of pending writes in the mutation stage	Yes	No
Mutation Stage Blocked Tasks	Number of writes in the mutation stage that are blocked	Yes	No
Mutation Stage: Currently Blocked Tasks	Number of writes in the mutation stage that are currently blocked	Yes	No
READ STAGE		Yes	No
Read Stage Active Count	Number of active local reads currently being processed in the read stage	Yes	No
Read Stage Pending Tasks	Number of pending local reads in the read stage	Yes	No
Read Stage Blocked Tasks	Number of local reads within the read stage that are blocked	Yes	No
Read Stage Currently Blocked Tasks	Number of local reads within the read stage that are currently blocked	Yes	No

General details

Parameters	Description	2 and below	3 and 4
CQL DETAILS		Yes	Yes
CQL Prepared Statements Count	Number of cached prepared statements.	Yes	Yes
CQL Prepared Statements Ratio	Percentage of statements that are prepared vs unprepared	Yes	Yes
CQL Prepared Statements Evicted	Number of prepared statements evicted from the prepared statement cache	Yes	Yes
CQL Prepared Statements Executed	Number of prepared statements executed.	Yes	Yes
CAS WRITE DETAILS		Yes	Yes
CAS Write Failure Count	Count of CAS write failures	Yes	Yes
CAS Write Contention Histogram	A breakdown of the distribution of contention levels for CAS writes	Yes	Yes
CAS Write Latency	Time taken for CAS write operations to complete	Yes	Yes
CAS Write Timeouts	Number of CAS write operations that have timed out.	Yes	Yes
CAS Write TotalLatency	The total latency or cumulative time taken for CAS write operations	Yes	Yes
CAS Write Unavailables	Number of CAS write operations that were unable to complete due to the unavailability of resources or nodes within the cluster.	Yes	Yes
CAS Write Unfinished Commit	CAS write operation has been initiated but has not completed its commit phase successfully.	Yes	Yes
READ PERFORMANCE DETAILS		Yes	Yes
Read Latency	Local read latency for this table.	Yes	Yes
Read Timeouts	Read timeouts encountered	Yes	Yes
Read Unavailables	Number of unavailable exceptions encountered	Yes	Yes
COMMIT LOG DETAILS		Yes	Yes
Commitlog Completed Tasks	Total number of commit log messages written since [re]start.	Yes	Yes
Commitlog Size	Current size, in bytes, used by all the commit log segments.	Yes	Yes
Commitlog Waiting On Commit	The time spent waiting on CL fsync; for Periodic, this only occurs when the sync is lagging its sync interval	Yes	Yes
Commitlog Waiting On Segment Allocation	Time spent waiting for a CommitLogSegment to be allocated - under normal conditions, this should be zero.	Yes	Yes
DROPPED MESSAGE DETAILS		Yes	Partial
Dropped Message Binary	Messages dropped by the server during communication with clients or other nodes in the cluster. These dropped messages are specifically in binary format.	Yes	No
Dropped Message Counter Mutation	Dropped counter mutation messages	Yes	Yes
Dropped Message Mutation	Dropped mutation messages	Yes	Yes
Dropped Message Paged Range	Paged range query initiated by a client is dropped	Yes	No
Dropped Message Range Slice	A range slice operation initiated by a client is dropped without receiving a response	Yes	Yes
Dropped Message Read	A read request initiated by a client is dropped without receiving a response	Yes	Yes
Dropped Message Read Repair	The read repair operation initiated by the system fails to complete successfully.	Yes	Yes
Dropped Message Request Response	A request initiated by a client is dropped	Yes	Yes
Dropped Message Trace	Information about the messages that have been dropped	Yes	Yes
CAS READ DETAILS		Yes	Yes
CAS Read Condition Failure Count	Count of CAS read failures	Yes	Yes
CAS Read Contention Histogram	A breakdown of the distribution of contention levels for CAS reads	Yes	Yes
CAS Read Latency	Time taken for CAS read operations to complete	Yes	Yes
CAS Read Timeouts	Number of CAS read operations that have timed out.	Yes	Yes
CAS Read TotalLatency	The total latency or cumulative time taken for CAS read operations	Yes	Yes
CAS Read Unavailables	Number of CAS read operations that were unable to complete due to the unavailability of resources or nodes within the cluster.	Yes	Yes
CAS Read Unfinished Commit	CAS read operation has been initiated but has not completed its commit phase successfully.	Yes	Yes
RANGE SLICE DETAILS		Yes	No
RangeSlice Latency	Local rangeslice latency for this table.	Yes	No
RangeSlice Timeouts	RangeSlice timeouts encountered	Yes	No
RangeSlice Unavailables	Number of unavailable exceptions encountered	Yes	No
WRITE PERFORMANCE DETAILS		Yes	Yes
Write Latency	Local write latency for this table.	Yes	Yes
Write Timeouts	Number of write timeouts occurred	Yes	Yes
Write Unavailables	Number of unavailable exceptions encountered	Yes	Yes
COMPACTION DETAILS		Yes	Yes
Compaction Bytes Compacted	Total number of bytes compacted since server [re]start.	Yes	Yes
Compaction Completed Tasks	Number of completed compactions since server [re]start.	Yes	Yes
Compaction Completed	Throughput of completed compactions since server [re]start.	Yes	Yes

KeySpace Details

Parameters	Description	2 and below	3 and 4
KEYSPACE LATENCY DETAILS		Yes	Yes
Read Latency(/min)	Read operation latency per min	Yes	Yes
Read Latecy 99th% (/Min)	Read operation latency at 99th percentile per min	Yes	Yes
Read Total Latency(/Min)	Total time taken for read operations	Yes	Yes
Write Latency (/Min)	Write operation latency per min	Yes	Yes
Write Latency 99th% (/Min)	Write operation latency at 99th percentile per min	Yes	Yes
Write Total Latency(/Min)	Total time taken for write operations	Yes	Yes
KEYSPACE MEMTABLE DETAILS		Yes	Yes
All Memtables On Heap Datasize(MB)	Total amount of data stored in the memtables (2i and pending flush memtables included) that resides on the heap.	Yes	Yes
All Memtables Off Heap Datasize(MB)	Total amount of data stored in the memtables (2i and pending flush memtables included) that resides off -heap.	Yes	Yes
Memtable Live Data Size(MB)	Total amount of live data stored in the memtables (2i and pending flush memtables included) that resides off-heap, excluding any data structure overhead.	Yes	Yes
Memtable Columns Count	Total number of columns present in the memtable.	Yes	Yes
Memtable On Heap Datasize(MB)	Total amount of data stored in the memtable that resides on the heap, including column-related overhead and partitions overwritten.	Yes	Yes
Memtable Off Heap Datasize(MB)	Total amount of data stored in the memtable that resides off -heap, including column-related overhead and partitions overwritten.	Yes	Yes
Memtable Switch Count(/ Min)	Number of times flush has resulted in the memtable being switched out.	Yes	Yes

KeySpace Details

Parameters	Description	2 and below	3 and 4
Live Disk Space Used(MB)	Disk space used by SSTables belonging to this table (in bytes).	Yes	Yes
Live Scanned Histogram(/ Min)	Histogram of live cells scanned in queries on this table.	Yes	Yes
SS Table per Read Histogram(/ Min)	Histogram of the number of SSTable data files accessed per single partition read. SSTables are skipped due to Bloom Filters; min-max key or partition index lookup is not taken into account.	Yes	Yes
SS Table per Read Histogram 99th%	Histogram of the number of SSTabledata files accessed per single partition read at the 99th percentile. SSTables are skipped due to Bloom Filters; min-max key or partition index lookup is not taken into account.	Yes	Yes
Tomb Stone Scanned Histogram(/ Min)	Histogram of tombstones scanned in queries on this table per min	Yes	Yes
Bloom Filter Disk Space Used(KB)	Disk space used by the loom filter	Yes	Yes
Bloom Filter Off Heap Memory Used(KB)	Off-heap memory used by the bloom filter.	Yes	Yes
Index Summary OFF heap Memory Used(KB)	Off-heap memory used by the index summary	Yes	Yes

Apache Cassandra Monitoring

Overview

Creating a new Cassandra DB monitor

Monitored Parameters

Monitor Information

Performance

Pending Tasks

Cluster Stats

Messages

Configurations

Configuration details

Database details

Internal Details

Request Details

General details

KeySpace Details

KeySpace Details

Loved by customers all over the world

"Standout Tool With Extensive Monitoring Capabilities"

"I like Applications Manager because it helps us to detect issues present in our servers and SQL databases."

Carlos Rivero

Trusted by thousands of leading businesses globally