[rrd-users] graph from mysql

Wed May 15 17:34:47 CEST 2013

thanks for your email, before ur msg i tried my self /derive and the graphs
are normal. kindly look at attachment.

actually i fetch data from switches and i have tried option -v 2c but the
result is same, 32 bit counter. can u explain it to me wat derive does and
i dont have to worry about other thigns like calculating data etc my self,
if you dont mind.

can u also look at my graph generating cmd to verify if im not doing any
thing wrong,

rrdtool graph test.png --imgformat=PNG --start=-2day --end=-1day
-S=300    "DEF:up=$UP:min:AVERAGE"     "DEF:down=$DOWN:min:AVERAGE"
AREA:down#2ECCFA:"Out traffic"   AREA:up#013ADF:"Download"
--vertical-label=bytes/sec --title="ADSL bandwidth graphs"
GPRINT:up:LAST:"Current\:%8.2lf %s\n"  GPRINT:up:AVERAGE:"Average\:%8.2lf
%s\n"  GPRINT:up:MAX:"Maximum\:%8.2lf %s\n" --font TITLE:12: --font AXIS:8:
--font LEGEND:10: --font UNIT:8: AREA:up#013ADF:"In traffic"

I am sorry if im teasing you,
Shabbir.

On Wed, May 15, 2013 at 7:36 PM, Martin Sperl <rrdtool at martin.sperl.org>wrote:

> so you are using the 32bit counter.
>
> Then if you insert into the database, you:
> either have to do the "wraparound" logic yourself prior to inserting the
> values
> or you insert the "absolute" counter values and use /derive (as explained
> before)
> if you use the rrd flatfile database via rrdcreate and update, then
> (depending on the definition of the rrd-file) rrd will try to do the
> "overflow" detection...
>
> Martin
>
> P.s: the 64bit counter are typically only available if you use snmp V2C -
> google for "64 bit counter SNMP" and you should find enough information on
> how to use it.
>
>
> On 15.05.2013, at 10:07, Shabbir Ahmed wrote:
>
> quering the device snmpbulkget -c public 119.156.203.217 .
> 1.3.6.1.2.1.2.2.1.10 -v 2c
> returns 32bit integers
> IF-MIB::ifInOctets.20971520 = Counter32: 0
> IF-MIB::ifInOctets.20972032 = Counter32: 0
> IF-MIB::ifInOctets.20972544 = Counter32: 1295822366
> IF-MIB::ifInOctets.20973056 = Counter32: 1295822366
> IF-MIB::ifInOctets.20973568 = Counter32: 1295822366
> IF-MIB::ifInOctets.20974080 = Counter32: 1295822366
>
>
> 2nd question is most of the values are always same is it the reason port
> is down?
>
> 3rd question what if counter reaches its up limit and starts from 0 again,
> how rrd tool manages it? or should we have to manage our self?
>
> kindly help further with this issue.
>
> thanks,
>
>
> On Wed, May 15, 2013 at 11:53 AM, Martin Sperl <rrdtool at martin.sperl.org>wrote:
>
>> Seems as if you are having "integer overflow" issues reading the 32bit
>> SNMP values (or when calculating the delta of the counters in your program).
>>
>> These rollovers is something your application will need to figure out
>> prior to inserting into the database - either by detecting a "rollover"
>> (the "rrdtool update" command for rrd files - not used with the dbi backend
>> - has a provision for that) or by querying the 64bit values on the router
>> instead and then inserting those values. Alternatively the dbi backend can
>> also "try" to do the calculations for you on the fly if you insert the
>> absolute counter values - see the man-page for details of which option to
>> use... (/derive after the data column)
>>
>> Martin
>>
>>
>>
>> On 14.05.2013, at 20:03, Shabbir Ahmed wrote:
>>
>> yes i used, this time i made graphs for my dsl router at home and they
>> are doing better, but the connection is 4mb and the graph shows 1.5G, i hv
>> checked database has large values, but these are ported from device, what i
>> do i need to do now devid the values on something to get the desired value?
>>
>>
>>
>>
>> On Tue, May 14, 2013 at 12:31 AM, Martin Sperl <rrdtool at martin.sperl.org>wrote:
>>
>>> 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<http://127.0.0.1/dbname=newdsl/username=root/password=nocb4enter//g3412306061/time/up/idx=201409600>
>>>> /rrdfillmissing=1//g3412306061/time/up/idx=201409600<http://127.0.0.1/dbname=newdsl/username=root/password=nocb4enter//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
>>>>
>>>>
>>>>
>>>
>>>
>> <test.png>
>>
>>
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.oetiker.ch/pipermail/rrd-users/attachments/20130515/263432cf/attachment-0001.htm 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: test.png
Type: image/png
Size: 15771 bytes
Desc: not available
Url : http://lists.oetiker.ch/pipermail/rrd-users/attachments/20130515/263432cf/attachment-0001.png 