I'm using rrdtool for the first time and would like to know if I'm using it correctly.
A database containing a set of customers (identified by a customer name) has data records consisting of a date, a duration time (in seconds) and a data amount (in kilobytes) as follows: CUSTOMER DATE DURATION AMOUNT (name) (yyyymmdd) (seconds) (kilobytes) ---------------------------------------------------------------------------------- customer-1 20010301 322 25435600 customer-1 20010302 346 23462600 customer-1 20010312 289 26438600 ... customer-2 20010412 655 45358600 customer-2 20010413 542 45435600 ... customer-3 20010101 404 39935600 customer-3 20010108 407 55435600 customer-3 20010113 428 11222334 ... Each record is actually the sum of each customer's records for a given day (i.e., the duration and amount fields are summed). I'd like to make a graph for each customer showing the total duration and amount of backups vs. date so here's what I created: # I create a rrd with a step size of 1 day (86400 sec) # so the rra should contain the raw data for that day rrdtool create customer.rrd \ --start 973065600 --step 86400 \ DS:time:ABSOLUTE:86400:0:U \ DS:data:ABSOLUTE:86400:0:U \ RRA:AVERAGE:0.999:1:365 # here I input the data rrdtool update customer.rrd 973411200:22788:151699776 [...] # the two graphs below should present the raw data for each day rrdtool graph customer-time.gif \ --start -30d --step 86400 -w 800 -h 400 -i \ -v TIME(sec) -t customer-time.gif \ DEF:y=customer.rrd:time:AVERAGE \ CDEF:ry=y LINE2:ry#FF0000 AREA:ry#FF0000 rrdtool graph customer-data.gif \ --start -30d --step 86400 -w 800 -h 400 -i \ -v DATA(bytes) -t customer-data.gif \ DEF:y=customer.rrd:data:AVERAGE \ CDEF:ry=y LINE2:ry#FF0000 AREA:ry#FF0000 I want to graph both time and amount data for each customer with the line being the actual data (duration or kilobytes) for that date (ie.., day). The output seems to be off by a factor of 1000 or more but I can't see why. Any comments would be appreciated. Thanks, Alan ---------- Alan Factor [EMAIL PROTECTED] 888.707.4900 Voice/Fax 888.707.4988 Cell Phone AFactor LLC www.afactor.com ---------- -- Unsubscribe mailto:[EMAIL PROTECTED] Help mailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdmin http://www.ee.ethz.ch/~slist/lsg2.cgi
