MySQL 5.6/5.7/5.8 在 single thread 時的效能比較

作者 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 時的情境最佳化...

2 thoughts on “MySQL 5.6/5.7/5.8 在 single thread 時的效能比較”

  1. 原文作者都應該寫錯了,應該是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

  2. 因為之前有 5.8 改成 8.0 的事情,所以有時候會混用 (雖然這樣不太好 XD):https://www.percona.com/blog/2016/07/05/mysql-8-0/

Leave a Reply

Your email address will not be published. Required fields are marked *