[rrd-users] Re: Convert .rrd to .log ?

Alex van den Bogaerdt alex at slot.hollandcasino.nl
Tue Jul 9 03:56:49 MEST 2002

Skeeve Stevens wrote:

> I am using the routers.cgi frontend which works great.
> What it doesnt do is have the ability to show total daily usage with historical capability.

There are two possible problems:

1) the frontend (routers.cgi in your case) must allow to specify an
   end time, such as Februari 1st 00:00
2) you need to have the data available

A "normal" RRDtool setup (read: a MRTG compatible database) will not keep
the data in the finest resolution for more than 600 * 5 minutes.  If you
ask for data from many moons ago, it simply isn't available *except* in
a resolution such as 1 row per day.  If you then display (say) 31 days on
an image of 400 pixels wide, you just get to see 31 bars, each bar
representing one day.

> Does anyone know how to store historical data?

1st step: increase the lenght of your RRA.  In order to be able to view
upto a year back, you need 366 days times 24 hours times 12 rows per hour
(assuming the default of 5 minutes per row) totalling 105408 rows.

There are other ways of achieving this, such as having an RRA of size
31*24*12 == 8928 --> nicely rounded to 10000 rows.  At the start of
each month, make a backup of your RRD and name it, for instance,
router1_port1_januari.rrd (so: add _januari).  Then you need to build
an intelligent front end that knows to query this database when you
want to view data from januari, and knows it should query the database
with name router1_port1_februari.rrd to get data from februari.  As you
probably can imagine, the large RRD (with an RRA of size 105408) is
much more easy to implement and maintain.

2nd step: find, or create, a front end that allows you to specify the
end time of the image

3rd step: wait.  There's no data available yet so you have to wait.

> I thought of converting the .rrd files back to mrtg .log format and using the tool from Toby's mrtg page
> http://iserv.nl/traffic/totaal/ (log file analysis by Seth).

In an MRTG log file the data also isn't available at high resolution.

 / alex at slot.hollandcasino.nl                  alex at ergens.op.het.net \
| work                                                         private |
| My employer is capable of speaking therefore I speak only for myself |
| Technical questions sent directly to me will be nuked. Use the list. | 
| http://faq.mrtg.org/                                                 |
| http://rrdtool.eu.org  --> tutorial                                  |

Unsubscribe mailto:rrd-users-request at list.ee.ethz.ch?subject=unsubscribe
Help        mailto:rrd-users-request at list.ee.ethz.ch?subject=help
Archive     http://www.ee.ethz.ch/~slist/rrd-users
WebAdmin    http://www.ee.ethz.ch/~slist/lsg2.cgi

More information about the rrd-users mailing list