On Wednesday, May 18, 2016 at 5:56:31 AM UTC+5:30, Aidan Wong wrote:
> Hi Sean,
>
> Thanks for the suggestion. It worked out.
>
>
>
>
>
>
> On Mon, May 16, 2016 at 4:52 PM, Sean Beckett <[email protected]> wrote:
>
> Use the NON_NEGATIVE_DERIVATIVE function, which never returns a negative rate
> of change. The issue is that the counter can reset to zero, leading to a
> negative rate of change.
>
>
> On Thu, May 5, 2016 at 1:35 AM, Aidan Wong <[email protected]> wrote:
>
>
> Hi,
>
>
> Based on https://github.com/influxdata/telegraf/issues/171,
> I'm trying to get write and read per seconds statistics from the "diskio"
> measurement with the Influx SQL below, but the graph does not seem to be the
> correct representation has it shows negative number in Grafana:
> SELECT derivative("writes", 1s) FROM "diskio"
> Can someone suggest how I can get reads/s and writes/s from "diskio"
> measurement?
>
>
> Thanks
>
>
>
>
> --
>
> Remember to include the InfluxDB version number with all issue reports
>
> ---
>
> You received this message because you are subscribed to the Google Groups
> "InfluxDB" group.
>
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
>
> To post to this group, send email to [email protected].
>
> Visit this group at https://groups.google.com/group/influxdb.
>
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/influxdb/1771af5e-46a2-44a1-adbb-d6652c081650%40googlegroups.com.
>
> For more options, visit https://groups.google.com/d/optout.
>
>
>
>
>
> --
>
>
> Sean Beckett
> Director of Support and Professional Services
> InfluxDB
>
>
>
>
>
> --
>
> Remember to include the InfluxDB version number with all issue reports
>
> ---
>
> You received this message because you are subscribed to a topic in the Google
> Groups "InfluxDB" group.
>
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/influxdb/1Dk42B-bJwo/unsubscribe.
>
> To unsubscribe from this group and all its topics, send an email to
> [email protected].
>
> To post to this group, send email to [email protected].
>
> Visit this group at https://groups.google.com/group/influxdb.
>
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/influxdb/CALGqCvO5i1twdV12KZK-8M2ECg2-Hc9t0heshLt4xYpdJ0cdKQ%40mail.gmail.com.
>
>
>
> For more options, visit https://groups.google.com/d/optout.
Hi Aidan,
I am trying to get both read and write bytes on the graph using query for
particular host. I am getting two horizantal lines when both are read. This is
query used
SELECT mean("read_bytes") AS "Read_Bytes", mean("write_bytes") AS "Write_Bytes"
FROM "diskio" WHERE "host" =~ /^$hostname$/ AND $timeFilter GROUP BY
time($interval), "host" fill(null)
Can you tell me how it worked for you.
Thanks and Regards,
Sree
--
Remember to include the InfluxDB version number with all issue reports
---
You received this message because you are subscribed to the Google Groups
"InfluxDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit
https://groups.google.com/d/msgid/influxdb/e11e821c-6893-44b7-b364-80a3bf8465e1%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
