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

range query performance regression in 10.5.4

    XMLWordPrintable

Details

    Description

      The regression test suite reports rather severe performance regressions in MariaDB 10.5.4 vs. 10.5.3. It looks like it is genuinely for the sysbench OLTP range queries. Example:

      Test 't_collate_distinct_range_utf8_general' - sysbench OLTP readonly
      selecting distinct rows from short range, collation utf8_general_ci
      1 table, 1 mio rows, engine InnoDB/XtraDB (builtin)
      numbers are queries per second
       
      #thread count           1       8       16      32      64      128     256
      mariadb-10.5.3          7840.1  53249   92616   149360  149130  149435  148546
      mariadb-10.5.4          7794.3  52208   91235   131122  137925  128168  94999
      

      Attachments

        1. simpe_range4.png
          simpe_range4.png
          4 kB
        2. range_sum.png
          range_sum.png
          5 kB
        3. range_simple.png
          range_simple.png
          5 kB
        4. range_ordered.png
          range_ordered.png
          5 kB
        5. range_distinct.png
          range_distinct.png
          5 kB
        6. MDEV-23017.pdf
          29 kB

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              axel Axel Schwenke
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.