Historical Data, Catistoric....

[smartinez]

I've been asked if it's possible to go back in time and get historical data on particular hosts. For example, management wants to know if I can go to August 3rd and look at the hourly traffic statistics on hostA. Does this data reside somewhere in MySQL, RRD, etc.? Is this something that can be mined and retrieved?

If not, is there a way to capture that data via a different mechanism and redirect it to a text file or other format as it's being captured every 5 minutes?

I looked at the Catistoric thread but it seems people are having problems with it and the discussion seems to have died down.

Many thanks,

-Samson

[Bisonlux]

Hi,

Values are stored in the rra file (rra => round robin archive).
Use rrdtool dump filename.rrd > filename.xml to look inside the rrd file


Let’s take an example:

Step = 1 means a total of 1 sample is necessary to put the value (average, min, max, last) in the archive
Rows = 600 means the archive store 600 values

As you know cacti takes a sample all 5 minutes. So the archive represents 600*5=3000 minutes (A little bit more than 2 days).

To short to show you the traffic on August 3rd

To archive the last 3 month modify the row value (129600) (3 month*30 days*24 hours*60 minutes/5).

Good luck !

[mooseman]

If one were to increase these numbers, would the default graphs still show the correct timespan, or would those need to be altered in some way?