The Query Cache的意思|示意

After you enable the query cache, it's important to understand whether it's being used effectively.

在启用查询缓存之后，重要的是要理解它是否得到了有效的使用。

MySQL has a feature called the query cache that stores the result of a query in memory, should it be needed again.

MySQL 有一个特性称为查询缓存，它将（后面会用到的）查询结果保存在内存中。

From here on out, until the cache expires, you will be able to fetch the result array directly out of cache, skipping over the SQL query.

从这里开始，直到缓存到期，您就能够直接从缓存中获取结果数组，跳过SQL查询。

Initial execution of any query includes the costs of building up a query cache to enable faster execution of subsequent queries.

任何一个查询的首次执行都包含了构建一个查询缓存的性能损耗，以利于提高后续查询的执行速度。

The sequence I follow when performing reads is to take a request (that requires a database query) from the Web tier and check the cache for previously stored results of that query.

我执行读取操作的顺序是从web层获取请求(需要执行一次数据库查询)并检查之前在缓存中存储的查询结果。

The Dynamic Query Mode must determine whether a result can be stored in the cache using a number of data points collected at runtime.

Dynamic Query Mode必须确定一个结果是否可以使用在运行时收集的大量数据点存储到缓存中。