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

Do not create the InnoDB temporary tablespace in innodb_read_only mode

    XMLWordPrintable

Details

    Description

      The InnoDB temporary tablespace is only usable if innodb_read_only=OFF. It is useless to create the tablespace in read-only mode, because CREATE TEMPORARY TABLE is disallowed if innodb_read_only, and nothing can we written to the temporary tablespace if no temporary tables can be created.

      (Note that in MySQL 5.7, optimizer-internal temporary tables might still use the InnoDB temporary tablespace even if innodb_read_only. In MariaDB the optimizer does not use InnoDB for its temporary tables, and MDEV-11487 removed the related InnoDB code.)

      Attachments

        Issue Links

          Activity

            People

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