Bug #102250 MGR 8.0 periodic performance degradation

• Submitted: 15 Jan 2021 3:24
• Modified: 18 Jan 2021 12:08
• Reporter: ping xia
• Status: Not a Bug
• Category: MySQL Server: Group Replication
• Severity: S3 (Non-critical)
• Version: 8.0.22
• OS: CentOS (CentOS Linux release 7.5.1804 (Core) )
• Assigned to: MySQL Verification Team
• CPU Architecture: Any

[15 Jan 2021 3:24] ping xia

Description:

32 threads, average tps is 3792, 101s is reduced to 1658, 161s is 1224, about 60s once

How to repeat:
sysbench ： 
/usr/bin/sysbench  /usr/share/sysbench/oltp_read_write.lua --db-driver=mysql --events=$events --threads=$threads --time=$time --mysql-host=$host --mysql-user=$user --mysql-password=$password --mysql-port=$port --report-interval=1  --tables=$tables --table-size=$table_size --rate=$rate  --mysql-ignore-errors=all run

[15 Jan 2021 3:26] ping xia

sysbench.log

Attachment: sysbench.log (application/octet-stream, text), 74.99 KiB.

[18 Jan 2021 12:08] MySQL Verification Team

Hi,

Thanks for the report. We are constantly working on improving performance of all our products as there can always be more performance and more consistent performance but this is not a bug. 

kind regards
Bogdan