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

Remove the parameter innodb_file_per_table

    XMLWordPrintable

Details

    Description

      The configuration parameter innodb_file_per_table needs to be removed for reasons that were explained in MDEV-29983.

      As part of this task, some additional logic for moving tables out of the system tablespace will be implemented.

      • CHECK TABLE…FOR UPGRADE should flag any tables that are stored in the system tablespace, so that they will be rebuilt.
      • Any DDL statements except RENAME TABLE, that is, TRUNCATE, OPTIMIZE TABLE, ALTER TABLE, will force a table to be rebuilt if it was stored in the system tablespace.

      Tables that are located in the system tablespace will continue to be readable and writable even if the upgrade procedure is being skipped.

      Attachments

        Issue Links

          blocks

          New Feature - A new feature of the product, which has yet to be developed. MDEV-11633 Make the InnoDB system tablespace optional

          • Major - Major loss of function.
          • Open
          is blocked by

          Task - A task that needs to be done. MDEV-29983 Deprecate innodb_file_per_table

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30563 Failure 1478: Table storage engine 'InnoDB' does not support the create option 'ROW_TYPE' upon OPTIMIZE TABLE after Recovery

          • Major - Major loss of function.
          • Open

          Activity

            People

              marko Marko Mäkelä
              marko Marko Mäkelä
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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