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

InnoDB system tablespace cannot be shrunk

    XMLWordPrintable

Details

    Description

      hello
      i used to have all tables on ibdata1 before, then i switched to one file per table, but the ibdata1 file keep its size.
      I recently switched to mariadb 10.1, and hoped that the defragmenting function would help to shrink the file, but it didn't worked.
      I optimised all tables, but the ibdata1 file did not changed at all, it is still 197gb

      MariaDB [(none)]> show status like '%defragment%';
      +----------------------------------------+--------+
      | Variable_name                          | Value  |
      +----------------------------------------+--------+
      | Innodb_defragment_compression_failures | 0      |
      | Innodb_defragment_failures             | 32872  |
      | Innodb_defragment_count                | 113744 |
      +----------------------------------------+--------+
      3 rows in set (0.01 sec)
      

      MariaDB [(none)]> show variables like '%defragment%';
      +--------------------------------------+----------+
      | Variable_name                        | Value    |
      +--------------------------------------+----------+
      | innodb_defragment                    | ON       |
      | innodb_defragment_fill_factor        | 0.900000 |
      | innodb_defragment_fill_factor_n_recs | 20       |
      | innodb_defragment_frequency          | 40       |
      | innodb_defragment_n_pages            | 7        |
      | innodb_defragment_stats_accuracy     | 0        |
      +--------------------------------------+----------+
      

      Attachments

        Issue Links

          Activity

            People

              thiru Thirunarayanan Balathandayuthapani
              martina342 martina342
              Votes:
              2 Vote for this issue
              Watchers:
              15 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.