<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">Hello,<br>
<br>
</div>
<blockquote
cite="mid:1372858516.12238.28.camel@cph-drift2.eur.adobe.com"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-1">
<meta name="GENERATOR" content="GtkHTML/4.4.4">
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
cite="mid:1372858516.12238.28.camel@cph-drift2.eur.adobe.com"
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 class="moz-txt-link-freetext" 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><b><br>
</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
cite="mid:1372858516.12238.28.camel@cph-drift2.eur.adobe.com"
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 width="100%" cellpadding="0" cellspacing="0">
<tbody>
<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>
</tbody>
</table>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
rrd-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:rrd-users@lists.oetiker.ch">rrd-users@lists.oetiker.ch</a>
<a class="moz-txt-link-freetext" 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<br>
</body>
</html>