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

// ### 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



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