Bonjour,
Quelqu'un a trouvé une solution pour réduire la base de données Centreon_Storage ?
Cdlt
Announcement
Collapse
No announcement yet.
purge centreon_storage database
Collapse
X
-
I changed the retention from 365 to 90 days but the database is still huge ... table_schema | Size (M| +--------------------+------------+ | centreon | 8.7969 | | centreon_storage | 15860.0352 |
Leave a comment:
-
no error in centreon-purge.log :
2017-04-27 02:05:21 - Purging centstorage.logs table...
2017-04-27 04:18:19 - Done
2017-04-27 04:18:19 - Purging log archive tables...
2017-04-27 04:18:19 - Done
2017-04-27 04:18:19 - Purging centstorage.index_data table...
2017-04-27 04:18:19 - Done
2017-04-28 02:00:02 - Purging centstorage.data_bin table...
2017-04-28 02:06:01 - Done
2017-04-28 02:06:01 - Purging centstorage.logs table...
2017-04-28 04:21:51 - Done
2017-04-28 04:21:51 - Purging log archive tables...
2017-04-28 04:21:51 - Done
2017-04-28 04:21:51 - Purging centstorage.index_data table...
2017-04-28 04:21:51 - Done
Thank you for information about the retention menu
Leave a comment:
-
Hello,
Can you see into /var/log/centreon/centreon-purge.log if you have some errors ?
You can reduce the retention time on page : Administration > Parameters > Options.
Leave a comment:
-
MariaDB [centreon_storage]> SELECT table_schema, round(sum(data_length+index_length)/1024/1024,4) AS "Size (M" FROM information_schema.tables GROUP BY table_schema;
+--------------------+------------+
| table_schema | Size (M|
+--------------------+------------+
| centreon | 8.7969 |
| centreon_storage | 15811.0820 |
Leave a comment:
-
purge centreon_storage database
Hello My problem is the following my database centeron_storage is huge how to purger keep for example only 2 months? thank you in advance I have Centreon 2.7.8.
Tags: None
Leave a comment: