Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Compared with MySQL8, under high concurrency, Percona has performance degradation

Description

In the performance test compared with MySQL8.0.30, we found that .0.30 has performance degradation under high concurrency, and similar problems also exist in lower versions of .0.

The test environment is as follows:

instance type:  r6i.2xlarge

EBS:

     /data:   300GB 4000IOPS 300MB/s throughput

    /logs(binlog,relaylog): 400GB 3000IOPS 250MB/s throughput

Topology: 1 Source+1 Replica
sysbench: (Same AZ as Source but different EC2 instances)  
sysbench  threads: 16, 32, 64, 128, 256, 512

sysbench command:

 

The comparison of MySQL Command is as follows:

MySQL-8.0.30

.0.30

 

my.cnf

 

Environment

OS kernel:  4.14.296-222.539.amzn2.x86_64

Attachments

3

Activity

Aaditya Dubey June 27, 2023 at 1:09 PM

Hi ,

We still haven't heard any news from you. So I assume issue is not persists anymore. If you disagree just reply and create a follow-up report.

Aaditya Dubey April 5, 2023 at 2:55 PM

Hi ,

Thank you for the report.
Please check comment's and let us know.

Przemyslaw Skibinski March 1, 2023 at 11:05 AM

Hey,
1. Was all (master + replica + sysbench) run on a single instance?
2. r6i.2xlarge has 8 vCPU/threads and 64 GB RAM so I would expect some performance issues using too many (32, 64, 128, 256, 512) threads. Please keep in mind that `r6i.2xlarge` is a virtual machine that may depend on load of other VM machines on the same hardware. Have the tests been repeated? In the next run .0.30 may be faster than MySQL-8.0.30.

Incomplete

Details

Assignee

Reporter

Needs QA

Yes

Affects versions

Priority

Smart Checklist

Created November 29, 2022 at 3:16 AM
Updated March 6, 2024 at 9:54 AM
Resolved June 27, 2023 at 1:09 PM