Graphing total traffic...not working on daily graph

Richard Burton <[email protected]> Mon, 30 Oct 2017 09:58:37 +0000
Newsgroups gmane.comp.db.rrdtool.user
Message-ID <B302D430D79CB14781826D8AFDFB17A6BB0BBEE2@BARTLEBY.intra.atomwide.com>
--===============8200321612764046468==
Content-Language: en-US
Content-Type: multipart/alternative;
	boundary="_000_B302D430D79CB14781826D8AFDFB17A6BB0BBEE2BARTLEBYintraat_"

--_000_B302D430D79CB14781826D8AFDFB17A6BB0BBEE2BARTLEBYintraat_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi there

I have any issue with creating a graph definition for total amounts of data=
 over a given period for a network interface.

I have followed Tobi's advice on this stackoverflow page

https://stackoverflow.com/questions/31812055/how-do-i-create-accumulated-ba=
ndwidth-usages-in-rrdtool-ie-gbs-per-month-down

however the issue I have is that when I view the graph for a daily time per=
iod the amount of data reported is too low but when I view at higher resolu=
tions, for example a 20 minute interval the graph is correct.

I have a test box downloading a 1MB file every minute.

So I would expect 1440MB in a day at least but the graph on the daily view =
is only getting to around 600MB.

The output of an rrdtool info command is

filename =3D "1-172.31.10.154-ifInOctets_2_60.rrd"
rrd_version =3D "0003"
step =3D 60
last_update =3D 1509008361
header_size =3D 1624
ds[ifInOctets].index =3D 0
ds[ifInOctets].type =3D "COUNTER"
ds[ifInOctets].minimal_heartbeat =3D 60
ds[ifInOctets].min =3D 0.0000000000e+00
ds[ifInOctets].max =3D NaN
ds[ifInOctets].last_ds =3D "1874997951"
ds[ifInOctets].value =3D 4.5357725000e+05
ds[ifInOctets].unknown_sec =3D 0
rra[0].cf =3D "AVERAGE"
rra[0].rows =3D 129600
rra[0].cur_row =3D 47102
rra[0].pdp_per_row =3D 1
rra[0].xff =3D 5.0000000000e-01
rra[0].cdp_prep[0].value =3D NaN
rra[0].cdp_prep[0].unknown_datapoints =3D 0
rra[1].cf =3D "AVERAGE"
rra[1].rows =3D 38880
rra[1].cur_row =3D 30630
rra[1].pdp_per_row =3D 10
rra[1].xff =3D 5.0000000000e-01
rra[1].cdp_prep[0].value =3D 1.9536071167e+05
rra[1].cdp_prep[0].unknown_datapoints =3D 0
rra[2].cf =3D "AVERAGE"
rra[2].rows =3D 52560
rra[2].cur_row =3D 35410
rra[2].pdp_per_row =3D 30
rra[2].xff =3D 5.0000000000e-01
rra[2].cdp_prep[0].value =3D 6.2954044167e+05
rra[2].cdp_prep[0].unknown_datapoints =3D 0
rra[3].cf =3D "MAX"
rra[3].rows =3D 129600
rra[3].cur_row =3D 47102
rra[3].pdp_per_row =3D 1
rra[3].xff =3D 5.0000000000e-01
rra[3].cdp_prep[0].value =3D NaN
rra[3].cdp_prep[0].unknown_datapoints =3D 0
rra[4].cf =3D "MAX"
rra[4].rows =3D 38880
rra[4].cur_row =3D 30630
rra[4].pdp_per_row =3D 10
rra[4].xff =3D 5.0000000000e-01
rra[4].cdp_prep[0].value =3D 2.1791705000e+04
rra[4].cdp_prep[0].unknown_datapoints =3D 0
rra[5].cf =3D "MAX"
rra[5].rows =3D 52560
rra[5].cur_row =3D 35410
rra[5].pdp_per_row =3D 30
rra[5].xff =3D 5.0000000000e-01
rra[5].cdp_prep[0].value =3D 2.1791705000e+04
rra[5].cdp_prep[0].unknown_datapoints =3D 0


