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
[cid:image001.gif@01D081E5.19942EE0]
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
