Re: Cassandra Hints monitoring

2018-02-26 Thread Jai Bheemsen Rao Dhanwada
This works when the count value is changing/increasing. In my case if the Hints total value is 10 for 2 hours, the difference(sum("TotalHints_Count")) is going to be 10 for that 10 seconds time period and then it will be 0 later on. where as the value should be constantly 10 until there is a chang

Re: Cassandra Hints monitoring

2018-02-26 Thread Nicolas Guyomar
I find DIFFERENCE to be working for dropped mutation, which IMHO works the same way as Hint metrics *select difference(sum("Dropped_Count")) FROM "cassandraDroppedMessage" groupby host* is valid when I check with nodetool over a period of time Not sure what is not working on your side On 26 Feb

Re: Cassandra Hints monitoring

2018-02-26 Thread Jai Bheemsen Rao Dhanwada
DIFFERENCE may not work here, if the Hints count is 10 for few hours, the difference is always is zero. which is not the correct value. On Mon, Feb 26, 2018 at 1:18 AM, Jai Bheemsen Rao Dhanwada < jaibheem...@gmail.com> wrote: > Thanks Alex, > > Let me try it. > > > On Monday, February 26, 2018,

Re: Cassandra Hints monitoring

2018-02-26 Thread Jai Bheemsen Rao Dhanwada
Thanks Alex, Let me try it. On Monday, February 26, 2018, Oleksandr Shulgin < oleksandr.shul...@zalando.de> wrote: > On Mon, Feb 26, 2018 at 10:02 AM, Jai Bheemsen Rao Dhanwada < > jaibheem...@gmail.com> wrote: > >> Thank you Alex, >> >> I tried "TotalHintsInProgress" already, and I don't see it

Re: Cassandra Hints monitoring

2018-02-26 Thread Oleksandr Shulgin
On Mon, Feb 26, 2018 at 10:02 AM, Jai Bheemsen Rao Dhanwada < jaibheem...@gmail.com> wrote: > Thank you Alex, > > I tried "TotalHintsInProgress" already, and I don't see it sending the > correct metrics. I used mean("TotalHintsInProgress") and I see 0 always > on grafana. > Do you know what is the

Re: Cassandra Hints monitoring

2018-02-26 Thread Jai Bheemsen Rao Dhanwada
Thank you Alex, I tried "TotalHintsInProgress" already, and I don't see it sending the correct metrics. I used mean("TotalHintsInProgress") and I see 0 always on grafana. Do you know what is the correct way to do rate or diff for hints using "TotalHints"? I am currently using the below query SELE

Re: Cassandra Hints monitoring

2018-02-26 Thread Oleksandr Shulgin
On Mon, Feb 26, 2018 at 8:21 AM, Jai Bheemsen Rao Dhanwada < jaibheem...@gmail.com> wrote: > > 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 replaye

Cassandra Hints monitoring

2018-02-25 Thread Jai Bheemsen Rao Dhanwada
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 me