[rrd-users] graph from mysql
shabbir1282 at gmail.com
Mon May 13 18:27:43 CEST 2013
some time when i query for snmp the get times out so i cant fill in the
table at that time, to fix this wat should i do ?
12:00 i queried db response recorded into mysql
12:05 i queried but snmp get timeout, no entry into mysql
12:06 i queried and got the response into mysql.
On Mon, May 13, 2013 at 11:36 AM, Martin Sperl <rrdtool at martin.sperl.org>wrote:
> One observation: actually you should see 4 lines not 2 or 1.
> The other is that your data is possibly not stored "equidistant", so that
> there are slight "gaps" of say 302 seconds between consecutive datapoints,
> which would mean that you are producing times like
> this: 0,302,603,...,3298,3601,... (so there would be a gap at time 3300 to
> For debugging purposes: can you please run rrdtool like this:
> RRDDEBUGSQL=1 *rrdtool graph test.png --imgformat=PNG --start=-1day
> --width=600 --height=80 -S=300 "DEF:min=$UP:min:AVERAGE"
> Then you will see the SQL that gets executed and then you can run the SQL
> on your own to understand how this "gaps" are generated from the database...
> But there is also an option to "fill in" "missing" gaps in rrd via the
> "/rrdfillmissing=" option. The idea here is similar to the "xff" argument
> to rrdcreate for the RRA definition.
> So you may try to add it to your DEF like this: UP="sql//mysql/host=
> On 12.05.2013, at 15:05, Shabbir Ahmed wrote:
> Hi, i collect data from switches and save them into mysql,
> now i want to draw graphs using
> *rrdtool graph test.png --imgformat=PNG --start=-1day --width=600
> --height=80 -S=300 "DEF:min=$UP:min:AVERAGE"
> "LINE1:min#336600:value" "DEF:avg=$UP:avg:AVERAGE"
> "LINE1:avg#00FF11:average" "DEF:max=$UP:max:AVERAGE"
> "LINE1:max#FF0000:max" "DEF:dw=$DOWN:min:AVERAGE" "LINE1:dw#0033CC:value"
> *1. the graphs drawn has gaps (i collect data every five mins) and draw
> them with 5 mins step but still the gape bw two occurences are empty.
> *2. it doesnt draw two lines.
> *Kindly help,
> rrd-users mailing list
> rrd-users at lists.oetiker.ch
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the rrd-users