I am testing the performance of MySQL 5.7.42 vs. MySQL 8.0.33 on Ubuntu 22.04 (amd64). Each of the test is using their own AWS EC2 instance (t2.2xlarge which has 8 core/32 GB). I ran a simple sysbench (1.0.20 version) test like this:
sysbench oltp_read_write --table-size=100000 ... prepare
sysbench oltp_read_write --table-size=100000 --threads=4 --max-requests=0 --time=30 ... run
| MySQL 5.7.42 | MySQL 8.0.33 (stock) | MySQL 8.0.33 (config change) | |
|---|---|---|---|
| transactions/sec | 483.60 / sec | 306.87 / sec | 389.31 / sec |
| queries/sec | 9671.90 / sec | 6137.38 / sec | 7786.80 / sec |
Just to clarify on the 2 columns on MySQL 8.0.33, the (stock) means there is no configuration change, while the (config change) means I added the "skip-log-bin" in my.cnf.
Based on the result, MySQL 8.0 seems to be slower than 5.7. I am not sure why this is the case. Has anyone seen something similar to this?
Also, I wonder if it is related to these bugs. MySQL Bug 108430 or MySQL Bug 93734 ?
By the way, I can give more details (eg. commands that I used, full output of Sysbench, etc.) that I used if that helps.
