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

Avoid un-necessary page initialization during recovery

Details

    Description

      After MDEV-22169, InnoDB could do unnecessary page initialization during recovery.
      InnoDB does unnecessary traversal of redo logs during last phase.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          thiru Thirunarayanan Balathandayuthapani added a comment - - edited

          Patch is present in bb-10.5-MDEV-22913. Please review it whenever possible.
          Ran all test suites and tested with MDEV-22169 data directory

          thiru Thirunarayanan Balathandayuthapani added a comment - - edited Patch is present in bb-10.5- MDEV-22913 . Please review it whenever possible. Ran all test suites and tested with MDEV-22169 data directory
          marko Marko Mäkelä added a comment -

          This looks OK to me. But I think we need broad RQG testing of recovery (kill the server, restart with a random innodb_buffer_pool_size). Normal regressions tests do not typically perform crash recovery with a smaller buffer pool size.

          marko Marko Mäkelä added a comment - This looks OK to me. But I think we need broad RQG testing of recovery (kill the server, restart with a random innodb_buffer_pool_size ). Normal regressions tests do not typically perform crash recovery with a smaller buffer pool size.
          mleich Matthias Leich added a comment -

          In RQG testing (CrashRecovery)
          origin/bb-10.5-MDEV-22193 75d592800ae0109c9f3df040b0a8afe78075f2c1 2020-04-08T18:45:52+05:30
          performed just as well as the actual 10.5. Both showed the same bad effects.

          mleich Matthias Leich added a comment - In RQG testing (CrashRecovery) origin/bb-10.5- MDEV-22193 75d592800ae0109c9f3df040b0a8afe78075f2c1 2020-04-08T18:45:52+05:30 performed just as well as the actual 10.5. Both showed the same bad effects.

          People

            thiru Thirunarayanan Balathandayuthapani
            thiru Thirunarayanan Balathandayuthapani
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.