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

InnoDB performance regression for write-heavy workloads

    XMLWordPrintable

Details

    Description

      Write-heavy benchmarks show a regression in latency and throughput for latest releases in the 10.2, 10.3 and 10.4 series.

      Example:

      ----------------------------------------------------------------------------
      		 
      Test 't_oltp-innodb-multi' - sysbench OLTP read/write
      		 
      32 InnoDB tables with 10 mio rows total
      		 
      numbers are queries per second
      		 
       
      		 
      #thread count           1       8       16      32      64      128     256
      		 
      mariadb-10.2.32         5262.8  28886   53535   95712   158049  189909  192668
      		 
      mariadb-10.2.33         4866.7  22651   42352   78750   133580  173461  191125
      		 
       
      		 
      mariadb-10.3.23         5126.4  28716   52785   95466   156936  185473  187136
      		 
      mariadb-10.3.24         4772.0  22959   42713   80442   133492  171252  186200
      		 
       
      		 
      mariadb-10.4.13         5015.7  28263   52033   93771   154690  178179  178076
      		 
      mariadb-10.4.14         4980.9  23496   43145   79795   128977  166470  179285

      I examined this more closely for 10.2, bisecting the commits between 10.2.32 and 10.2.33. The first faulty commit is 

      commit fe39d02f51b96536dccca7ff89faf05e13548877
      		 
      Author: Thirunarayanan Balathandayuthapani <thiru@mariadb.com>
      		 
      Date:   Thu Jul 23 16:23:20 2020 +0530
      		 
       
      		 
       MDEV-20638 Remove the deadcode from srv_master_thread() and srv_active_wake_master_thread_low()

      Attachments

        1. 10.2.bad.svg
          700 kB
        2. 10.2.good.svg
          684 kB
        3. 10.2.pdf
          21 kB
        4. 10.2-2nd.pdf
          22 kB
        5. 10.2-binlog.png
          10.2-binlog.png
          11 kB
        6. 10.2-binlog4.png
          10.2-binlog4.png
          9 kB
        7. 10.2-binlog-revert.png
          10.2-binlog-revert.png
          11 kB
        8. 10.2-revert.pdf
          23 kB
        9. 10.3.pdf
          20 kB
        10. 10.4.pdf
          21 kB
        11. 10.5-2nd.pdf
          20 kB
        12. 10.5-4th.pdf
          21 kB
        13. MDEV-23475.png
          MDEV-23475.png
          6 kB
        14. MDEV-23475-final.pdf
          86 kB

        Issue Links

          is caused by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-20638 Remove the deadcode from srv_master_thread() and srv_active_wake_master_thread_low()

          • Major - Major loss of function.
          • Closed

          Activity

            People

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