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.

  • Is it slower for your transactions and queries? How many xacts/sec and qps does your app run? How much RAM on the box? Did you also test MariaDB?
    – Rick James


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.