[rrd-users] graph from mysql

[Shabbir Ahmed]

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,
*
*
*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.oetiker.ch/pipermail/rrd-users/attachments/20130512/30cc1ed7/attachment.htm