作者 Mark Callaghan 在討論 MySQL 在量小的時候,新版可能反而比舊版慢:「The history of low-concurrency performance regressions in MySQL 5.6, 5.7 and 5.8」。
One example of the regression occurs for in-memory sysbench where MySQL 5.7 and MySQL 8 get 60% to 70% of the QPS compared to 5.6, which is the same as writing that 5.6 gets 1.43X to 1.67X more QPS than MySQL 5.7 and MySQL 8.
其實不算太意外,因為功能愈來愈多,而且最佳化的重心都放在用量大的各種情境下。並沒有針對 single thread 時的情境最佳化...
原文作者都應該寫錯了,應該是8,不是5.8,他標題寫5.8,但內文資料寫8。
May 2017 - Sysbench, IO-bound & Intel NUC for MySQL 5.6, 5.7 & 8
June 2017 - Insert benchmark, in-memory & Intel NUC for MySQL 5.6, 5.7 and 8
因為之前有 5.8 改成 8.0 的事情,所以有時候會混用 (雖然這樣不太好 XD):https://www.percona.com/blog/2016/07/05/mysql-8-0/