Good morning.
I encountered several problems with my centreon database.
For 200 hosts is 2500 services, is it normal to have a 61G database?
My central server has been around for 6 months.
I noticed that I have ghost hosts in the duplicate hosts db.
It appears in the database but is invisible in centreon.
It's ghost host also makes metrics and inflates the bdd?
I have 4.5G data_bin files, is that normal?
How to solve the problem ? To reduce, the bdd to a reasonable size?
Sorry for my English.
Hi,
What do you have for retention in BDD ?
It’s the retention for metrics data. It’s used when you want to rebuild RRD files.
I have 2 months for retention on BDD, and my BDD is 54Gb for 1440 hosts and 14750 services.
But your checks intervals is also important. If all your checks occurs every 5min or less, and if you have no checks with 10,15,20min..., your dababase will grow up.
+3
Hello, It's normal, you have to change the settings which Michael said, or You can disable store in performance data in data in table.(Broker-Configuration=>central-rrd-master=>output)
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
