Make 15min averages graph from 1 min data?

[Dwayne_Dibbley]

I currently poll each device every 1 minute and also graph these and 1 minute intervals for hourly daily monthly yearly.

Is it possible to create a new graph off the existing data to display 15 minute averages?

So that 1 day would have 96 plots with the average value for that 15 minute period

Thanks

[Dwayne_Dibbley]

Could i apply a CDEF simular to the Make 5 Minutes ie instead of 300 make it 900. Only thing is when i apply this to the traffic graph inbound area item all i then get is a Green graph. It looks like it has just multiplied the data by 900 and not the time window?

[gandalf]

I'm not aware of a method that fits to your needs. But you may try to use the TREND function cdef=CURRENT_DATA_SOURCE,900,TREND
Reinhard

[Dwayne_Dibbley]

I have created an Hourly(15 minute) RRA with

AVERAGE
0.5
15
525600
3600

a New Data Template using the above RRA.

And a new graph template

I have tried to make a new graph, te RRA is created but i am unable to get the graph drawn? ( no png)

[gandalf]

I would need the utput of "rrdtool info" for that particular rrd file and the DEBUG output from Graph Management for the respective graph
Reinhard

[Dwayne_Dibbley]

Here you go many thanks ( poller runs an 1 min intervals )

Code: Select all

filename = "E:\Inetpub\wwwroot\cacti\rra\eagle_1_6513_traffic_out_84.rrd"
rrd_version = "0003"
step = 900
last_update = 1165314841
ds[traffic_in].type = "COUNTER"
ds[traffic_in].minimal_heartbeat = 120
ds[traffic_in].min = 0.0000000000e+00
ds[traffic_in].max = 1.0000000000e+08
ds[traffic_in].last_ds = "3773668621"
ds[traffic_in].value = 4.8647544150e+08
ds[traffic_in].unknown_sec = 0
ds[traffic_out].type = "COUNTER"
ds[traffic_out].minimal_heartbeat = 600
ds[traffic_out].min = 0.0000000000e+00
ds[traffic_out].max = 1.0000000000e+08
ds[traffic_out].last_ds = "763114570"
ds[traffic_out].value = 1.0805376448e+10
ds[traffic_out].unknown_sec = 0
rra[0].cf = "AVERAGE"
rra[0].rows = 35040
rra[0].pdp_per_row = 15
rra[0].xff = 5.0000000000e-01
rra[0].cdp_prep[0].value = 8.1643937085e+06
rra[0].cdp_prep[0].unknown_datapoints = 5
rra[0].cdp_prep[1].value = 1.6315667624e+08
rra[0].cdp_prep[1].unknown_datapoints = 5


RRDTool Command:

e:/rrdtool/rrdtool.exe graph - \
--imgformat=PNG \
--start=-86400 \
--end=-900 \
--title="Eagle_1_6513 - Traffic - ***Port-Channel (Vtesse) to DR_1_6513***" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--upper-limit=2000000000 \
--lower-limit=0 \
--vertical-label="bits per second" \
--slope-mode \
DEF:a="e\:/Inetpub/wwwroot/cacti/rra/eagle_1_6513_traffic_out_84.rrd":traffic_in:AVERAGE \
DEF:b="e\:/Inetpub/wwwroot/cacti/rra/eagle_1_6513_traffic_out_84.rrd":traffic_out:AVERAGE \
CDEF:cdefa=a,8,* \
CDEF:cdefe=b,8,* \
AREA:cdefa#00CF00:"Inbound"  \
GPRINT:cdefa:LAST:" Current\:%8.2lf %s"  \
GPRINT:cdefa:AVERAGE:"Average\:%8.2lf %s"  \
GPRINT:cdefa:MAX:"Maximum\:%8.2lf %s\n"  \
LINE1:cdefe#002A97:"Outbound"  \
GPRINT:cdefe:LAST:"Current\:%8.2lf %s"  \
GPRINT:cdefe:AVERAGE:"Average\:%8.2lf %s"  \
GPRINT:cdefe:MAX:"Maximum\:%8.2lf %s" 
RRDTool Says:

OK

[gandalf]

What rrdtool version are you running (rrdtool -v)? And please post a screenshot of the failing graph
Reinhard

[Dwayne_Dibbley]

OK i am getting somewhere. I have editied the Data templata for interface - traffic to set the step to 900 ( 15 minutes ), poller runs ever 1 minute and RRA's have steps of 1, so i am guessing that the RRA will store data at 1 minute intervals, but the graph will display the ( in this case AVERAGE ) for the 15 minute period with one plot. see attachment. IS it possible to GPRINT the count of over 60% spikes in this case 4?

Thanks

PS is the 900 step in the graph calculating every 15 minutes the data or adding up all the 15 polls in to one average ie :

poll1 = 100 - 1 min
poll2 = 200 - 2 min
poll3 = 100 - 3 min
poll4 = 300 - 4 min
poll5 = 300 - 5 min

would a step of 300 plot the two points as point 1, 100 and point 2, 300 or point 2, 100+200+100+300+300/5 (AVERAGE)

Ta

[gandalf]

OK i am getting somewhere. I have editied the Data templata for interface - traffic to set the step to 900 ( 15 minutes ), poller runs ever 1 minute and RRA's have steps of 1, so i am guessing that the RRA will store data at 1 minute intervals,

I'm afraid, but step is given in seconds. So you'll have to tweak your numbers a bit. Better post your question to the rrdtool-users mailinglist. Tobi Oetiker and Alex van den Bogaerdt are very accomplished is solving such problems
Reinhard