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

Decrease in insert performance from MariaDB 10.2.22 to 10.3.13

    XMLWordPrintable

Details

    Description

      I am doing some sysbench tests on an EC2 instance. Below are the sysbench server configs:

      • c5.18xlarge
      • sysbench v1.0.11
      • oltp_read_write.lua
      • 32 tables
      • 32 threads
      • 50M rows each table
      • 1PK + 1 sec index / table

      The DB server is a standalone EC2 r5.12xlarge:

      • ubuntu 18.04
      • 280G innodb buffer pool size
      • innodb log file size: 2x3G
      • 10.2.22 OR 10.3.13 (changed on each run)
      • performance schema on

      During the sysbench initial load, MariaDB 10.2.22 performs much better than 10.3.13:

      • 78 minutes on MariaDB 10.2.22
      • 103 minutes on MariaDB 10.3.13

      According to the screenshots attached, there is some degradation on binlog write IO.

      Do you know of any degradation on MariaDB 10.3 version?

      Thanks!

      Attachments

        1. mariadb_10.2.22.png
          mariadb_10.2.22.png
          259 kB
        2. mariadb_10.3.13.png
          mariadb_10.3.13.png
          290 kB
        3. mariadb_10.2_cpu.png
          mariadb_10.2_cpu.png
          106 kB
        4. mariadb_10.3_cpu.png
          mariadb_10.3_cpu.png
          110 kB

        Activity

          People

            axel Axel Schwenke
            pedroalb Pedro Albuquerque
            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.