mysql - MySQL 是否以某种方式存储最后一个查询？

Question

在使用 MySQL 和一些真正的“性能贪婪查询”时，我注意到，如果我运行这样的贪婪查询，可能需要 2 或 3 分钟才能完成计算。但是，如果我在第一次完成后立即重试查询，则只需要几秒钟。 MySQL 是否存储类似“最近的 x 个查询”之类的东西？

Answer 1

简短的回答是肯定的。有一个查询缓存。

The query cache stores the text of a SELECT statement together with the corresponding result that was sent to the client. If an identical statement is received later, the server retrieves the results from the query cache rather than parsing and executing the statement again. The query cache is shared among sessions, so a result set generated by one client can be sent in response to the same query issued by another client.

来自 here