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 dont 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
_______________________________________________ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users