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

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

          Ascending order - Click to sort in descending order
          pedroalb Pedro Albuquerque created issue -
          pedroalb Pedro Albuquerque made changes -
          Field Original Value New Value
          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.3.13
          - 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!           		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!
          elenst Elena Stepanova made changes -
          Fix Version/s 10.3 [ 22126 ]
          Assignee Axel Schwenke [ axel ]
          Labels need_verification
          pedroalb Pedro Albuquerque made changes -
          Attachment mariadb_10.2_cpu.png [ 47819 ]
          Attachment mariadb_10.3_cpu.png [ 47820 ]
          pedroalb Pedro Albuquerque added a comment -

          I also noticed that CPU usage on running same sysbench on MariaDB 10.3.13 is higher than running it on MariaDB 10.2.22

          pedroalb Pedro Albuquerque added a comment - I also noticed that CPU usage on running same sysbench on MariaDB 10.3.13 is higher than running it on MariaDB 10.2.22
          serg Sergei Golubchik made changes -
          Fix Version/s 10.4 [ 22408 ]
          axel Axel Schwenke added a comment -

          10.2 and 10.3 are very old. If the problem persists with a newer version, please open a new Jira ticket.

          axel Axel Schwenke added a comment - 10.2 and 10.3 are very old. If the problem persists with a newer version, please open a new Jira ticket.
          axel Axel Schwenke made changes -
          Fix Version/s N/A [ 14700 ]
          Fix Version/s 10.3 [ 22126 ]
          Fix Version/s 10.4 [ 22408 ]
          Resolution Won't Fix [ 2 ]
          Status Open [ 1 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 93249 ] MariaDB v4 [ 155916 ]

          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.