[MDEV-18912] Decrease in insert performance from MariaDB 10.2.22 to 10.3.13 Created: 2019-03-13  Updated: 2021-09-16  Resolved: 2021-09-16

Status: Closed
Project: MariaDB Server
Component/s: Server
Affects Version/s: 10.3.13
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Pedro Albuquerque Assignee: Axel Schwenke
Resolution: Won't Fix Votes: 0
Labels: need_verification

Attachments: PNG File mariadb_10.2.22.png     PNG File mariadb_10.2_cpu.png     PNG File mariadb_10.3.13.png     PNG File mariadb_10.3_cpu.png    

 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!

 Comments   
Comment by Pedro Albuquerque [ 2019-03-14 ]

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

Comment by Axel Schwenke [ 2021-09-16 ]

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

Generated at Thu Feb 08 08:47:40 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.