It's a lot.
We a lot more devices on our setup. Running since September and here are our stats :
# du -h --max-depth=1 obs (mysql db) 13G obs
[cid:image002.png@01D081BB.40FF6050]
// ### HOUSEKEEPING ### $config['housekeeping']['syslog']['age'] = "1w"; // Maximum age of syslog entries; 0 to disable $config['housekeeping']['eventlog']['age'] = "1M"; // Maximum age of eventlog entries; 0 to disable $config['housekeeping']['alertlog']['age'] = "1M"; // Maximum age of alert log entries; 0 to disable $config['housekeeping']['deleted_ports']['age'] = "1M"; // Maximum age of deleted ports before automatically purging; 0 to disable $config['housekeeping']['rrd']['age'] = "1M"; // Maximum age of unused rrd files before automatically purging; 0 to disable $config['housekeeping']['rrd']['invalid'] = TRUE; // Delete .rrd files that are not valid RRD files (eg created with a full disk) $config['housekeeping']['timing']['age'] = "1M"; // Maximum age of timing (discovery and poll time) entries; 0 to disable
De : observium [mailto:observium-bounces@observium.org] De la part de Bruce Guthrie Envoyé : mardi 28 avril 2015 10:57 À : Observium Network Observation System Objet : Re: [Observium] observium database size
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:image003.gif@01D081BB.40FF6050]
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
