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

Make the InnoDB system tablespace optional

Details

    Description

      The InnoDB system tablespace is an opaque entity that contains essential system data, such as the transaction system state (undo logs could also be in separate tablespaces) and part of the data dictionary information.

      Tablespaces cannot shrink in InnoDB, and the system tablespace cannot be reinitialized. If the system tablespace grows (for example, someone accidentally creates a huge table in it, or accidentally forgets to commit a transaction, causing undo logs to grow, or the change buffer grows for some reason), there is no other remedy than importing or loading the data to a newly initialized innoDB instance.

      Similarly, if the system tablespace gets corrupted, it is ‘game over’.

      This is an umbrella task consisting of subtasks to replace the various system objects stored in the InnoDB system tablespace. The actual work will be done in the subtasks.

      Attachments

        Issue Links

          is blocked by

          Task - A task that needs to be done. MDEV-11657 Cross-engine transaction metadata

          • Major - Major loss of function.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. MDEV-11658 Simpler, faster IMPORT of InnoDB tables

          • Critical - Crashes, loss of data, severe memory leak.
          • Open

          Task - A task that needs to be done. MDEV-11659 Move the InnoDB doublewrite buffer to flat files

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15020 Server hangs due to InnoDB persistent statistics or innodb_stats_auto_recalc

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Task - A task that needs to be done. MDEV-17567 Atomic DDL

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Task - A task that needs to be done. MDEV-19506 Remove the global sequence DICT_HDR_ROW_ID for DB_ROW_ID

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

          New Feature - A new feature of the product, which has yet to be developed. MDEV-21463 Support FULLTEXT INDEX for all storage engines

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-22343 Remove SYS_TABLESPACES and SYS_DATAFILES

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28730 Remove internal parser usage from InnoDB fts

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-29985 Remove the parameter innodb_file_per_table

          • Critical - Crashes, loss of data, severe memory leak.
          • Stalled
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15185 PARTITION files removed, but not from INFORMATION_SCHEMA.INNODB_SYS_TABLES

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21867 Unsafe writes in fil_write_flushed_lsn()

          • Major - Major loss of function.
          • Closed

          Activity

            marko Marko Mäkelä added a comment -

            MDEV-28730 removes one important use case of the InnoDB internal SQL parser.

            marko Marko Mäkelä added a comment - MDEV-28730 removes one important use case of the InnoDB internal SQL parser.

            People

              marko Marko Mäkelä
              marko Marko Mäkelä
              Votes:
              6 Vote for this issue
              Watchers:
              14 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.