These are chat archives for influxdata/influxdb

13th
Mar 2015
Daniel Middleton
@monokal
Mar 13 2015 09:20
Well, it may just be me being bit of a graphing 'noob' (quite possible), but there seems to be a lot of additional math required to get basic meaningful system stats from collectd in to a graph.
@DaveBlooman ^
David Blooman
@DaveBlooman
Mar 13 2015 10:27
what plugin are you using to write the data?
Daniel Middleton
@monokal
Mar 13 2015 10:32
For example, the dd plugin, cpu, etc
David Blooman
@DaveBlooman
Mar 13 2015 10:35
we use write graphite, our stats look like this collectd.cosmos.news-influxdb.int.hostname.cpu-0.cpu-idle
Daniel Middleton
@monokal
Mar 13 2015 10:38
Ah okay, so you use Graphite as opposed to InnoDB, but I imagine the figures are the same unless the write_graphite plugin changes them in a way InnoDB's read collectd plugin doesn't. What is the output of your cpu-idle query, seconds, ns, etc?
David Blooman
@DaveBlooman
Mar 13 2015 10:39
seconds
Daniel Middleton
@monokal
Mar 13 2015 10:41
My Influx query is "$host/cpu-0/cpu-idle" where $host is a template variable. The output is a huge number like 7 years so I'm guessing that's not in seconds.
select mean(value) from "$host/cpu-0/cpu-idle" where $timeFilter group by time($interval) order asc
Maybe because I'm using the default "mean"?
David Blooman
@DaveBlooman
Mar 13 2015 10:44
Here is a full query, select mean(value) from /collectd.cosmos.news-influxdb.live.*.cpu-[0-9]+.cpu-user/ where $timeFilter group by time($interval) order as we use write_graphite with influxdb, just so we can use TCP, have you tried that approach
Daniel Middleton
@monokal
Mar 13 2015 10:47
Thanks. I thought the write_graphite plugin was solely to write to a graphite target host to be honest so I've not tried that, I'm using the network plugin to write to influx
David Blooman
@DaveBlooman
Mar 13 2015 10:48
yeah, we decided against using UDP, so write_graphite was the second best option
Daniel Middleton
@monokal
Mar 13 2015 10:51
i'll have a go now, thank you
Daniel Middleton
@monokal
Mar 13 2015 11:11
Just to clarify, when you say you're using the write_graphite plugin, are you using that to write directly in to InfluxDB, or sending it to a Graphite host when then send it to Influx
which*
David Blooman
@DaveBlooman
Mar 13 2015 11:55
directly to influxdb
Daniel Middleton
@monokal
Mar 13 2015 12:04
Hmm interesting. Did you ever figure out how to turn the CPU stats in to percentages as opposed to 'jiffies'?
David Blooman
@DaveBlooman
Mar 13 2015 12:06
that query is all we use, the value returned is the percentage
Daniel Middleton
@monokal
Mar 13 2015 12:07
So the write_graphite plugin must do the conversion if that's correct.
David Blooman
@DaveBlooman
Mar 13 2015 12:07
i guess so
Daniel Middleton
@monokal
Mar 13 2015 12:08
Would you mind dropping me your write_graphite plugin config?
David Blooman
@DaveBlooman
Mar 13 2015 12:09
https://github.com/revett/collectd-docker - made by a guy in our team
Daniel Middleton
@monokal
Mar 13 2015 12:09
thanks you
Nope. You use Riemann to convert the values looking at your repo.
Daniel Middleton
@monokal
Mar 13 2015 12:16
The only difference I'm seeing is that you're using statsd, do you know where that comes in to the equation?