Rrd tricks

Predicted trends ( straight line)

https://lists.oetiker.ch/pipermail/rrd-users/2008-March/013819.html

On Mon, Mar 10, 2008 at 04:03:57PM +0100, Felix Castillo Sanchez wrote:
> 
> I'm trying to reconstruct the nice graph showed in the "Gallery" showing
> filesystem utilization and predicted trends.
> 
> Can somebody tell me how to draw the lines for the future?

You may find it easier to do much of the work outside of rrd. But I'm drawing some similar lines. I haven't done all the work to make the dates come out nice, though.

Something like:

[...]
             "DEF:scratch=$rrd_file:scratch:AVERAGE",
# Calculate slope
             "VDEF:slope=scratch,LSLSLOPE",
             "VDEF:int=scratch,LSLINT",
# Graph trend line
             "CDEF:trend=scratch,POP,slope,COUNT,*,int,+",
             "LINE:trend#00FF00",
# Find regions where trend is less than 0
             "CDEF:sub=trend,NEGINF,1,LIMIT",
             "VDEF:first_sub=sub,FIRST",
             "GPRINT:first_sub:Predicted empty %F:strftime",
# Vertical line at that point
             "VRULE:first_sub#FF0000:exhaustion point",
[...]

Note that in my case I'm looking for when the graph hits zero, not when it hits 100.

You'll probably want to lock down the vertical graph limits to keep the line from extending them too far.

Replace nan with previous value

From the rrdtool mailing list

Samuel asks:

> I want to know how with a CDEF or in a configuration directly
> stored in RRD files how can I replace nan value by the last real value.

Steve responds:

CDEF:newds=ds,UN,PREV,ds,IF

IE, if the value of 'ds' is unknown, then use its previous value, else use its original value.

This is the function done by MRTG in native mode, or with Routers2 and the 'unknasprev' option.

Volume transferred over a period of time

http://www.vandenbogaerdt.nl/rrdtool/total.php

rrdtool graph /var/www/cacti-0.8.7b/z-greycup_bandwidth/www.client.ca.png \
 --start `date --date='Sun Nov 27 2011 08:00:00 GMT-5' +%s` \
 --end   `date --date='Mon Nov 28 2011 06:00:00 GMT-5' +%s` \
 --title "www.client.ca Data Transfered" \
DEF:ds0=www.client.ca.rrd:traffic_in:AVERAGE                      \
DEF:ds1=www.client.ca.rrd:traffic_out:AVERAGE                      \
LINE:ds0#00FF00:"In\l"            \
LINE:ds1#FF0000:"Out\l"            \
VDEF:ds0average=ds0,AVERAGE \
VDEF:ds1average=ds1,AVERAGE \
CDEF:ds0modified=ds0,UN,ds0average,ds0,IF \
CDEF:ds1modified=ds1,UN,ds1average,ds1,IF \
VDEF:ds0total=ds0modified,TOTAL \
VDEF:ds1total=ds1modified,TOTAL \
COMMENT:"Start\: Sun Nov 27 2011 08\:00\:00 GMT-5\l" \
COMMENT:"End\:   Mon Nov 28 2011 06\:00\:00 GMT-5\l" \
GPRINT:ds0total:"Total In\:%12.2lf%s \l" \
GPRINT:ds1total:"Total Out\:%12.2lf%s \l"

Resources

• http://rrdtool.vandenbogaerdt.nl/ - good notes explanations and tutorials