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

Avoid repeated calls to btr_get_search_latch()

    XMLWordPrintable

    Details

      Description

      The MySQL 5.7 implementation of the parameter adaptive_hash_index_parts introduced a large number of calls to the function btr_get_search_latch(). The adaptive hash index bucket of a particular B-tree index is constant; therefore we should avoid recomputing the hash bucket, especially when calling btr_search_x_lock(index) and btr_search_x_unlock(index) in the same function.

      It is better to cache the result of btr_get_search_latch() in a local variable and to pass that as parameter to certain functions.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              marko Marko Mäkelä
              Reporter:
              marko Marko Mäkelä
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration