[rrd-users] Problems getting graphs from mysql backend (resolution).
Guillermo Javier Nardoni - BUNAR SRL
gnardoni at bunarsrl.com.ar
Sat Jan 17 19:29:53 CET 2015
Hello list.
I have an issue building graphs using mysql as backend.
I use a php script to obtain and generate the graph but there are gaps
between values and I don’t know why.
Could you please help me?.
$DS_BASE="sql//mysql/host=myhost/dbname=cotelser/username=myuser/password=my
pass/rrdminstepsize=300/rrdfillmissing=0//tbl_DetNASSNMPStats/UNIXTIMESTAMP/
IFACE_IN_OCTETS/derive/ID=15/NRORENGLON=9";
$DS_BASE2="sql//mysql/host=myhost/dbname=cotelser/username=myuser/password=m
ypass/rrdminstepsize=300/rrdfillmissing=0//tbl_DetNASSNMPStats/UNIXTIMESTAMP
/IFACE_OUT_OCTETS/derive/ID=15/NRORENGLON=9";
$command = 'rrdtool graph rrd/test1.png ' .
'--slope-mode ' .
'--title "INTERFAZ: " ' .
'--imgformat=PNG ' .
'--start=-1day ' .
'--lazy ' .
'--height=120 ' .
'--width=800 ' .
'-l 0 ' .
'--vertical-label "byes/sec" ' .
'"DEF:in='.$DS_BASE.':max:AVERAGE:step=300" ' .
'"DEF:out='.$DS_BASE2.':max:AVERAGE:step=300" ' .
'"CDEF:int_m=in,1024,/" ' .
'"AREA:in#32cd32:Tráfico Entrante" ' .
'"LINE1:in#336600" ' .
'"GPRINT:in:MAX: Max\\: %5.1lf %s" ' .
'"GPRINT:in:AVERAGE: Avg\\: %5.1lf %S" ' .
'"GPRINT:in:LAST: Current\\: %5.1lf %Sbytes/sec\\n" ' .
'"CDEF:out_m=out,1024,/" ' .
'"CDEF:out_f=out,-1,*" ' .
'"AREA:out_f#4169E1:Tráfico Saliente" ' .
'"LINE1:out_f#0033cc" ' .
'"GPRINT:out:MAX: Max\\: %5.1lf %s" ' .
'"GPRINT:out:AVERAGE: Avg\\: %5.1lf %S" ' .
'"GPRINT:out:LAST: Current\\: %5.1lf %Sbytes/sec\\n" ' .
'"HRULE:0#000000"';
echo "$command<br>";
$salida = shell_exec($command);
print_r($salida);
exit();
This script generate a command to execute vía shell_exec (I did run it
through Linux Shell also) which generate the next graphic.
As you can see, there are gaps in some situations.
Also I paste a key,value pair for every record used to graphic this picture.
UNIXTIMESTAMP: 1421469602 - VALUE: 2147483647
UNIXTIMESTAMP: 1421469901 - VALUE: 2147483647
UNIXTIMESTAMP: 1421470201 - VALUE: 163540881
UNIXTIMESTAMP: 1421470501 - VALUE: 518975306
UNIXTIMESTAMP: 1421470802 - VALUE: 857284793
UNIXTIMESTAMP: 1421471101 - VALUE: 1102831558
UNIXTIMESTAMP: 1421471401 - VALUE: 1386037303
UNIXTIMESTAMP: 1421471701 - VALUE: 1681176534
UNIXTIMESTAMP: 1421472002 - VALUE: 1952529044
UNIXTIMESTAMP: 1421472301 - VALUE: 2147483647
UNIXTIMESTAMP: 1421472601 - VALUE: 2147483647
UNIXTIMESTAMP: 1421472901 - VALUE: 2147483647
UNIXTIMESTAMP: 1421473201 - VALUE: 2847086150
UNIXTIMESTAMP: 1421473503 - VALUE: 3019834879
UNIXTIMESTAMP: 1421473801 - VALUE: 3154089687
UNIXTIMESTAMP: 1421474101 - VALUE: 3313917332
UNIXTIMESTAMP: 1421474401 - VALUE: 3443161047
UNIXTIMESTAMP: 1421474701 - VALUE: 3610549796
UNIXTIMESTAMP: 1421475001 - VALUE: 3775192078
UNIXTIMESTAMP: 1421475301 - VALUE: 3998976505
UNIXTIMESTAMP: 1421475605 - VALUE: 4142620562
UNIXTIMESTAMP: 1421475901 - VALUE: 4219497371
UNIXTIMESTAMP: 1421476201 - VALUE: 149205835
UNIXTIMESTAMP: 1421476501 - VALUE: 350459967
UNIXTIMESTAMP: 1421476801 - VALUE: 579857427
UNIXTIMESTAMP: 1421477101 - VALUE: 883366629
UNIXTIMESTAMP: 1421477401 - VALUE: 1150197757
UNIXTIMESTAMP: 1421477701 - VALUE: 1386002856
UNIXTIMESTAMP: 1421478001 - VALUE: 1597852870
UNIXTIMESTAMP: 1421478302 - VALUE: 1781209246
UNIXTIMESTAMP: 1421478601 - VALUE: 1944855343
UNIXTIMESTAMP: 1421478901 - VALUE: 2096223907
UNIXTIMESTAMP: 1421479201 - VALUE: 2246867064
UNIXTIMESTAMP: 1421479501 - VALUE: 2395748762
UNIXTIMESTAMP: 1421479801 - VALUE: 2546890705
UNIXTIMESTAMP: 1421480104 - VALUE: 2698891644
UNIXTIMESTAMP: 1421480401 - VALUE: 2892023127
UNIXTIMESTAMP: 1421480704 - VALUE: 3082356421
UNIXTIMESTAMP: 1421481004 - VALUE: 3288155090
UNIXTIMESTAMP: 1421481301 - VALUE: 3441384994
UNIXTIMESTAMP: 1421481601 - VALUE: 3597207322
UNIXTIMESTAMP: 1421481902 - VALUE: 3758453120
UNIXTIMESTAMP: 1421482201 - VALUE: 3919084229
UNIXTIMESTAMP: 1421482501 - VALUE: 4096616627
UNIXTIMESTAMP: 1421482801 - VALUE: 4257022849
UNIXTIMESTAMP: 1421483101 - VALUE: 140837180
UNIXTIMESTAMP: 1421483403 - VALUE: 319734182
UNIXTIMESTAMP: 1421483701 - VALUE: 473114575
UNIXTIMESTAMP: 1421484002 - VALUE: 632862515
UNIXTIMESTAMP: 1421484301 - VALUE: 796121296
UNIXTIMESTAMP: 1421484601 - VALUE: 964809387
UNIXTIMESTAMP: 1421484902 - VALUE: 1148885775
UNIXTIMESTAMP: 1421485201 - VALUE: 1340724450
UNIXTIMESTAMP: 1421485501 - VALUE: 1510426906
UNIXTIMESTAMP: 1421485801 - VALUE: 1672762026
UNIXTIMESTAMP: 1421486101 - VALUE: 1833660454
UNIXTIMESTAMP: 1421486401 - VALUE: 2000054024
UNIXTIMESTAMP: 1421486702 - VALUE: 2170478736
UNIXTIMESTAMP: 1421487001 - VALUE: 2348985619
UNIXTIMESTAMP: 1421487302 - VALUE: 2530266606
UNIXTIMESTAMP: 1421487601 - VALUE: 2707468520
UNIXTIMESTAMP: 1421487901 - VALUE: 2882867518
UNIXTIMESTAMP: 1421488202 - VALUE: 3058331663
UNIXTIMESTAMP: 1421488501 - VALUE: 3237064639
UNIXTIMESTAMP: 1421488801 - VALUE: 3424502252
UNIXTIMESTAMP: 1421489101 - VALUE: 3610244468
UNIXTIMESTAMP: 1421489401 - VALUE: 3793405766
UNIXTIMESTAMP: 1421489701 - VALUE: 3976739496
UNIXTIMESTAMP: 1421490001 - VALUE: 4157790682
UNIXTIMESTAMP: 1421490301 - VALUE: 56957366
UNIXTIMESTAMP: 1421490601 - VALUE: 281365154
UNIXTIMESTAMP: 1421490902 - VALUE: 541138427
UNIXTIMESTAMP: 1421491202 - VALUE: 775899755
UNIXTIMESTAMP: 1421491501 - VALUE: 969448849
UNIXTIMESTAMP: 1421491801 - VALUE: 1165840242
UNIXTIMESTAMP: 1421492101 - VALUE: 1346287570
UNIXTIMESTAMP: 1421492401 - VALUE: 1532634307
UNIXTIMESTAMP: 1421492701 - VALUE: 1726925850
UNIXTIMESTAMP: 1421493001 - VALUE: 1935266997
UNIXTIMESTAMP: 1421493301 - VALUE: 2132479236
UNIXTIMESTAMP: 1421493601 - VALUE: 2418598555
UNIXTIMESTAMP: 1421493901 - VALUE: 2668012842
UNIXTIMESTAMP: 1421494201 - VALUE: 2958853623
UNIXTIMESTAMP: 1421494501 - VALUE: 3265133479
UNIXTIMESTAMP: 1421494801 - VALUE: 3558062074
UNIXTIMESTAMP: 1421495102 - VALUE: 3829675920
UNIXTIMESTAMP: 1421495401 - VALUE: 4084555672
UNIXTIMESTAMP: 1421495701 - VALUE: 78633730
UNIXTIMESTAMP: 1421496001 - VALUE: 382331566
UNIXTIMESTAMP: 1421496301 - VALUE: 657710825
UNIXTIMESTAMP: 1421496601 - VALUE: 941660841
UNIXTIMESTAMP: 1421496901 - VALUE: 1213210320
UNIXTIMESTAMP: 1421497201 - VALUE: 1475879261
UNIXTIMESTAMP: 1421497501 - VALUE: 1743942697
UNIXTIMESTAMP: 1421497801 - VALUE: 2003987636
UNIXTIMESTAMP: 1421498102 - VALUE: 2289107091
UNIXTIMESTAMP: 1421498401 - VALUE: 2626095136
UNIXTIMESTAMP: 1421498701 - VALUE: 2941401863
UNIXTIMESTAMP: 1421499001 - VALUE: 3296357481
UNIXTIMESTAMP: 1421499301 - VALUE: 3680401747
UNIXTIMESTAMP: 1421499601 - VALUE: 15281329
UNIXTIMESTAMP: 1421499901 - VALUE: 1004388863
UNIXTIMESTAMP: 1421500201 - VALUE: 1974741676
UNIXTIMESTAMP: 1421500503 - VALUE: 2423377515
UNIXTIMESTAMP: 1421500801 - VALUE: 3232744005
UNIXTIMESTAMP: 1421501101 - VALUE: 4202117490
UNIXTIMESTAMP: 1421501401 - VALUE: 795603226
UNIXTIMESTAMP: 1421501701 - VALUE: 1119767570
UNIXTIMESTAMP: 1421502001 - VALUE: 1417586215
UNIXTIMESTAMP: 1421502301 - VALUE: 1750636875
UNIXTIMESTAMP: 1421502601 - VALUE: 2139728168
UNIXTIMESTAMP: 1421502901 - VALUE: 2470713359
UNIXTIMESTAMP: 1421503201 - VALUE: 2922428132
UNIXTIMESTAMP: 1421503502 - VALUE: 3335567528
UNIXTIMESTAMP: 1421503801 - VALUE: 3785892189
UNIXTIMESTAMP: 1421504101 - VALUE: 4228676311
UNIXTIMESTAMP: 1421504401 - VALUE: 331388945
UNIXTIMESTAMP: 1421504701 - VALUE: 764924219
UNIXTIMESTAMP: 1421505002 - VALUE: 1204256800
UNIXTIMESTAMP: 1421505301 - VALUE: 1717595824
UNIXTIMESTAMP: 1421505602 - VALUE: 2174414145
UNIXTIMESTAMP: 1421505901 - VALUE: 2634345504
UNIXTIMESTAMP: 1421506201 - VALUE: 3024961984
UNIXTIMESTAMP: 1421506501 - VALUE: 3418545235
UNIXTIMESTAMP: 1421506802 - VALUE: 3870011170
UNIXTIMESTAMP: 1421507101 - VALUE: 121419749
UNIXTIMESTAMP: 1421507401 - VALUE: 415119114
UNIXTIMESTAMP: 1421507701 - VALUE: 860254523
UNIXTIMESTAMP: 1421508001 - VALUE: 1253701591
UNIXTIMESTAMP: 1421508301 - VALUE: 1623451936
UNIXTIMESTAMP: 1421508601 - VALUE: 2099075694
UNIXTIMESTAMP: 1421508901 - VALUE: 2489394523
UNIXTIMESTAMP: 1421509201 - VALUE: 2773178955
UNIXTIMESTAMP: 1421509501 - VALUE: 3025765226
UNIXTIMESTAMP: 1421509802 - VALUE: 3169789154
UNIXTIMESTAMP: 1421510101 - VALUE: 3293893656
UNIXTIMESTAMP: 1421510401 - VALUE: 3501327040
UNIXTIMESTAMP: 1421510701 - VALUE: 3616569085
UNIXTIMESTAMP: 1421511001 - VALUE: 3763864086
UNIXTIMESTAMP: 1421511301 - VALUE: 3891109607
UNIXTIMESTAMP: 1421511601 - VALUE: 4059469680
UNIXTIMESTAMP: 1421511901 - VALUE: 4190154426
UNIXTIMESTAMP: 1421512201 - VALUE: 44752674
UNIXTIMESTAMP: 1421512501 - VALUE: 207039803
UNIXTIMESTAMP: 1421512801 - VALUE: 464080535
UNIXTIMESTAMP: 1421513101 - VALUE: 733679564
UNIXTIMESTAMP: 1421513401 - VALUE: 1138309604
UNIXTIMESTAMP: 1421513701 - VALUE: 1549205422
UNIXTIMESTAMP: 1421514001 - VALUE: 1877765262
UNIXTIMESTAMP: 1421514302 - VALUE: 2244994976
UNIXTIMESTAMP: 1421514601 - VALUE: 2528873289
UNIXTIMESTAMP: 1421514901 - VALUE: 2871665733
UNIXTIMESTAMP: 1421515201 - VALUE: 3196772650
UNIXTIMESTAMP: 1421515501 - VALUE: 3519659879
UNIXTIMESTAMP: 1421515801 - VALUE: 3803297056
UNIXTIMESTAMP: 1421516101 - VALUE: 4274859249
UNIXTIMESTAMP: 1421516401 - VALUE: 454189140
UNIXTIMESTAMP: 1421516701 - VALUE: 854902646
UNIXTIMESTAMP: 1421517001 - VALUE: 1268136408
Could it be the difference of 1 to 3 seconds in the unixtimestamp field
value which fill it with zeros in the graph?.
Thank in advance.
I hope you can help solve this.
Guillermo Nardoni
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.oetiker.ch/pipermail/rrd-users/attachments/20150117/9fdc1b2e/attachment-0001.html>
More information about the rrd-users
mailing list