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

The forced use of THD accessor functions hurts InnoDB performance

    XMLWordPrintable

Details

    • Related to performance
    • Q4/2025 Server Maintenance

    Description

      The testing that was conducted in MDEV-37152 proves that making class THD opaque for InnoDB is costing a significant amount of performance. Applying this 10.11 based change would improve the throughput under one test setting by 1.25%. For another branch that includes further performance fixes, a performance gain of 2.43% was measured.

      Exposing the internals of THD to InnoDB would also allow add debug assertions to document and enforce some metadata locking rules; examples include MDEV-37365 and MDEV-35895.

      In the past, serg has been against exposing server internals to more storage engines. They are already being exposed to some storage engines.

      Attachments

        1. IPO_flamegraph.svg
          1.42 MB
          Rahul Raj
        2. IPO_march_mtune_flamegraph.svg
          1.41 MB
          Rahul Raj
        3. march_native_flamegraph.svg
          1.48 MB
          Rahul Raj
        4. mtune_native_flamegraph.svg
          1.50 MB
          Rahul Raj

        Issue Links

          blocks

          Bug - A problem which impairs or prevents the functions of the product. MDEV-37152 buf_page_get_gen -> buf_pool->stat.n_page_gets++ high cpu utilisation

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35895 purge_sys_t::close_and_reopen() can busy loop for a long time

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-37365 Crash when ALTER TABLE on parent runs concurrently with INSERT on child

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-37659 CHECK TABLE…EXTENDED reports a bogus error on a column prefix index

          • Major - Major loss of function.
          • Open

          Activity

            People

              marko Marko Mäkelä
              marko Marko Mäkelä
              Marko Mäkelä Marko Mäkelä
              Saahil Alam Saahil Alam
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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