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.