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

Statistics used to track b-tree (non-adaptive) searches should be updated only when adaptive hashing is turned-on

    XMLWordPrintable

    Details

      Description

      Currently, btr_cur_n_non_sea is used to track the search that missed
      adaptive hash index. adaptive hash index is turned off by default
      but the said variable is updated always though the value of it makes sense
      only when an adaptive index is enabled. It is meant to check how many
      searches didn't go through an adaptive hash index.

      Given a global variable that is updated on each search path it causes
      a contention with a multi-threaded workload.

      Patch moves the said variables inside a loop that is now updated
      only when the adaptive hash index is enabled and that in theory should
      also, reduce the update frequency of the said variable as the majority of
      the request should be serviced through the adaptive hash index.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              marko Marko Mäkelä
              Reporter:
              krunalbauskar Krunal Bauskar
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: