[rrd-users] graph from mysql

[Martin Sperl]

Did you try the /rrdfillmissing=1/ as mentioned below as a workaround for your "missing" data?

Martin


On 13.05.2013, at 18:27, Shabbir Ahmed wrote:

> 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:
> Hi!
> 
> 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 3599)
> 
> 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"     "LINE1:min#336600:value"
> 
> 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=127.0.0.1/dbname=newdsl/username=root/password=nocb4enter/rrdfillmissing=1//g3412306061/time/up/idx=201409600"
> 
> Ciao,
> 	Martin
> 
> On 12.05.2013, at 15:05, Shabbir Ahmed wrote:
> 
>> Hi, i collect data from switches and save them into mysql, (snmpidx,time,up,down)
>> 
>> now i want to draw graphs using 
>> 
>> DOWN="sql//mysql/host=127.0.0.1/dbname=newdsl/username=root/password=nocb4enter//g3412306061/time/down/idx=201343232"
>> UP="sql//mysql/host=127.0.0.1/dbname=newdsl/username=root/password=nocb4enter//g3412306061/time/up/idx=201409600"
>> 
>> 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
>> https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
> 
> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.oetiker.ch/pipermail/rrd-users/attachments/20130513/8f00c2da/attachment-0001.htm