spock <[email protected]> wrote: > I am using this database to collect temperature data for a swimming pool. > I want to keep the detailed data for 36 months ("103680 * 900sec") but also > want to have a daily average temp (96 values = 24h). > > # rrdtool create temp_pool.rrd --step 900 --start "20140101 00:00" \ > # DS:air:GAUGE:1200:-40:50 \ > # DS:flow:GAUGE:1200:-40:50 \ > # DS:return:GAUGE:1200:-40:50 \ > # DS:delta:COMPUTE:return,flow,- \ > # DS:pump_flag:GAUGE:1200:0:1 \ > # DS:heat_flag:GAUGE:1200:0:1 \ > # DS:device:GAUGE:1200:0:90 > # RRA:AVERAGE:0.5:1:103680 \ > # RRA:MIN:0.5:96:3650 \ > # RRA:MAX:0.5:96:3650 \ > # RRA:AVERAGE:0.5:96:3650 > > When I create a graph with > rrdtool graph temp7d.png \ > -t "Pooltemp (Status $(date "+%d.%m.%Y %H:%M"))" \ > -s $graph_start_7d -e $timestamp_rounded_unix \ > -w 640 -h 400 -D -a PNG -T 15\ > DEF:airmax2=temp_pool.rrd:air:MAX \ > DEF:airmin2=temp_pool.rrd:air:MIN \ > DEF:airavg2=temp_pool.rrd:air:AVERAGE \ > CDEF:airrange=airmax2,airmin2,- \ > LINE2:airmin2#00FF00:"Luft Min" \ > AREA:airrange#8dadf588::STACK \ > LINE2:airmax2#00FF00:"Luft Min" \ > LINE2:airavg2#00FF00:Aussen > > I get for airavg2 the datailed values - but not the daily average. > Airmin2 and airmax2 work as expected - there is no other RRA Archive to > choose from. > > Question (1) > How do I convince the tool to use the consolidated data instead of the > detailed?
It does the best it can to use the most detailed data. Looking at the docs, I don't see any option to override that. > Question (2) > When drawing the graph, the line for max/min values are not precisely > aligned above a day. It looks like it starts about 900 secs after 0:00 each > day. Looks more like an hour to me, are you on +1 timezone by any chance ? > How does rrdtool determine, which 96 values to consolidate? My data point > are stored with rounded timestamps (e.g. 13.06.2014 0:00, 0:15, 0:30, etc.) *ALL* periods are aligned to an integer multiple of step (or step * steps/CDP) since unix epoch (midnight 1-1-1970 UTC). So if you consolidate to a day then a "day" will always start at 00:00:00 UTC. If your timezone isn't UTC, then the data will appear to be off by your timezone offset. > Question (3) > The ssf factor is 0.5 for the RRAs. However, there is no min/max value for > certain days with missing data, although there are only a few values > missing. I am sure, is is not more than 50%. How can I check this. > > <http://rrd-mailinglists.937164.n2.nabble.com/file/n7582214/temp7d.png> Are you certain you are updating frequently enough ? I can see some gaps in the data, if you have more than 1200s between updates then you'll have gaps. For more on how consolidation is done, see this tutorial http://www.vandenbogaerdt.nl/rrdtool/process.php _______________________________________________ rrd-users mailing list [email protected] https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
