This blog will look at MySQL 5.7 sysbench OLTP read-only results to determine if they are faster than previous versions.
As promised in my previous post, I have checked MySQL 5.7 performance against previous versions in a different workload. This time, I will use sysbench OLTP read-only transactions (read-write transactions are part of future research, as there is more tuning required to get the best performance in write workloads).
One important thing to mention is that MySQL 5.6 and 5.7 have
special optimizations for READ-ONLY transactions. In MySQL 5.6,
however, you need to start a transaction with
"START TRANSACTION READ ONLY" to get the …