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

Performance degradation and unstable observed on 10.6.19

    XMLWordPrintable

Details

    Description

      I plan to migrate our MariaDB instances from `10.2.10` to `10.6.19`, and have run some performance benchmarks. And I observed performance is not stable compared to `10.2.10`, especially for in-memory workload.

      Here is my test setup.
      Test tool: sysbench 1.0.X
      OS: CentOS 7.9 X86_64
      MariaDB version: 10.2.10 10.6.19
      Dataset: create 10 tables and each with 5M rows, each table ~ 1.2GB, the total size is ~ 12GB
      Almost all config options are the same, except I removed some options which is deprecated/removed in 10.6, e.g. `innodb_buffer_pool_instances`, `innodb_page_cleaners`,`innodb-thread-concurrency`,`innodb_checksum_algorithm` etc.

      Test 1.
      In-memory workset, with `innodb_buffer_pool_size`=188GB
      > NOTE:
      > TPS-X means using X threads run sysbench `oltp_read_write.lua` test

      10.2.10

      10.6.19

      We can see there are performance drops periodically with version `10.6.19`. The `10.6.19` can keep stable only in `4` threads case, while `10.2.10` 's performance is always stable with threads `4, 8, 16, and 32`.

      Test 2:
      Disk io bund test with `innodb_buffer_pool_size=2G`

      10.2.10

      10.6.19

      you can see `10.2.10` is also more stable compared to `10.6.19`.

      Attachments

        1. image-2024-10-15-11-41-04-176.png
          image-2024-10-15-11-41-04-176.png
          44 kB
        2. image-2024-10-15-11-43-21-120.png
          image-2024-10-15-11-43-21-120.png
          60 kB
        3. image-2024-10-15-11-46-38-886.png
          image-2024-10-15-11-46-38-886.png
          101 kB
        4. image-2024-10-15-11-47-23-300.png
          image-2024-10-15-11-47-23-300.png
          140 kB
        5. image-2024-10-16-14-52-49-455.png
          image-2024-10-16-14-52-49-455.png
          59 kB
        6. image-2024-10-16-16-03-42-724.png
          image-2024-10-16-16-03-42-724.png
          30 kB
        7. screenshot-1.png
          screenshot-1.png
          56 kB
        8. screenshot-2.png
          screenshot-2.png
          42 kB
        9. screenshot-3.png
          screenshot-3.png
          40 kB
        10. screenshot-4.png
          screenshot-4.png
          44 kB
        11. screenshot-5.png
          screenshot-5.png
          40 kB
        12. screenshot-6.png
          screenshot-6.png
          145 kB
        13. screenshot-7.png
          screenshot-7.png
          39 kB

        Issue Links

          Activity

            People

              axel Axel Schwenke
              lujinke Luke
              Votes:
              0 Vote for this issue
              Watchers:
              6 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.