Just looking for some friendly advice on displaying historic graphs with Grafana, InfluxDB and Telegraf.
I have a dashboard that shows combined network usage across 50 Servers in MB/s.
The query is:
SELECT sum(“Bytes_Received_persec”) AS “MB’s Recieved”, sum(“Bytes_Sent_persec”) AS “MB’s Sent” FROM “win_net” WHERE (“host” =~ /^BuildFarmNodes/ AND “instance” =~ /^network/) AND $timeFilter GROUP BY time(10s) fill(linear)
This graph works great and gives me good info for peaks and troughs and helps create a good snapshot of how busy the servers were over a 5 minute period. The same query works fine and scales up to about 24hrs however now i’m adding a row showing 7 day / 30 day and 12 month graphs. I need to tweak the query so it isn’t trying to use 10s metric intervals for 50 servers over a year
When i change the interval to 1m or 5m or 1hr the results that are generated arn’t giving me the information i expect. I’m assuming because i’m using the “Bytes_Per_sec” value and then asking for it to sum this over 1m/5m/1hr etc and it’s creating ridiculous throughput figures.
how do i scale this so that i can display a graph that simply shows the “bytes_per_sec” value in 10s intervals every say hour for 30 days?
I was thinking of using mean average of say 5min intervals but then realized that in a 5 minute interval the network might be using 4GB/s and then for the remaining 4m 50s it’s doing 1MB So the averaged data point isn’t representative anymore… help!