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

          Task - A task that needs to be done. MDEV-28730 Remove internal parser usage from InnoDB fts

          • Critical - Crashes, loss of data, severe memory leak.
          • 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

            Ascending order - Click to sort in descending order
            marko Marko Mäkelä created issue -
            marko Marko Mäkelä made changes -
            Field Original Value New Value
            Issue Type Task [ 3 ] Epic [ 5 ]
            marko Marko Mäkelä made changes -
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 10.4 [ 22408 ]
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            Issue Type Epic [ 5 ] Task [ 3 ]
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 78864 ] MariaDB v4 [ 130571 ]
            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.
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            ralf.gebhardt Ralf Gebhardt made changes -
            julien.fritsch Julien Fritsch made changes -
            Labels innodb tablespace transactions innodb synchronization tablespace transactions
            julien.fritsch Julien Fritsch made changes -
            Labels innodb synchronization tablespace transactions innodb tablespace transactions
            julien.fritsch Julien Fritsch made changes -
            Labels innodb tablespace transactions innodb synchronization tablespace transactions
            julien.fritsch Julien Fritsch made changes -
            Labels innodb synchronization tablespace transactions innodb tablespace transactions
            julien.fritsch Julien Fritsch made changes -
            Issue Type Task [ 3 ] New Feature [ 2 ]

            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.