[rrd-users] Getting Max/Min values from Average RRDs?

[Johan Elmerfjord]

Great!

just using the reduce=MAX|MIN to change the default AVERAGE-behavior I
have in my RRD was exactly what I was looking for.
For fluctuating data this makes a huge difference.

Thanks a lot.

/Johan
-- 
  
Johan Elmerfjord | Sr. Systems Administration/Mgr, EMEA | Adobe Systems,
Product Technical Operations | p. +45 3231 6008 | x86008 | cell. +46 735
101 444 | Jelmerfj at adobe.com 

On Wed, 2013-07-03 at 10:18 -0700, Yannick Marquet wrote:
> Hello,
> 
> 
> > 
> > Hi RRD-users,
> > 
> > I have RRD-files with 5 years of data captured every 5 minute.
> > 1 DataSource per file that is defined as AVERAGE , and I have no
> > consolidation of the data.
> > We want to be able to go back and look at the full resolution at any
> > time.
> 
> 
> So juste one RRA needed.
> 
> > We update around 800k RRD-files on a single server every 5 minutes.
> > 
> > I want to export the data with some consolidation - say daily,
> > weekly, monthly average numbers and want to be able to show the
> > maximum and minimum I had during that consolidated time-slot. (not
> > the total max/min of the final consolidated values).
> 
> rrdtool export may be a solution (for consolidate data "on the fly").
> But you want to calculate how much rows needed for param "--maxrow"
> 
> 
> this solution works for rrdtool graph, but i don't try with rrdtool export 
> (maybe documentation is outdated, this syntax can be found only here : http://oss.oetiker.ch/rrdtool/doc/rrdgraph_data.en.html) 
> 
> You can param step in DEF for exporting data.
> 
> 
> DEF:ds0b=/home/rrdtool/data/router1.rrd:ds0:AVERAGE:step=1800
> 
> For max/min  you can use "reduce" parameter data to change how data is
> reduce :
> 
> DEF:<vname>=<rrdfile>:<ds-name>:<CF>[:step=<step>][:start=<time>][:end=<time>][:reduce=<CF>]
> 
> ex : 
> DEF:ds0bdailymax=/home/rrdtool/data/router1.rrd:ds0:AVERAGE:step=86400:reduce=MAX
> DEF:ds0bdailymin=/home/rrdtool/data/router1.rrd:ds0:AVERAGE:step=86400:reduce=MIN
> DEF:ds0bdailyavg=/home/rrdtool/data/router1.rrd:ds0:AVERAGE:step=86400
> 
> DEF:ds0b30daymax=/home/rrdtool/data/router1.rrd:ds0:AVERAGE:step=2592000:reduce=MAX
> DEF:ds0b30dayymin=/home/rrdtool/data/router1.rrd:ds0:AVERAGE:step=2592000:reduce=MIN
> DEF:ds0b30dayavg=/home/rrdtool/data/router1.rrd:ds0:AVERAGE:step=2592000
> 
> DEF:ds0b365daymax=/home/rrdtool/data/router1.rrd:ds0:AVERAGE:step=31536000:reduce=MAX
> DEF:ds0b365daymin=/home/rrdtool/data/router1.rrd:ds0:AVERAGE:step=31536000:reduce=MIN
> DEF:ds0b365dayavg=/home/rrdtool/data/router1.rrd:ds0:AVERAGE:step=31536000
> 
> 
> 
> > I can implement this externally using fetch - and then do the
> > max/min calculations in each bucket, but I assume that this is the
> > same thing that RRD-tool do internally whenever consolidated DS are
> > updated.
> > How can I use these functions when exporting (and graphing) data.
> > When graphing data the consolidation-slots are calculated based on
> > the data-points and available graph-resolution, so it would be nice
> > to just say give me the max and min as an value-array just like in a
> > CDEF.
> > 
> > I have searched and searched, and made many unsuccessful tries with
> > different VDEF, CDEF combinations - but no luck.
> > 
> > Any ideas?
> > 
> > /Johan
> > 
> > 
> > -- 
> >   
> > Johan Elmerfjord | Sr. Systems Administration/Mgr, EMEA | Adobe
> > Systems, Product Technical Operations 
> > 
> > 
> > 
> > _______________________________________________
> > rrd-users mailing list
> > rrd-users at lists.oetiker.ch
> > https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
> 
> Dears,
> 
> Yannick
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.oetiker.ch/pipermail/rrd-users/attachments/20130704/32c2ee03/attachment-0001.htm