Storing data in sql database (higher data resolution)

D34thCr4z3 · Post by **D34thCr4z3** » Fri Oct 01, 2004 2:04 am

Hi,

my company wants to have a constant 5 minutes resolution of their captured data. As far as I understood cacti/rrdtool will interpolate the values retrieved after some predefined time.

Wouldn't it be useful to retrieve the data from rrdtool and write it into the mysql database instead of graphing right out of the rrd files? You wouldn't have to interpolate your results having high resolution graphs over the last past years.

Thx for replys

D34thCr4z3

Post by **TheWitness** » Mon Oct 04, 2004 5:52 pm

You can change the default behavior of Cacti simply by changing the RRA configuration. We have some users who keep 2 years of 5 minute data in their RRD files (some of which are quite large).

There is no need for SQL entries to accomodate the same.

TheWitness

mokeybrains · Post by **mokeybrains** » Fri Sep 30, 2005 2:22 pm

Where do I alter 'the RRA configuration'? I would like 5 minute resolution for 2 months for some data but not all.

Post by **rony** » Fri Sep 30, 2005 3:38 pm

It's all or none in the current version.

Click on data sources and you will find you answer.

Post by **gandalf** » Fri Sep 30, 2005 3:43 pm

I'm just on the way compiling a HOWTO for that. Just gimme some more time. But the files will really grow a looooooooooooooooooooooooooooot!
Reinhard

mokeybrains · Post by **mokeybrains** » Thu Oct 13, 2005 1:05 pm

Code: Select all

Name   	                   Steps  Rows   	 Timespan
Daily (5 Minute Average)   	 1       9000  	86400  	
Weekly (30 Minute Average) 	 6       700 	604800 	
Monthly (2 Hour Average) 	  24       775 	2678400 	
Yearly (1 Day Average)    	288       797 	33053184

I upded the 5 minute average rowes to '9000' (9000 5 minute steps equals 31 days) and that didn't work. Do I need to alter the timespan row? If so, why is the timespan row not auto calculating? Is that there incase you forget to run the cacti cron for 10 hours or something?

Still figuring out the RRA settings,
Rudy

Post by **gandalf** » Thu Oct 13, 2005 1:37 pm

You'll find some of my post related to that subject at
Intro for the basic understanding: How CONSOLIDATION works at http://forums.cacti.net/viewtopic.php?t=9383

Howto define very BIG rra "without data loss": http://forums.cacti.net/viewtopic.php?t=9605
Howto RESIZE existing RRAs of existing RRDs: http://forums.cacti.net/viewtopic.php?t=9627
Howto View Historical Data after Consolidation (MAX): http://forums.cacti.net/viewtopic.php?t=9826

suppose it would be better not to discuss this in the Features Forum ...

Reinhard

Cacti

Storing data in sql database (higher data resolution)

Storing data in sql database (higher data resolution)

How do I...

Who is online