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

Expose adaptive hash index statistics in ANALYZE FORMAT=JSON

    XMLWordPrintable

Details

    • Added visibility into InnoDB Adaptive Hash Index metrics (ahi_searches, ahi_searches_btree, ahi_rows_added, and ahi_pages_added) through ANALYZE FORMAT=JSON and global status variables.
    • Q2/2026 Server Development, Q3/2026 Server Maintenance

    Description

      MDEV-37070 proposes options for more detailed control of creating the adaptive hash index. To make it feasible for DBAs to tune these parameters, we should expose some adaptive hash index and key lookup statistics via ANALYZE FORMAT=JSON SELECT (MDEV-31577). Currently we only expose some global counters in SHOW ENGINE INNODB STATUS.

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-39401 Buffer AHI usage counters btr_cur_n_*sea in non-atomic members of trx_t

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Task - A task that needs to be done. MDEV-31577 Make ANALYZE FORMAT=JSON print innodb stats

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MDEV-37070 Implement table and index options to enable/disable ADAPTIVE_HASH_INDEX

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

          Task - A task that needs to be done. MDEV-40055 Testing of MDEV-38305

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

          Activity

            People

              tafzeel Mohammad Tafzeel Shams
              marko Marko Mäkelä
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 10d Original Estimate - 10d
                  10d
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 15d 3h
                  15d 3h

                  Git Integration

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