Op woensdag 5 oktober 2016 12:59:32 UTC+2 schreef [email protected]:
> Hi Team,
>
> I am creating the Disk I/O graph using Grafana and InfluxDB as Data Source. I
> am using the below query from Grafana to get both Read_Bytes and Write_Bytes
> for particular host.
>
> SELECT mean("read_bytes") AS "Read_Bytes", mean("write_bytes") AS
> "Write_Bytes" FROM "diskio" WHERE "host" =~ /^$hostname$/ AND $timeFilter
> GROUP BY time($interval) fill(null)
>
> I am getting two horizantal lines in graph for both fields and not getting
> the correct graph. When I select single field in query the graph is coming
> correct. Please let me know what changes needs to be done to get correct Disk
> I/O graph.
>
> Thanks and Regards,
> Sree
Try this:
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)
--
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/2f47f4c3-e65a-4bf1-91e5-917749e30312%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
