Announcement

Collapse
No announcement yet.

purge centreon_storage database

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • gonthier
    replied
    Bonjour,

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

    Cdlt

    Leave a comment:


  • tintin
    replied

    A technique to reduce it without breaking everything?

    Leave a comment:


  • tintin
    replied

    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:


  • tintin
    replied
    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:


  • mbersoult
    replied
    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:


  • tintin
    replied
    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:


  • tintin
    started a topic purge centreon_storage database

    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.


Working...
X