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

This entry was posted in Computer, Database, Murmuring, MySQL, Network, Software and tagged , , , , , , , . Bookmark the permalink.

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

  1. Kyle Tse says:

    原文作者都應該寫錯了,應該是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. Gea-Suan Lin says:

    因為之前有 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 *