Datadog-Cassandra Integration

Cassandra default dashboard

Overview

Get metrics from cassandra service in real time to:

  • Visualize and monitor cassandra states
  • Be notified about cassandra failovers and events.

Setup

Installation

The Cassandra check is packaged with the Agent, so simply install the Agent on your Cassandra nodes.

We recommend the use of Oracle’s JDK for this integration.

This check has a limit of 350 metrics per instance. The number of returned metrics is indicated in the info page. You can specify the metrics you are interested in by editing the configuration below. To learn how to customize the metrics to collect visit the JMX Checks documentation for more detailed instructions. If you need to monitor more metrics, please send us an email at support@datadoghq.com

Configuration

  1. Configure the Agent to connect to Cassandra, just edit conf.d/cassandra.yaml. See the sample cassandra.yaml for all available configuration options.
  2. Restart the Agent

Validation

Run the Agent’s info subcommand and look for cassandra under the Checks section:

  Checks
  ======
    [...]

    cassandra
    -------
      - instance #0 [OK]
      - Collected 26 metrics, 0 events & 1 service check

    [...]

Compatibility

The cassandra check is compatible with all major platforms.

Data Collected

Metrics

cassandra.bloom_filter_false_ratio
(gauge)
The ratio of Bloom filter false positives to total checks.
shown as fraction
cassandra.bytes_flushed.count
(gauge)
The amount of data that was flushed since (re)start.
shown as byte
cassandra.cas_commit_latency.75th_percentile
(gauge)
The latency of paxos commit round - p75.
shown as microsecond
cassandra.cas_commit_latency.95th_percentile
(gauge)
The latency of paxos commit round - p95.
shown as microsecond
cassandra.cas_commit_latency.one_minute_rate
(gauge)
The number of paxos commit round per second.
shown as operation
cassandra.cas_prepare_latency.75th_percentile
(gauge)
The latency of paxos prepare round - p75.
shown as microsecond
cassandra.cas_prepare_latency.95th_percentile
(gauge)
The latency of paxos prepare round - p95.
shown as microsecond
cassandra.cas_prepare_latency.one_minute_rate
(gauge)
The number of paxos prepare round per second.
shown as operation
cassandra.cas_propose_latency.75th_percentile
(gauge)
The latency of paxos propose round - p75.
shown as microsecond
cassandra.cas_propose_latency.95th_percentile
(gauge)
The latency of paxos propose round - p95.
shown as microsecond
cassandra.cas_propose_latency.one_minute_rate
(gauge)
The number of paxos propose round per second.
shown as operation
cassandra.col_update_time_delta_histogram.75th_percentile
(gauge)
The column update time delta - p75.
shown as microsecond
cassandra.col_update_time_delta_histogram.95th_percentile
(gauge)
The column update time delta - p95.
shown as microsecond
cassandra.col_update_time_delta_histogram.min
(gauge)
The column update time delta - min.
shown as microsecond
cassandra.compaction_bytes_written.count
(gauge)
The amount of data that was compacted since (re)start.
shown as byte
cassandra.compression_ratio
(gauge)
The compression ratio for all SSTables. /!\ A low value means a high compression contrary to what the name suggests. Formula used is: 'size of the compressed SSTable / size of original'
shown as fraction
cassandra.currently_blocked_tasks
(gauge)
The number of currently blocked tasks for the thread pool.
shown as task
cassandra.currently_blocked_tasks.count
(gauge)
The number of currently blocked tasks for the thread pool.
shown as task
cassandra.db.droppable_tombstone_ratio
(gauge)
The estimate of the droppable tombstone ratio.
shown as fraction
cassandra.dropped.one_minute_rate
(gauge)
The tasks dropped during execution for the thread pool.
shown as thread
cassandra.exceptions.count
(gauge)
The number of exceptions thrown from ‘Storage’ metrics.
shown as error
cassandra.key_cache_hit_rate
(gauge)
The key cache hit rate.
shown as fraction
cassandra.latency.75th_percentile
(gauge)
The client request latency - p75.
shown as microsecond
cassandra.latency.95th_percentile
(gauge)
The client request latency - p95.
shown as microsecond
cassandra.latency.one_minute_rate
(gauge)
The number of client requests.
shown as request
cassandra.live_disk_space_used.count
(gauge)
The disk space used by "live" SSTables (only counts in use files).
shown as byte
cassandra.live_ss_table_count
(gauge)
Number of "live" (in use) SSTables.
shown as file
cassandra.load.count
(gauge)
The disk space used by live data on a node.
shown as byte
cassandra.max_partition_size
(gauge)
The size of the largest compacted partition.
shown as byte
cassandra.max_row_size
(gauge)
The size of the largest compacted row.
shown as byte
cassandra.mean_partition_size
(gauge)
The average size of compacted partition.
shown as byte
cassandra.mean_row_size
(gauge)
The average size of compacted rows.
shown as byte
cassandra.pending_compactions
(gauge)
The number of pending compactions.
shown as task
cassandra.pending_flushes.count
(gauge)
The number of pending flushes.
shown as flush
cassandra.pending_tasks
(gauge)
The number of pending tasks for the thread pool.
shown as task
cassandra.range_latency.75th_percentile
(gauge)
The local range request latency - p75.
shown as microsecond
cassandra.range_latency.95th_percentile
(gauge)
The local range request latency - p95.
shown as microsecond
cassandra.range_latency.one_minute_rate
(gauge)
The number of local range requests.
shown as request
cassandra.read_latency.75th_percentile
(gauge)
The local read latency - p75.
shown as microsecond
cassandra.read_latency.95th_percentile
(gauge)
The local read latency - p95.
shown as microsecond
cassandra.read_latency.99th_percentile
(gauge)
The local read latency - p99.
shown as microsecond
cassandra.read_latency.one_minute_rate
(gauge)
The number of local read requests.
shown as read
cassandra.row_cache_hit_out_of_range.count
(gauge)
The number of row cache hits that do not satisfy the query filter and went to disk.
shown as hit
cassandra.row_cache_hit.count
(gauge)
The number of row cache hits.
shown as hit
cassandra.row_cache_miss.count
(gauge)
The number of table row cache misses.
shown as miss
cassandra.snapshots_size
(gauge)
The disk space truly used by snapshots.
shown as byte
cassandra.ss_tables_per_read_histogram.75th_percentile
(gauge)
The number of SSTable data files accessed per read - p75.
shown as file
cassandra.ss_tables_per_read_histogram.95th_percentile
(gauge)
The number of SSTable data files accessed per read - p95.
shown as file
cassandra.tombstone_scanned_histogram.75th_percentile
(gauge)
Number of tombstones scanned per read - p75.
shown as record
cassandra.tombstone_scanned_histogram.95th_percentile
(gauge)
Number of tombstones scanned per read - p95.
shown as record
cassandra.total_commit_log_size
(gauge)
The size used on disk by commit logs.
shown as byte
cassandra.total_disk_space_used.count
(gauge)
Total disk space used by SSTables including obsolete ones waiting to be GC’d.
shown as byte
cassandra.view_lock_acquire_time.75th_percentile
(gauge)
The time taken acquiring a partition lock for materialized view updates - p75.
shown as microsecond
cassandra.view_lock_acquire_time.95th_percentile
(gauge)
The time taken acquiring a partition lock for materialized view updates - p95.
shown as microsecond
cassandra.view_lock_acquire_time.one_minute_rate
(gauge)
The number of requests to acquire a partition lock for materialized view updates.
shown as request
cassandra.view_read_time.75th_percentile
(gauge)
The time taken during the local read of a materialized view update - p75.
shown as microsecond
cassandra.view_read_time.95th_percentile
(gauge)
The time taken during the local read of a materialized view update - p95.
shown as microsecond
cassandra.view_read_time.one_minute_rate
(gauge)
The number of local reads for materialized view updates.
shown as request
cassandra.waiting_on_free_memtable_space.75th_percentile
(gauge)
The time spent waiting for free memtable space either on- or off-heap - p75.
shown as microsecond
cassandra.waiting_on_free_memtable_space.95th_percentile
(gauge)
The time spent waiting for free memtable space either on- or off-heap - p95.
shown as microsecond
cassandra.write_latency.75th_percentile
(gauge)
The local write latency - p75.
shown as microsecond
cassandra.write_latency.95th_percentile
(gauge)
The local write latency - p95.
shown as microsecond
cassandra.write_latency.99th_percentile
(gauge)
The local write latency - p99.
shown as microsecond
cassandra.write_latency.one_minute_rate
(gauge)
The number of local write requests.
shown as write

Events

The Cassandra check does not include any event at this time.

Service Checks

The Cassandra check does not include any service check at this time.

Troubleshooting

Need help? Contact Datadog Support.

Further Reading