MySQL 8 Vs 9 Performance Benchmark

MySQL Performance Benchmark 8 Vs 9

MySQL has just released a new innovation release 9 which it claims to add a lot many exciting features like Vector Datatype, Inline and Implicit Foreign Keys, Javascript Stored Programs, etc.

But as I never use JSON or Vector datatype so I was more interested in the performance change in normal CRUD operations in the new version.

So, I setup a sysbench benchmark on my laptop and did a performance benchmark on both the versions and came up with interesting results.

Below is the sysbench command that was used in the benchmark below:

sysbench oltp_read_write \
    --mysql-host=127.0.0.1 \
    --mysql-user=root \
    --mysql-password=root \
    --mysql-db=testdb \
    --table-size=10000 \
    --threads=10 \
    run

Below are the results:

Mysql Benchmark 8 Vs 9 (Queries/Transactions per second)

Mysql Benchmark 8 Vs 9 (Total Transactions)

Mysql Benchmark 8 Vs 9 (Total Reads/Writes/Others and Total Queries)

The newer version is almost 40% faster in almost all READ, WRITE and UPDATE operations. The newer version already claims to be faster in GROUPBY queries but sadly our benchmark software doesn’t offer any method to test them.