Announcement

Collapse
No announcement yet.

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