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

More fine grained control of spin loops could be useful

    XMLWordPrintable

Details

    • Q3/2025 Maintenance, Q4/2025 Server Maintenance

    Description

      In an attempt to address MDEV-34178, I enabled spin loops on dict_index_t::lock. This helps in some workloads and causes performance degradation in others, especially when there are large numbers of concurrent connections.

      It could make sense to enable spin loops on a case-by-case basis, or to introduce a configuration parameter for choosing when index tree latch acquisition should include spin loops.

      Attachments

        Issue Links

          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34515 Contention between secondary index UPDATE and purge due to large innodb_purge_batch_size

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34759 buf_page_get_low() is unnecessarily acquiring exclusive latch on secondary index pages

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34791 Redundant page lookups hurt performance

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-37244 buf_read_page() should return a buffer-fixed block

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

          New Feature - A new feature of the product, which has yet to be developed. MDEV-38814 High rate of index_lock_upgrades due to btr_cur_need_opposite_intention() mostly returning true

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34178 Performance regression with IO-bound insert benchmark

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

          Activity

            People

              marko Marko Mäkelä
              marko Marko Mäkelä
              Votes:
              2 Vote for this issue
              Watchers:
              15 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - 4d Original Estimate - 4d
                  4d
                  Remaining:
                  Time Spent - 12d 0.25h Remaining Estimate - 3d 6.5h
                  3d 6.5h
                  Logged:
                  Time Spent - 12d 0.25h Remaining Estimate - 3d 6.5h
                  12d 0.25h

                  Git Integration

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