<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/4.4.4">
</HEAD>
<BODY TEXT="#000000" BGCOLOR="#ffffff">
Great!<BR>
<BR>
just using the reduce=MAX|MIN to change the default AVERAGE-behavior I have in my RRD was exactly what I was looking for.<BR>
For fluctuating data this makes a huge difference.<BR>
<BR>
Thanks a lot.<BR>
<BR>
/Johan<BR>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
-- <BR>
<FONT SIZE="2"><FONT COLOR="#000080"> </FONT></FONT> <BR>
<B><FONT SIZE="2">Johan Elmerfjord</FONT></B> <FONT SIZE="1">| Sr. Systems Administration/Mgr, EMEA | Adobe Systems, Product Technical Operations | p. +45 3231 6008 | x86008 | cell. +46 735 101 444 | Jelmerfj@adobe.com</FONT> <BR>
<BR>
</TD>
</TR>
</TABLE>
On Wed, 2013-07-03 at 10:18 -0700, Yannick Marquet wrote:
<BLOCKQUOTE TYPE=CITE>
Hello,<BR>
<BR>
<BR>
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
<BLOCKQUOTE TYPE=CITE>
Hi RRD-users,<BR>
<BR>
I have RRD-files with 5 years of data captured every 5 minute.<BR>
1 DataSource per file that is defined as AVERAGE , and I have no consolidation of the data.<BR>
We want to be able to go back and look at the full resolution at any time.<BR>
</BLOCKQUOTE>
<BR>
So juste one RRA needed.<BR>
<BLOCKQUOTE TYPE=CITE>
We update around 800k RRD-files on a single server every 5 minutes.<BR>
<BR>
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).<BR>
</BLOCKQUOTE>
rrdtool export may be a solution (for consolidate data "on the fly"). But you want to calculate how much rows needed for param "--maxrow"<BR>
<BR>
<PRE>
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 : <A HREF="http://oss.oetiker.ch/rrdtool/doc/rrdgraph_data.en.html">http://oss.oetiker.ch/rrdtool/doc/rrdgraph_data.en.html</A>)
</PRE>
You can param step in DEF for exporting data.<BR>
<BR>
<PRE>
DEF:ds0b=/home/rrdtool/data/router1.rrd:ds0:AVERAGE:step=1800
</PRE>
For max/min you can use "reduce" parameter data to change how data is reduce :<BR>
<BR>
DEF<B>:</B><I><vname></I>=<I><rrdfile></I>:<I><ds-name></I>:<I><CF></I>[:step=<I><step></I>][:start=<I><time></I>][:end=<I><time></I>]<B>[:reduce=</B><B><I><CF></I></B><B>]</B>
<PRE>
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
</PRE>
<BLOCKQUOTE TYPE=CITE>
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.<BR>
How can I use these functions when exporting (and graphing) data.<BR>
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.<BR>
<BR>
I have searched and searched, and made many unsuccessful tries with different VDEF, CDEF combinations - but no luck.<BR>
<BR>
Any ideas?<BR>
<BR>
/Johan<BR>
<BR>
<BR>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
-- <BR>
<FONT SIZE="2"><FONT COLOR="#000080"> </FONT></FONT> <BR>
<B><FONT SIZE="2">Johan Elmerfjord</FONT></B> <FONT SIZE="1">| Sr. Systems Administration/Mgr, EMEA | Adobe Systems, Product Technical Operations </FONT>
</TD>
</TR>
</TABLE>
<BR>
<BR>
<PRE>
_______________________________________________
rrd-users mailing list
<A HREF="mailto:rrd-users@lists.oetiker.ch">rrd-users@lists.oetiker.ch</A>
<A HREF="https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users">https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users</A>
</PRE>
</BLOCKQUOTE>
Dears,<BR>
<BR>
Yannick
</BLOCKQUOTE>
</BODY>
</HTML>