The following statistics are gathered by the Cassandra pool maintenance provider implementation included with Rhino:
HeartbeatCassandraStats
Cassandra heartbeat table statistics
OID: 1.3.6.1.4.1.19808.2.1.82.1.1
| Name | Short Name | Mapping | Description | Type | Unit Label | Default View | Source Units | Default Display Units |
|---|---|---|---|---|---|---|---|---|
batchesCreated |
batches |
2 |
Cassandra BATCH statements created |
counter |
# |
counter |
||
batchedStatements |
bStmts |
3 |
UPDATE/DELETE statements included in a BATCH |
counter |
# |
counter |
||
batchedStatementSizeTotal |
bStmtSzT |
4 |
Total size of all UPDATE/DELETE statements that were batched |
counter |
bytes |
counter |
||
notBatchedStatements |
XbStmts |
5 |
UPDATE/DELETE statements not included in a BATCH |
counter |
# |
counter |
||
notBatchedStatementSizeTotal |
XbStmtSzT |
6 |
Total size of all UPDATE/DELETE statements that were not batched |
counter |
bytes |
counter |
||
querySuccesses |
succ |
7 |
Database queries that executed successfully |
counter |
# |
counter |
||
queryFailures |
fail |
8 |
Database queries that failed during execution |
counter |
# |
counter |
||
resultHandlingExceptions |
resExc |
9 |
Exceptions thrown while handling statement results |
counter |
# |
counter |
||
executorDriverExceptions |
drvExc |
50 |
Exceptions thrown from the Cassandra driver while executing statements |
counter |
# |
counter |
||
queryCyclesSucceeded |
cycQySucc |
100 |
The number of table query cycles where all database sessions returned data |
counter |
# |
counter |
||
queryCyclesPartiallySucceeded |
cycQyPrtSucc |
101 |
The number of table query cycles where only some database sessions returned data |
counter |
# |
counter |
||
queryCyclesFailed |
cycQyFail |
102 |
The number of table query cycles where no database sessions returned data |
counter |
# |
counter |
||
updateCyclesSucceeded |
cycUpSucc |
103 |
The number of table update cycles where all database sessions completed the update successfully |
counter |
# |
counter |
||
updateCyclesPartiallySucceeded |
cycUpPrtSucc |
104 |
The number of table update cycles where only some database sessions completed the update successfully |
counter |
# |
counter |
||
updateCyclesFailed |
cycUpFail |
105 |
The number of table update cycles where no database sessions updated successfully |
counter |
# |
counter |
||
batchedStatementSize |
bStmtSz |
Size of UPDATE/DELETE statements that were batched |
sample |
bytes |
count |
count |
||
notBatchedStatementSize |
XbStmtSz |
Size of UPDATE/DELETE statements that were not batched |
sample |
bytes |
count |
count |
||
persistedBatchSize |
persSz |
Total size of all UPDATE/DELETE statements batched in each persistence cycle |
sample |
bytes |
count |
count |
||
queryCycleLatency |
cycQyTime |
Time taken to execute database statements for a query cycle when there is at least one active database session |
sample |
ms |
time/milliseconds |
time/milliseconds |
||
readTime |
readT |
Time taken to execute each SELECT statement |
sample |
ms |
time/milliseconds |
time/milliseconds |
||
updateCycleLatency |
cycUpTime |
Time taken to execute database statements for an update cycle where there is at least one active database session |
sample |
ms |
time/milliseconds |
time/milliseconds |
||
writeTime |
writeT |
Time taken to execute (potentially batched) UPDATE/DELETE statements |
sample |
ms |
time/milliseconds |
time/milliseconds |
HeartbeatSubsystemStats
Heartbeat Subsystem statistics
OID: 1.3.6.1.4.1.19808.2.1.82.1.2
| Name | Short Name | Mapping | Description | Type | Unit Label | Default View | Source Units | Default Display Units |
|---|---|---|---|---|---|---|---|---|
nodeJoined |
ndeJnd |
5 |
The number of times that a node has joined the pool |
counter |
# |
counter |
||
nodeLeft |
ndeLft |
6 |
The number of times that a node has left the pool |
counter |
# |
counter |
||
poolMembershipChanged |
memChg |
7 |
The number of times that the pool membership has changed |
counter |
# |
counter |
||
checkNodeLiveness |
chkNdeLv |
8 |
The number of individual node liveness checks that have been performed on heartbeat data |
counter |
# |
counter |
||
queriesTotal |
qTot |
9 |
The number of heartbeat table queries that have been attempted |
counter |
# |
counter |
||
updatesTotal |
upTot |
10 |
The number of heartbeat updates that have been attempted |
counter |
# |
counter |
NodeMetadataCassandraStats
Cassandra node metadata table statistics
OID: 1.3.6.1.4.1.19808.2.1.82.1.3
| Name | Short Name | Mapping | Description | Type | Unit Label | Default View | Source Units | Default Display Units |
|---|---|---|---|---|---|---|---|---|
batchesCreated |
batches |
2 |
Cassandra BATCH statements created |
counter |
# |
counter |
||
batchedStatements |
bStmts |
3 |
UPDATE/DELETE statements included in a BATCH |
counter |
# |
counter |
||
batchedStatementSizeTotal |
bStmtSzT |
4 |
Total size of all UPDATE/DELETE statements that were batched |
counter |
bytes |
counter |
||
notBatchedStatements |
XbStmts |
5 |
UPDATE/DELETE statements not included in a BATCH |
counter |
# |
counter |
||
notBatchedStatementSizeTotal |
XbStmtSzT |
6 |
Total size of all UPDATE/DELETE statements that were not batched |
counter |
bytes |
counter |
||
querySuccesses |
succ |
7 |
Database queries that executed successfully |
counter |
# |
counter |
||
queryFailures |
fail |
8 |
Database queries that failed during execution |
counter |
# |
counter |
||
resultHandlingExceptions |
resExc |
9 |
Exceptions thrown while handling statement results |
counter |
# |
counter |
||
executorDriverExceptions |
drvExc |
50 |
Exceptions thrown from the Cassandra driver while executing statements |
counter |
# |
counter |
||
queryCyclesSucceeded |
cycQySucc |
100 |
The number of table query cycles where all database sessions returned data |
counter |
# |
counter |
||
queryCyclesPartiallySucceeded |
cycQyPrtSucc |
101 |
The number of table query cycles where only some database sessions returned data |
counter |
# |
counter |
||
queryCyclesFailed |
cycQyFail |
102 |
The number of table query cycles where no database sessions returned data |
counter |
# |
counter |
||
updateCyclesSucceeded |
cycUpSucc |
103 |
The number of table update cycles where all database sessions completed the update successfully |
counter |
# |
counter |
||
updateCyclesPartiallySucceeded |
cycUpPrtSucc |
104 |
The number of table update cycles where only some database sessions completed the update successfully |
counter |
# |
counter |
||
updateCyclesFailed |
cycUpFail |
105 |
The number of table update cycles where no database sessions updated successfully |
counter |
# |
counter |
||
batchedStatementSize |
bStmtSz |
Size of UPDATE/DELETE statements that were batched |
sample |
bytes |
count |
count |
||
notBatchedStatementSize |
XbStmtSz |
Size of UPDATE/DELETE statements that were not batched |
sample |
bytes |
count |
count |
||
persistedBatchSize |
persSz |
Total size of all UPDATE/DELETE statements batched in each persistence cycle |
sample |
bytes |
count |
count |
||
queryCycleLatency |
cycQyTime |
Time taken to execute database statements for a query cycle when there is at least one active database session |
sample |
ms |
time/milliseconds |
time/milliseconds |
||
readTime |
readT |
Time taken to execute each SELECT statement |
sample |
ms |
time/milliseconds |
time/milliseconds |
||
updateCycleLatency |
cycUpTime |
Time taken to execute database statements for an update cycle where there is at least one active database session |
sample |
ms |
time/milliseconds |
time/milliseconds |
||
writeTime |
writeT |
Time taken to execute (potentially batched) UPDATE/DELETE statements |
sample |
ms |
time/milliseconds |
time/milliseconds |
