[rrd-users] Fetching raw data

--===============1074802254==
Content-Type: multipart/alternative;
boundary="----=_Part_4006_32803130.1206052874511"

------=_Part_4006_32803130.1206052874511
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi all,

What I'm trying to achieve with RRDTool is quite simple, and I believe
possible with RRD - I just need you guys to run your eyes over my case and
point out where my misunderstanding of your code is.

I have a time series, with samples each 1 minute. I want to store this in
an RRD, and retrieve consolidated values to facilitate a zoomable graph
front-end. This works a treat, but what I want to do as well as fetching
consolidated data from the RRD is to be able to pull that original data out
at full resolution too.

I figured that an RRA:AVERAGE with 1 step and a heartbeat of 60 secs would
do the trick as long as there were only ever 1 sample updated per 60 second
period. But I can't get this to work! I thought it might be the AVERAGE
function doing sneaky things, but LAST and MAX give exactly the same fetch
results.

*I'm creating the graph using:*
rrdtool create subset.rrd -b 1199103570 -s 60 DS:users:GAUGE:60:0:1000000
RRA:MAX:0.5:1:525600 RRA:LAST:0.9:1:525600 RRA:AVERAGE:0.9:1:525600

*Then updating with the following data:*
1199103601 50283
1199103661 50282
1199103721 50320
1199103781 50365
1199103841 50359
1199103906 50307
1199103961 50332
1199104021 50298
1199104081 50329
1199104141 50307
1199104202 50267

*Then the following fetches:*
rrdtool fetch subset.rrd AVERAGE -r60 -s1199103590 -e1199104202
rrdtool fetch subset.rrd LAST -r60 -s1199103590 -e1199104202
rrdtool fetch subset.rrd MAX -r60 -s1199103590 -e1199104202

*Produce:*
1199103600: 5.0283000000e+04
1199103660: 5.0282016667e+04
1199103720: 5.0319366667e+04
1199103780: 5.0364250000e+04
1199103840: 5.0359100000e+04
1199103900: nan
1199103960: 5.0332000000e+04
1199104020: 5.0298566667e+04
1199104080: 5.0328483333e+04
1199104140: 5.0307366667e+04
1199104200: nan
1199104260: nan

Clearly there is something going on here which I don't understand. Anyone
care to explain how I can get at the raw numbers?

On another issue, are there any plans for RRDTool supporting calendar
monthly consolidations, or is this best done using daily consolidations and
some scripts?

Many thanks,

Luke

------=_Part_4006_32803130.1206052874511
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi all,<br><br>What I'm trying to achieve with RRDTool is quite simple, and I believe possible with RRD - I just need you guys to run your eyes over my case and point out where my misunderstanding of your code is.<br><br>
I have a time series, with samples each 1 minute.&nbsp; I want to store this in an RRD, and retrieve consolidated values to facilitate a zoomable graph front-end.&nbsp; This works a treat, but what I want to do as well as fetching consolidated data from the RRD is to be able to pull that original data out at full resolution too.<br>
<br>I figured that an RRA:AVERAGE with 1 step and a heartbeat of 60 secs would do the trick as long as there were only ever 1 sample updated per 60 second period.&nbsp; But I can't get this to work!&nbsp; I thought it might be the AVERAGE function doing sneaky things, but LAST and MAX give exactly the same fetch results.<br>
<br><b>I'm creating the graph using:</b><br>rrdtool create subset.rrd -b 1199103570 -s 60 DS:users:GAUGE:60:0:1000000 RRA:MAX:0.5:1:525600 RRA:LAST:0.9:1:525600 RRA:AVERAGE:0.9:1:525600 <br><br><b>Then updating with the following data:</b><br>
1199103601&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50283<br>1199103661&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50282<br>1199103721&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50320<br>1199103781&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50365<br>1199103841&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50359<br>1199103906&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50307<br>1199103961&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50332<br>1199104021&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50298<br>1199104081&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50329<br>
1199104141&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50307<br>1199104202&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50267<br><br><b>Then the following fetches:</b><br>rrdtool fetch subset.rrd AVERAGE -r60 -s1199103590 -e1199104202<br>rrdtool fetch subset.rrd LAST -r60 -s1199103590 -e1199104202<br>
rrdtool fetch subset.rrd MAX -r60 -s1199103590 -e1199104202<br><br><b>Produce:</b><br>1199103600: 5.0283000000e+04<br>1199103660: 5.0282016667e+04<br>1199103720: 5.0319366667e+04<br>1199103780: 5.0364250000e+04<br>1199103840: 5.0359100000e+04<br>
1199103900: nan<br>1199103960: 5.0332000000e+04<br>1199104020: 5.0298566667e+04<br>1199104080: 5.0328483333e+04<br>1199104140: 5.0307366667e+04<br>1199104200: nan<br>1199104260: nan<br><br>Clearly there is something going on here which I don't understand.&nbsp; Anyone care to explain how I can get at the raw numbers?<br>
<br>On another issue, are there any plans for RRDTool supporting calendar monthly consolidations, or is this best done using daily consolidations and some scripts?<br><br>Many thanks,<br><br>Luke<br>

------=_Part_4006_32803130.1206052874511--


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

_______________________________________________
rrd-users mailing list
rrd-users@lists.oetiker.ch
https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users

--===============1074802254==--