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 February 2018 at 11:02, Jai Bheemsen Rao Dhanwada <
jaibheem...@gmail.com> wrote:
> 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, 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 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
>>>>
>>>> SELECT mean("TotalHints_Count") FROM "cassandraStorage"
>>>> WHERE $timeFilter GROUP BY time(10s)
>>>>
>>>
>>> I've never really used InfluxDB, but it seems that DIFFERENCE is what
>>> you're looking for: https://docs.influxdata.c
>>> om/influxdb/v1.4/query_language/functions/#difference
>>>
>>> --
>>> Alex
>>>
>>>
>