So for my CDEF I'm using 60 as the step.

My graph definition is

"DEF:inOctAve=3D$in_bytes:ifInOctets:AVERAGE",
"DEF:outOctAve=3D$out_bytes:ifOutOctets:AVERAGE",
"CDEF:outOctT=3DoutOctAve,60,*,PREV,ADDNAN",
"CDEF:outOctTMB=3DoutOctT,1000000,/",
"CDEF:inOctT=3DinOctAve,60,*,PREV,ADDNAN",
"CDEF:inOctTMB=3DinOctT,1000000,/",
"LINE1:outOctTMB$COLOURS[0]:Total Outgoing (MB)\\l<file:///\\l>",
"LINE1:inOctTMB$COLOURS[1]:Total Incoming (MB)\\l<file:///\\l>",
"COMMENT:\\l",
"COMMENT:\\s",
"GPRINT:outOctTMB:LAST:Total Outgoing\\: %0.1lf (MB)\\l<file:///\\l>",
"GPRINT:inOctTMB:LAST:Total Incoming\\: %0.1lf (MB)\\l<file:///\\l>",


Any help much appreciated.

Thanks

Richard


--_000_B302D430D79CB14781826D8AFDFB17A6BB0BBEE2BARTLEBYintraat_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;
	mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:#0563C1;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:#954F72;
	text-decoration:underline;}
span.EmailStyle17
	{mso-style-type:personal;
	font-family:"Calibri",sans-serif;
	color:windowtext;}
