Hello, I am trying to evaluate the JMX hints metrics for cassandra(TotalHints). However, when I am testing the metrics, the total hints accumulated count shows perfectly fine, but when the hints are replayed and the hints count(cql> SELECT * from system.hints; ) becomes zero on cql, and the JMX metrics counter doesn't reset to zero and stays at the last known non-zero value(eg: 6). when new hints are created the total get added to the last non-zero count(e.g 6+2). Any idea if there is a way to get the active count during the given time period?
I am using the JMX metrics on Cassandra nodes and sending the data to Influx DB and querying it using Grafana with mean using mean("TotalHints_Count") from storage-metrics with group by 10s. Any pointers on this is higly appreciated.