Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-21952

ibdata1 file size growing in MariaDB

    XMLWordPrintable

Details

    Description

      We are using DATETIME Interval in most of our MariaDB Tables where we have automated Data Purging Process to delete data at Interval 1 DAY , INTERVAL 1 HOUR and we have Optimize Table script which runs once in day ( ALTER TABLE <table> ENGINE=InnoDB )

      It is observed ibdata1 file in mysql folder has grown to 122 GB

      Do we have Tuning options or Space recovery options that we can some have workaround on ibdata1 file ?

      Attachments

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              tarun Tarun
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.