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

10% tps drop in sysbench tests - PS, RO and RW

    XMLWordPrintable

Details

    • Bug
    • Status: Stalled (View Workflow)
    • Major
    • Resolution: Unresolved
    • 13.0
    • 12.3
    • None
    • Ubuntu 22.0

    Description

      10% tps drop in memory bound test of sysbench's point_select, oltp_ro, oltp_rw

      I need to verify whether it's coming from change "PERFORMANCE_SCHEMA now uses XXH3_128 for digests (MDEV-31669)"

      Attachments

        1. mariadb_simple_2gbp.cnf
          0.5 kB
        2. OLTP_RO_11_12_13_cache_config.html
          15 kB
        3. OLTP_RO_11_12_13_MDEV.html
          13 kB
        4. OLTP_RW__11_12_13_cache_config.html
          15 kB
        5. OLTP_RW_11_12_13_MDEV.html
          13 kB
        6. OLTP_RW_20260424_115352.chartplus_testinfo.html
          15 kB
        7. OLTP_RW_20260425_195144.chartplus_testinfo.html
          19 kB
        8. POINT_SELECT_11_12_13_cache_config.html
          16 kB
        9. POINT_SELECT_11_12_13_mdev.html
          14 kB
        10. POINT_SELECT_MDEV30364.detailed.run.html
          25 kB
        11. redoReport.txt
          7 kB
        12. screenshot-1.png
          screenshot-1.png
          107 kB
        13. screenshot-2.png
          screenshot-2.png
          109 kB
        14. screenshot-3.png
          screenshot-3.png
          84 kB
        15. screenshot-4.png
          screenshot-4.png
          94 kB
        16. screenshot-5.png
          screenshot-5.png
          90 kB
        17. screenshot-6.png
          screenshot-6.png
          95 kB
        18. Screenshot from 2026-04-18 15-51-44.png
          Screenshot from 2026-04-18 15-51-44.png
          141 kB
        19. Screenshot from 2026-04-18 15-53-15.png
          Screenshot from 2026-04-18 15-53-15.png
          131 kB
        20. Screenshot from 2026-04-18 15-53-26.png
          Screenshot from 2026-04-18 15-53-26.png
          124 kB
        21. SELECT_DISTINCT_RANGES__MDEV30364.detailed.run.html
          25 kB
        22. SELECT_ORDER_RANGES_20260427_060142.chartplus_testinfo.html
          16 kB
        23. SELECT_SIMPLE_RANGES_20260427_055057.chartplus_testinfo.html
          16 kB
        24. SELECT_SIMPLE_RANGES_MDEV30364.detailed.run.html
          25 kB
        25. SELECT_SUM_RANGES_20260427_055725.chartplus_testinfo.html
          16 kB
        26. SELECT_SUM_RANGES_MDEV30364.detailed.run.html
          25 kB
        27. sysbench_lua.properties
          9 kB

        Issue Links

          relates to

          New Feature - A new feature of the product, which has yet to be developed. MDEV-31669 performance_schema not to use md5 for digest

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-39189 XXH SIMD acceleration is not being enabled

          • Major - Major loss of function.
          • Confirmed

          Activity

            People

              jeb Jonathan Jeb Miller
              amroo76 Amrendra Kumar
              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.