[rrd-users] water usage

[Rick Dicaire]

On Thu, Jul 22, 2010 at 7:51 PM, A Darren Dunham <ddunham at taos.com> wrote:
> But you haven't said anything about your data or how you're putting it
> into the RRD.

I've run into other problems.

rrdtool create /backup/mrtg-2/mrtg/rrd/water.rrd \
--step '86400' \
--start '1279555200' \
'DS:day:GAUGE:172800:U:U' \
'RRA:AVERAGE:0.5:1:7' \
'RRA:MIN:0.5:1:7' \
'RRA:MAX:0.5:1:7' \
'RRA:LAST:0.5:1:7' \
'RRA:AVERAGE:0.5:30:13' \
'RRA:MIN:0.5:30:13' \
'RRA:MAX:0.5:30:13' \
'RRA:LAST:0.5:30:13' \
'RRA:AVERAGE:0.5:100:5' \
'RRA:MIN:0.5:100:5' \
'RRA:MAX:0.5:100:5' \
'RRA:LAST:0.5:100:5'

rrdtool updatev /backup/mrtg-2/mrtg/rrd/water.rrd 1279641600:140
1279728000:750 1279814400:190

return_value = 0
[1279584000]RRA[AVERAGE][1]DS[day] = 1.4000000000e+02
[1279584000]RRA[MIN][1]DS[day] = 1.4000000000e+02
[1279584000]RRA[MAX][1]DS[day] = 1.4000000000e+02
[1279584000]RRA[LAST][1]DS[day] = 1.4000000000e+02
return_value = 0
[1279670400]RRA[AVERAGE][1]DS[day] = 3.4333333333e+02
[1279670400]RRA[MIN][1]DS[day] = 3.4333333333e+02
[1279670400]RRA[MAX][1]DS[day] = 3.4333333333e+02
[1279670400]RRA[LAST][1]DS[day] = 3.4333333333e+02
return_value = 0
[1279756800]RRA[AVERAGE][1]DS[day] = 5.6333333333e+02
[1279756800]RRA[MIN][1]DS[day] = 5.6333333333e+02
[1279756800]RRA[MAX][1]DS[day] = 5.6333333333e+02
[1279756800]RRA[LAST][1]DS[day] = 5.6333333333e+02


rrdtool graph '/usr/local/apache/htdocs/water.png' --title 'Water Usage' \
--vertical-label 'Gallons' \
--start end-4d \
-A -E \
'DEF:la=/backup/mrtg-2/mrtg/rrd/water.rrd:day:LAST' \
'LINE1:la#FF0000' \
GPRINT:la:LAST:'LAST\: %1.1lf \c' \
GPRINT:la:MAX:'MAX\: %1.1lf \c' \
GPRINT:la:MIN:'MIN\: %1.1lf \c'

Produces the following graph http://linux.ardynet.com/water.png