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

Optimize buf_page_optimistic_get()

    XMLWordPrintable

Details

    Description

      In 10.5, MDEV-21329 patch introduces functor to do get btr_page_optimistic_get().
      Basically functor basically checks whether the page is in buffer pool and it is the same page, takes hash lock for the respective page id. But in 10.5 alone, InnoDB does check the page id and page state, takes page hash lock again. The earlier optimizations that were implemented in MDEV-15053 and MDEV-22871 would allow this to be improved further.

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-15053 Reduce buf_pool_t::mutex contention

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21329 InnoDB: Failing assertion: lock->lock_word.load(std::memory_order_relaxed) == X_LOCK_DECR upon server shutdown

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22871 Contention on the buf_pool.page_hash

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Activity

            People

              thiru Thirunarayanan Balathandayuthapani
              thiru Thirunarayanan Balathandayuthapani
              Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.