MySQL can speed the query phase using its query cache.
MySQL可以使用其查询缓存为查询阶段提速。
The catch, though, is that the query cache is disabled by default.
不过，问题是查询缓存在默认情况下是禁用的。
It's pointed out that a major design element for performance is the query cache.
需要指出的是关于性能的主要设计要素是查询缓存。
After you enable the query cache, it's important to understand whether it's being used effectively.
在启用查询缓存之后，重要的是要理解它是否得到了有效的使用。
For example, it doesn't have session cache, and nor does it interact with any second-level or query cache.
例如，它不需要会话缓存，也不和任何二级缓存或查询缓存有交互。
MySQL has a feature called the query cache that stores the result of a query in memory, should it be needed again.
MySQL有一个特性称为查询缓存，它将（后面会用到的）查询结果保存在内存中。
Initial execution of any query includes the costs of building up a query cache to enable faster execution of subsequent queries.
任何一个查询的首次执行都包含了构建一个查询缓存的性能损耗，以利于提高后续查询的执行速度。
It first invalidates the Query Cache.
它首先使查询缓存无效。
As a rule, if FLUSH QUERY cache takes a long time, the cache is too large.
作为一条规则，如果FLUSHQUERY CACHE占用了很长时间，那就说明缓存太大了。
The Query Service Caching section under the Configuration tab allows for manual Dynamic Query cache clearing and writing the cache state to file for one or more server groups.
Configuration选项卡下的QueryServiceCaching部分允许手动清理Dynamic Query缓存并为一个或多个服务器组将缓存状态写到文件上。
mytop also provides real-time and historical data about key-buffer and query-cache efficiency, and statistics about the queries being run.
mytop还提供了一个有关关键字缓冲区和查询缓存效率的实时数据和历史数据，以及有关正在运行的查询的统计信息。
mytop also provides real-time and historical data about key-buffer and query-cache efficiency, and statistics about the queries being run.
mytop还提供了一个有关关键字缓冲区和查询缓存效率的实时数据和历史数据，以及有关正在运行的查询的统计信息。
应用推荐