Announcement

Collapse

New forum rules

The forum get new posts rules.

A new user will be moderate for new post. After five valid posts, the user will be to have right to post without moderation.

If you have some issue to post or to connect, contact us.
See more
See less

purge centreon_storage database

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

  • 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.



  • #2
    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 |

    Comment


    • #3
      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.

      Comment


      • #4
        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




        Comment


        • #5

          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 |

          Comment


          • #6

            A technique to reduce it without breaking everything?

            Comment


            • #7
              Bonjour,

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

              Cdlt

              Comment

              Working...
              X