Cassandra Monitoring
Getting Network Statistics in a Cluster
The nodetool proxyhistograms command shows the network statistics in a cluster.
nodetool proxyhistograms
proxy histograms
Percentile Read Latency Write Latency Range Latency CAS Read Latency CAS Write Latency View Write Latency
(micros) (micros) (micros) (micros) (micros) (micros)
50% 1131.75 0.00 1955.67 0.00 0.00 0.00
75% 1955.67 0.00 2816.16 0.00 0.00 0.00
95% 1955.67 0.00 4866.32 0.00 0.00 0.00
98% 1955.67 0.00 4866.32 0.00 0.00 0.00
99% 1955.67 0.00 4866.32 0.00 0.00 0.00
Min 943.13 0.00 379.02 0.00 0.00 0.00
Max 1955.67 0.00 4866.32 0.00 0.00 0.00
Getting Table-Level Statistics
nodetool tablestats
nodetool tablestats simplex.playlists
Total number of tables: 41
----------------
Keyspace : simplex
Read Count: 1
Read Latency: 0.14 ms
Write Count: 2
Write Latency: 0.2 ms
Pending Flushes: 0
Table: playlists
SSTable count: 0
Space used (live): 0
Space used (total): 0
Space used by snapshots (total): 0
Off heap memory used (total): 0
SSTable Compression Ratio: -1.0
Number of partitions (estimate): 0
Memtable cell count: 1
Memtable data size: 118
Memtable off heap memory used: 0
Memtable switch count: 0
Local read count: 1
Local read latency: NaN ms
Local write count: 1
Local write latency: NaN ms
Pending flushes: 0
Percent repaired: 100.0
Bloom filter false positives: 0
Bloom filter false ratio: 0.00000
Bloom filter space used: 0
Bloom filter off heap memory used: 0
Index summary off heap memory used: 0
Compression metadata off heap memory used: 0
Compacted partition minimum bytes: 0
Compacted partition maximum bytes: 0
Compacted partition mean bytes: 0
Average live cells per slice (last five minutes): NaN
Maximum live cells per slice (last five minutes): 0
Average tombstones per slice (last five minutes): NaN
Maximum tombstones per slice (last five minutes): 0
Dropped Mutations: 0
----------------
Getting Network Information from the Host
nodetool netstats -H
nodetool netstats -H
Mode: NORMAL
Not sending any streams.
Read Repair Statistics:
Attempted: 0
Mismatch (Blocking): 0
Mismatch (Background): 0
Pool Name Active Pending Completed Dropped
Large messages n/a 0 0 0
Small messages n/a 0 0 0
Gossip messages n/a 0 0 0
Getting Statistics About Tables
nodetool tablehistograms simplex songs
nodetool tablehistograms simplex songs
No SSTables exists, unable to calculate 'Partition Size' and 'Cell Count' percentiles
simplex/songs histograms
Percentile SSTables Write Latency Read Latency Partition Size Cell Count
(micros) (micros) (bytes)
50% 0.00 0.00 0.00 NaN NaN
75% 0.00 0.00 0.00 NaN NaN
95% 0.00 0.00 0.00 NaN NaN
98% 0.00 0.00 0.00 NaN NaN
99% 0.00 0.00 0.00 NaN NaN
Min 0.00 0.00 0.00 NaN NaN
Max 0.00 0.00 0.00 NaN NaN
Checking the Cluster Health
nodetool status
nodetool status
Datacenter: datacenter1
=======================
Status=Up/Down
|/ State=Normal/Leaving/Joining/Moving
-- Address Load Tokens Owns Host ID Rack
UN 127.0.0.1 293.54 KiB 256 ? 60bc1910-eb04-4c7f-bc44-4de3643ce4f4 rack1
Note: Non-system keyspaces don't have the same replication settings, effective ownership information is meaningless
nodetool info
nodetool info
ID : 60bc1910-eb04-4c7f-bc44-4de3643ce4f4
Gossip active : true
Thrift active : false
Native Transport active: true
Load : 293.54 KiB
Generation No : 1522053320
Uptime (seconds) : 7062
Heap Memory (MB) : 191.25 / 1004.00
Off Heap Memory (MB) : 0.00
Data Center : datacenter1
Rack : rack1
Exceptions : 0
Key Cache : entries 28, size 2.2 KiB, capacity 50 MiB, 88 hits, 125 requests, 0.704 recent hit rate, 14400 save period in seconds
Row Cache : entries 0, size 0 bytes, capacity 0 bytes, 0 hits, 0 requests, NaN recent hit rate, 0 save period in seconds
Counter Cache : entries 0, size 0 bytes, capacity 25 MiB, 0 hits, 0 requests, NaN recent hit rate, 7200 save period in seconds
Chunk Cache : entries 19, size 1.19 MiB, capacity 219 MiB, 77 misses, 331 requests, 0.767 recent hit rate, NaN microseconds miss latency
Percent Repaired : 0.0%
Token : (invoke with -T/--tokens to see all 256 tokens)
nodetool tpstats (Thread Pools Statistics)
nodetool tpstats
Pool Name Active Pending Completed Blocked All time blocked
ReadStage 0 0 73 0 0
MiscStage 0 0 0 0 0
CompactionExecutor 0 0 4579 0 0
MutationStage 0 0 2 0 0
MemtableReclaimMemory 0 0 31 0 0
PendingRangeCalculator 0 0 1 0 0
GossipStage 0 0 0 0 0
SecondaryIndexManagement 0 0 0 0 0
HintsDispatcher 0 0 0 0 0
RequestResponseStage 0 0 0 0 0
Native-Transport-Requests 0 0 276 0 0
ReadRepairStage 0 0 0 0 0
CounterMutationStage 0 0 0 0 0
MigrationStage 0 0 3 0 0
MemtablePostFlush 0 0 46 0 0
PerDiskMemtableFlushWriter_0 0 0 31 0 0
ValidationExecutor 0 0 0 0 0
Sampler 0 0 0 0 0
MemtableFlushWriter 0 0 31 0 0
InternalResponseStage 0 0 0 0 0
ViewMutationStage 0 0 0 0 0
AntiEntropyStage 0 0 0 0 0
CacheCleanupExecutor 0 0 0 0 0
Message type Dropped
READ 0
RANGE_SLICE 0
_TRACE 0
HINT 0
MUTATION 0
COUNTER_MUTATION 0
BATCH_STORE 0
BATCH_REMOVE 0
REQUEST_RESPONSE 0
PAGED_RANGE 0
READ_REPAIR 0
Using Jmx Clients
jconsole 127.0.0.1:7199