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

Disable read-ahead for temporary tablespace

    XMLWordPrintable

Details

    Description

      Ever since MDEV-12227 and MDEV-26782 were implemented, writes of pages of the InnoDB temporary tablespace should be rare. Because the lifetime of temporary tables is expected to be short, it would seem to make sense to assume that all temporary tablespace pages will remain in the buffer pool, and to disable the read-ahead for pages of the temporary tablespace.

      Having read-ahead enabled for temporary tablespace pages would cause debug assertion failures in MDEV-28699. It is simplest to disable the read-ahead.

      Attachments

        Issue Links

          Activity

            People

              thiru Thirunarayanan Balathandayuthapani
              thiru Thirunarayanan Balathandayuthapani
              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.