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

I/O Performance 'Use all warehouses' results in 40% mutex contention

    XMLWordPrintable

Details

    • Q1/2026 Server Development

    Description

      TBD

      Attachments

        1. 128G_use_all_warehouse.png
          128G_use_all_warehouse.png
          90 kB
        2. 64G_use_all_warehouse.png
          64G_use_all_warehouse.png
          64 kB
        3. buf_pool_mutex.png
          buf_pool_mutex.png
          55 kB
        4. Drop_Percentage.png
          Drop_Percentage.png
          28 kB
        5. Flamegraph_Use_all_Warehouse_128G.zip
          4.76 MB
        6. Flamegraph_Use_all_Warehouse_64G.zip
          4.25 MB
        7. MySQL_MariaDB_Graph.png
          MySQL_MariaDB_Graph.png
          46 kB
        8. OFFCPU_MDEV_37924.zip
          632 kB

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-30182 Optimize open_tables to take O(N) time

          • Major - Major loss of function.
          • Stalled

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35155 Small innodb_log_file_size leads to excessive write amplification

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

          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

          New Feature - A new feature of the product, which has yet to be developed. MDEV-5092 Implement UPDATE with result set (UPDATE ... RETURNING)

          • Major - Major loss of function.
          • Open

          Activity

            People

              marko Marko Mäkelä
              adamluciano Adam Luciano
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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