span.EmailStyle18
	{mso-style-type:personal-reply;
	font-family:"Calibri",sans-serif;
	color:#1F497D;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-size:10.0pt;}
@page WordSection1
	{size:612.0pt 792.0pt;
	margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3D"EN-GB" link=3D"#0563C1" vlink=3D"#954F72">
<div class=3D"WordSection1">
<p class=3D"MsoNormal">Hi there<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">I have any issue with creating a graph definition fo=
r total amounts of data over a given period for a network interface.<o:p></=
o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">I have followed Tobi&#8217;s advice on this stackove=
rflow page<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal"><a href=3D"https://stackoverflow.com/questions/31812=
055/how-do-i-create-accumulated-bandwidth-usages-in-rrdtool-ie-gbs-per-mont=
h-down">https://stackoverflow.com/questions/31812055/how-do-i-create-accumu=
lated-bandwidth-usages-in-rrdtool-ie-gbs-per-month-down</a><o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">however the issue I have is that when I view the gra=
ph for a daily time period the amount of data reported is too low but when =
I view at higher resolutions, for example a 20 minute interval the graph is=
 correct.<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">I have a test box downloading a 1MB file every minut=
e.<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">So I would expect 1440MB in a day at least but the g=
raph on the daily view is only getting to around 600MB.<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">The output of an rrdtool info command is<o:p></o:p><=
/p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">filename =3D &quot;1-172.31.10.154-ifInOctets_2_60.r=
rd&quot;<o:p></o:p></p>
<p class=3D"MsoNormal">rrd_version =3D &quot;0003&quot;<o:p></o:p></p>
<p class=3D"MsoNormal">step =3D 60<o:p></o:p></p>
<p class=3D"MsoNormal">last_update =3D 1509008361<o:p></o:p></p>
<p class=3D"MsoNormal">header_size =3D 1624<o:p></o:p></p>
<p class=3D"MsoNormal">ds[ifInOctets].index =3D 0<o:p></o:p></p>
<p class=3D"MsoNormal">ds[ifInOctets].type =3D &quot;COUNTER&quot;<o:p></o:=
p></p>
<p class=3D"MsoNormal">ds[ifInOctets].minimal_heartbeat =3D 60<o:p></o:p></=
p>
<p class=3D"MsoNormal">ds[ifInOctets].min =3D 0.0000000000e&#43;00<o:p></o:=
p></p>
<p class=3D"MsoNormal">ds[ifInOctets].max =3D NaN<o:p></o:p></p>
<p class=3D"MsoNormal">ds[ifInOctets].last_ds =3D &quot;1874997951&quot;<o:=
p></o:p></p>
<p class=3D"MsoNormal">ds[ifInOctets].value =3D 4.5357725000e&#43;05<o:p></=
o:p></p>
<p class=3D"MsoNormal">ds[ifInOctets].unknown_sec =3D 0<o:p></o:p></p>
<p class=3D"MsoNormal">rra[0].cf =3D &quot;AVERAGE&quot;<o:p></o:p></p>
<p class=3D"MsoNormal">rra[0].rows =3D 129600<o:p></o:p></p>
<p class=3D"MsoNormal">rra[0].cur_row =3D 47102<o:p></o:p></p>
<p class=3D"MsoNormal">rra[0].pdp_per_row =3D 1<o:p></o:p></p>
<p class=3D"MsoNormal">rra[0].xff =3D 5.0000000000e-01<o:p></o:p></p>
<p class=3D"MsoNormal">rra[0].cdp_prep[0].value =3D NaN<o:p></o:p></p>
<p class=3D"MsoNormal">rra[0].cdp_prep[0].unknown_datapoints =3D 0<o:p></o:=
p></p>
<p class=3D"MsoNormal">rra[1].cf =3D &quot;AVERAGE&quot;<o:p></o:p></p>
<p class=3D"MsoNormal">rra[1].rows =3D 38880<o:p></o:p></p>
<p class=3D"MsoNormal">rra[1].cur_row =3D 30630<o:p></o:p></p>
<p class=3D"MsoNormal">rra[1].pdp_per_row =3D 10<o:p></o:p></p>
<p class=3D"MsoNormal">rra[1].xff =3D 5.0000000000e-01<o:p></o:p></p>
<p class=3D"MsoNormal">rra[1].cdp_prep[0].value =3D 1.9536071167e&#43;05<o:=
p></o:p></p>
<p class=3D"MsoNormal">rra[1].cdp_prep[0].unknown_datapoints =3D 0<o:p></o:=
p></p>
<p class=3D"MsoNormal">rra[2].cf =3D &quot;AVERAGE&quot;<o:p></o:p></p>
<p class=3D"MsoNormal">rra[2].rows =3D 52560<o:p></o:p></p>
<p class=3D"MsoNormal">rra[2].cur_row =3D 35410<o:p></o:p></p>
<p class=3D"MsoNormal">rra[2].pdp_per_row =3D 30<o:p></o:p></p>
<p class=3D"MsoNormal">rra[2].xff =3D 5.0000000000e-01<o:p></o:p></p>
<p class=3D"MsoNormal">rra[2].cdp_prep[0].value =3D 6.2954044167e&#43;05<o:=
p></o:p></p>
<p class=3D"MsoNormal">rra[2].cdp_prep[0].unknown_datapoints =3D 0<o:p></o:=
p></p>
<p class=3D"MsoNormal">rra[3].cf =3D &quot;MAX&quot;<o:p></o:p></p>
<p class=3D"MsoNormal">rra[3].rows =3D 129600<o:p></o:p></p>
<p class=3D"MsoNormal">rra[3].cur_row =3D 47102<o:p></o:p></p>
<p class=3D"MsoNormal">rra[3].pdp_per_row =3D 1<o:p></o:p></p>
<p class=3D"MsoNormal">rra[3].xff =3D 5.0000000000e-01<o:p></o:p></p>
<p class=3D"MsoNormal">rra[3].cdp_prep[0].value =3D NaN<o:p></o:p></p>
<p class=3D"MsoNormal">rra[3].cdp_prep[0].unknown_datapoints =3D 0<o:p></o:=
p></p>
<p class=3D"MsoNormal">rra[4].cf =3D &quot;MAX&quot;<o:p></o:p></p>
<p class=3D"MsoNormal">rra[4].rows =3D 38880<o:p></o:p></p>
<p class=3D"MsoNormal">rra[4].cur_row =3D 30630<o:p></o:p></p>
<p class=3D"MsoNormal">rra[4].pdp_per_row =3D 10<o:p></o:p></p>
<p class=3D"MsoNormal">rra[4].xff =3D 5.0000000000e-01<o:p></o:p></p>
<p class=3D"MsoNormal">rra[4].cdp_prep[0].value =3D 2.1791705000e&#43;04<o:=
p></o:p></p>
<p class=3D"MsoNormal">rra[4].cdp_prep[0].unknown_datapoints =3D 0<o:p></o:=
p></p>
<p class=3D"MsoNormal">rra[5].cf =3D &quot;MAX&quot;<o:p></o:p></p>
<p class=3D"MsoNormal">rra[5].rows =3D 52560<o:p></o:p></p>
<p class=3D"MsoNormal">rra[5].cur_row =3D 35410<o:p></o:p></p>
<p class=3D"MsoNormal">rra[5].pdp_per_row =3D 30<o:p></o:p></p>
<p class=3D"MsoNormal">rra[5].xff =3D 5.0000000000e-01<o:p></o:p></p>
<p class=3D"MsoNormal">rra[5].cdp_prep[0].value =3D 2.1791705000e&#43;04<o:=
p></o:p></p>
<p class=3D"MsoNormal">rra[5].cdp_prep[0].unknown_datapoints =3D 0<o:p></o:=
p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">So for my CDEF I&#8217;m using 60 as the step.<o:p><=
/o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">My graph definition is<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">&quot;DEF:inOctAve=3D$in_bytes:ifInOctets:AVERAGE&qu=
ot;,<o:p></o:p></p>
<p class=3D"MsoNormal">&quot;DEF:outOctAve=3D$out_bytes:ifOutOctets:AVERAGE=
&quot;,<o:p></o:p></p>
<p class=3D"MsoNormal">&quot;CDEF:outOctT=3DoutOctAve,60,*,PREV,ADDNAN&quot=
;,<o:p></o:p></p>
<p class=3D"MsoNormal">&quot;CDEF:outOctTMB=3DoutOctT,1000000,/&quot;,<o:p>=
</o:p></p>
<p class=3D"MsoNormal">&quot;CDEF:inOctT=3DinOctAve,60,*,PREV,ADDNAN&quot;,=
<o:p></o:p></p>
<p class=3D"MsoNormal">&quot;CDEF:inOctTMB=3DinOctT,1000000,/&quot;,<o:p></=
o:p></p>
<p class=3D"MsoNormal">&quot;LINE1:outOctTMB$COLOURS[0]:Total Outgoing (MB)=
<a href=3D"file:///\\l">\\l</a>&quot;,<o:p></o:p></p>
<p class=3D"MsoNormal">&quot;LINE1:inOctTMB$COLOURS[1]:Total Incoming (MB)<=
a href=3D"file:///\\l">\\l</a>&quot;,<o:p></o:p></p>
<p class=3D"MsoNormal">&quot;COMMENT:\\l&quot;,<o:p></o:p></p>
<p class=3D"MsoNormal">&quot;COMMENT:\\s&quot;,<o:p></o:p></p>
<p class=3D"MsoNormal">&quot;GPRINT:outOctTMB:LAST:Total Outgoing\\: %0.1lf=
 (MB)<a href=3D"file:///\\l">\\l</a>&quot;,<o:p></o:p></p>
<p class=3D"MsoNormal">&quot;GPRINT:inOctTMB:LAST:Total Incoming\\: %0.1lf =
(MB)<a href=3D"file:///\\l">\\l</a>&quot;,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">Any help much appreciated.<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">Thanks<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">Richard<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
</body>
</html>

--_000_B302D430D79CB14781826D8AFDFB17A6BB0BBEE2BARTLEBYintraat_--


--===============8200321612764046468==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
rrd-users mailing list
[email protected]
https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users

--===============8200321612764046468==--