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

Restoring InnoDB buffer pool dump is single-threaded for no reason

Details

    Description

      Loading the InnoDB buffer pool at startup is only using a single thread. This can be easily confirmed by starting the server and checking that perf top -H only shows one thread being active.

      There is no reason at all to pass the parameter sync=true to buf_read_page_background(). If we allow buf_load() to submit asynchronous reads, multiple page checksums will be computed in parallel by the read completion threads while further pages are being read into the buffer pool.

      Attachments

        Issue Links

          Activity

            marko Marko Mäkelä created issue -
            marko Marko Mäkelä made changes -
            Field Original Value New Value
            Status Open [ 1 ] In Progress [ 3 ]
            marko Marko Mäkelä made changes -
            issue.field.resolutiondate 2021-09-06 07:52:04.0 2021-09-06 07:52:04.444
            marko Marko Mäkelä made changes -
            Fix Version/s 10.5.13 [ 26026 ]
            Fix Version/s 10.6.5 [ 26034 ]
            Fix Version/s 10.5 [ 23123 ]
            Fix Version/s 10.6 [ 24028 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            marko Marko Mäkelä made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 124833 ] MariaDB v4 [ 159663 ]
            marko Marko Mäkelä made changes -

            People

              marko Marko Mäkelä
              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.