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 change in number for the count.
On Mon, Feb 26, 2018 at 2:18 AM, Nicolas Guyomar <nicolas.guyo...@gmail.com>
wrote:
> 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
>>>>
>>>>
>>
>
