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