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

Avoid repeated calls to btr_get_search_latch()

    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: