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

Avoid writes of freed (garbage) pages to InnoDB data files

    XMLWordPrintable

Details

    Description

      The flushing of the InnoDB temporary tablespace is unnecessarily tied to the write-ahead redo logging and the flushing of the persistent tablespaces.
      It would be good to avoid any writes to the temporary tablespace, unless the pages are being evicted from the buffer pool and going to be reused.

      This task is one step towards that goal: When a page in a temporary tablespace is marked as free, we should remove the page from the flush list. This will avoid unnecessary writes of garbage that is certainly not needed any more. (The freed pages would never be read back; instead new pages would be created.)

      Attachments

        Issue Links

          blocks

          Task - A task that needs to be done. MDEV-12227 Defer writes to the InnoDB temporary tablespace

          • Major - Major loss of function.
          • Closed
          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-12219 Discard temporary undo logs at transaction commit

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15528 Avoid writing freed InnoDB pages

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-16526 Overhaul the InnoDB page flushing

          • Major - Major loss of function.
          • Closed

          Activity

            People

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