purge centreon_storage database

[gonthier]

Bonjour,

Quelqu'un a trouvé une solution pour réduire la base de données Centreon_Storage ?

Cdlt

[tintin]

A technique to reduce it without breaking everything?

[tintin]

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 |

[tintin]

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

[mbersoult]

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.

[tintin]

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 |

[tintin]

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.