[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
0.96test1 aggregation functions
- From: "E. Versaevel" <e.versaevel@xxxxxxxxxxx>
- Subject: 0.96test1 aggregation functions
- Date: Fri, 22 Aug 2008 15:05:09 +0200
Hello, First of all, thanks for you wonderful tool, it rocks :) I've just build some weathermaps of some parts of our network (in 0.95, works like a charm :D) and i'm playing around with the new aggragation functions in 0.96test1. Problem is that the values in the map don't match with my own calculated values, weathermap constructs the following rrd command: /usr/bin/rrdtool graph /dev/null -f '' --start now-1month --end start+300 DEF:in=/hdb1/network/rrds/312--7097.rrd:in:AVERAGE DEF:out=/hdb1/network/rrds/312--7097.rrd:out:AVERAGE VDEF:agg_in=in,95,PERCENT VDEF:agg_out=out,95,PERCENT PRINT:agg_in:%lf PRINT:agg_out:%lf which returns 2747448.973130 8762922.770279 Meaning a 95% of 8762922.770279*8-> 70,10 M However, i'm storing 5 min averages for the complete month (and a bit beyond), but since rrd is aggregating the value is of: /usr/bin/rrdtool graph /dev/null -f '' --start now-1month --end start+1month DEF:in=/hdb1/network/rrds/312--7097.rrd:in:AVERAGE DEF:out=/hdb1/network/rrds/312--7097.rrd:out:AVERAGE VDEF:agg_in=in,95,PERCENT VDEF:agg_out=out,95,PERCENT PRINT:agg_in:%lf PRINT:agg_out:%lf --step 300 -w 8928 outputs: 2868596.819213 9171934.664232 Meaning a 95% of 9171934.664232*8 -> 73,37M Note that rrdtool automatically aggregates values if the stepsize < 1 px (hence the need for -w 8928 --> (3600/300)*24*31 ) You might also consider calling rrd_period rrd_end as that is what is does :) SET rrd_start now-1month SET rrd_period +1month results in CLI-> --start now-1month --end start+1month note that my maximum values get even further of: /usr/bin/rrdtool graph /dev/null -f '' --start now-1month --end start+1month DEF:in=/hdb1/network/rrds/312--7097.rrd:in:AVERAGE DEF:out=/hdb1/network/rrds/312--7097.rrd:out:AVERAGE CDEF:out_tmp=out,8,* VDEF:agg_in=in,MAXIMUM VDEF:agg_out=out_tmp,MAXIMUM PRINT:agg_in:%lf PRINT:agg_out:%lf 0x0 3337008.079172 90401759.671587 /usr/bin/rrdtool graph /dev/null -f '' --start now-1month --end start+1month DEF:in=/hdb1/network/rrds/312--7097.rrd:in:AVERAGE DEF:out=/hdb1/network/rrds/312--7097.rrd:out:AVERAGE CDEF:out_tmp=out,8,* VDEF:agg_in=in,MAXIMUM VDEF:agg_out=out_tmp,MAXIMUM PRINT:agg_in:%lf PRINT:agg_out:%lf -w 8928 0x0 4112146.352197 106225252.646708 Thats 16 mbit difference on just 1 interface :0 Erik Versaevel
- Follow-Ups:
- Re: [php-weathermap] 0.96test1 aggregation functions
- From: E. Versaevel
- Re: [php-weathermap] 0.96test1 aggregation functions
- Prev by Date: RE: [php-weathermap] Hint Variables
- Next by Date: 0.96test bug
- Previous by thread: Hint Variables
- Next by thread: Re: [php-weathermap] 0.96test1 aggregation functions
- Index(es):