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

Hard-code the shared InnoDB temporary tablespace ID

    XMLWordPrintable

    Details

      Description

      MySQL 5.7 supports only one shared temporary tablespace.
      MariaDB 10.2 does not support any other shared InnoDB tablespaces than the two predefined tablespaces: the persistent InnoDB system tablespace (default file name ibdata1) and the temporary tablespace (default file name ibtmp1).

      InnoDB is unnecessarily allocating a tablespace ID for the predefined temporary tablespace on every startup, and it is in several places testing whether a tablespace ID matches this dynamically generated ID.

      We should use a compile-time constant to reduce code size and to avoid unnecessary updates to the DICT_HDR page at every startup.

      Using a hard-coded tablespace ID will also make it easier to remove the TEMPORARY flag from FSP_SPACE_FLAGS in MDEV-11202.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              marko Marko Mäkelä
              Reporter:
              marko Marko Mäkelä
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: