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. MDEV-23017.pdf
          29 kB
        2. range_distinct.png
          range_distinct.png
          5 kB
        3. range_ordered.png
          range_ordered.png
          5 kB
        4. range_simple.png
          range_simple.png
          5 kB
        5. range_sum.png
          range_sum.png
          5 kB
        6. simpe_range4.png
          simpe_range4.png
          4 kB

          Issue Links

            Activity

              People

              Assignee:
              marko Marko Mäkelä
              Reporter:
              axel Axel Schwenke
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: