[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

0.96test1 aggregation functions



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


Copyright 1994-2005, by Howard Jones. howie@thingy.com