Hi,

 

Try running the housekeeping script to remove old data.

 

./housekeeping.php –a –A 6M

 

This will cleanup old syslog entries, events, alert logs, deleted ports, timing data and old RRD files (-a) all information older than 6 Months.

 

Run it as ./housekeeping.php –h to see all the options.

 

Regards

 

Bruce

 

From: observium [mailto:observium-bounces@observium.org] On Behalf Of Roland Schwingel
Sent: Tuesday, 28 April 2015 18:41
To: Observium Network Observation System
Subject: [Observium] observium database size

 

Hi....

Just a silly question. I was googling around for number but could not find meaningful reallife data.

I am running now an observium instance for about a year. I am polling presently 22 serves, 14 switches and 1 printer.
Alltogether 1004 ports. My mysql database is now 189 GB big. I need to resize my filesystem soon.

Attached you can also find my statistics output from observium



Is this database size normal?
How big can it grow? in one year? In 2 years? Is there an upper ceiling?
What are your database sizes (maybe in a similar scenario)?

Thanks for your help,

Roland