It first invalidates the Query Cache.
它首先使查询缓存无效。
MySQL can speed the query phase using its query cache.
MySQL可以使用其查询缓存为查询阶段提速。
The catch, though, is that the query cache is disabled by default.
不过，问题是查询缓存在默认情况下是禁用的。
As a rule, if FLUSH QUERY cache takes a long time, the cache is too large.
作为一条规则，如果FLUSHQUERY CACHE占用了很长时间，那就说明缓存太大了。
In aspect of data querying, it proposed optimized strategy of fast 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.
任何一个查询的首次执行都包含了构建一个查询缓存的性能损耗，以利于提高后续查询的执行速度。
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缓存并为一个或多个服务器组将缓存状态写到文件上。
Using correlative query cache to replace tradition cache, the article designs and implements the cache structure, query matching, strategy of consistency and strategy of replacement.
设计使用基于查询相关查询的缓存代替传统缓存，对于缓存的结构、查询匹配、一致性维护策略及替换策略均作了详细设计。
Example 2: you have a "last_login" field in your table. It updates every time a user logs in to the website. But every update on a table causes the query cache for that table to be flushed.
例2：一家包括“最后登录”字段的用户表，用户每登录网站都会要更新，而每次对表的更新都会导致这个表的查询缓存要刷新。
To speed this up, you can cache the results from a search query and use these cached results whenever a user submits a query.
为了提速，您可以高速缓存从搜索查询得到的结果，然后在用户每次提交查询时使用这些缓存的结果。
Moreover, if you decided to cache based on the individual unique parts of a SOAP envelope, there is no way to indicate if the query is suitable for such caching.
此外，如果您决定在一个SOAP信封单独的、唯一的部分的基础上进行高速缓存，那么没什么办法来表明这个查询是否适于这种高速缓存。
Other functions that are standardized in JPA 2.0 are a level 2 cache plug-in, as well as query hints (also known as access intents).
JPA 2.0中标准化的其他功能包括二级缓存插件和查询提示(也称为访问意图)。
Only if a cached copy cannot be found or has expired is the YQL query executed, and the results again are saved to the cache for future use.
仅当无法找到缓存副本或缓存副本过期时才执行YQL查询，结果再次保存到缓存以备将来使用。
Since MQTs are local tables that cache the results of a query, the same considerations for creating an index on a local table apply to creating indexes on MQTs.
因为MQT是缓存查询结果的本地表，所以在本地表上创建索引的相同步骤也可应用于在 MQT 上创建索引。
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查询。
Now let us discuss the issue with the query optimization for the objects which are configured for second level cache.
现在我们来谈谈关于二级缓存的查询优化问题。
Once the MQT is created, it needs to be populated with data to reflect the results of the query that the MQT is supposed to cache.
一旦创建了MQT，就需要用数据填充它，以反映MQT将缓存的查询结果。
The cache caches the results of any particular query for two hours.
任何查询结果都能缓存两个小时。
Materialized Query Tables (MQTs), formerly known as Automatic Summary Tables (ASTs), can be defined to locally cache the result of queries that reference relational and non-relational nicknames.
可以通过定义物化查询表(Materialized QueryTables, MQT)——以前称为自动总结表(Automatic Summary Tables,AST)——来在本地缓存引用关系和非关系昵称的查询的结果。
The Dynamic Query Mode must determine whether a result can be stored in the cache using a number of data points collected at runtime.
DynamicQueryMode必须确定一个结果是否可以使用在运行时收集的大量数据点存储到缓存中。
Nicknames do not support triggers, nor do the Materialized Query Tables (MQTs) sometimes used to cache federated data.
昵称不支持触发器，也不支持物化查询表（Materialized Query Table，MQT，有时用来缓存联邦数据）。
Another option is to use Query Tuner to capture statements from the statement cache and to view the statement runtime information, as shown in Figure 7.
另一个选择是使用QueryTuner从状态缓存获取状态，并查看状态运行时信息，如图7所示。
SQE is the strategic query engine on DB2 for I, with better performance, scaling and tooling such as the SQL Plan Cache.
SQE是DB 2fori上的战略性查询引擎，具有更好的性能、可伸缩性和工具，例如SQLPlanCache。
mytop also provides real-time and historical data about key-buffer and query-cache efficiency, and statistics about the queries being run.
mytop还提供了一个有关关键字缓冲区和查询缓存效率的实时数据和历史数据，以及有关正在运行的查询的统计信息。
Using an Ontology Web Language (OWL) defined query, you can preload the cache with regularly used queries that are made on broker startup.
使用通过本体Web语言(Ontology Web Language,OWL)定义的查询，您可以将代理启动时经常使用的查询预加载到缓存中。
In addition the Dynamic Query Mode contains a fine grained metadata and cell data cache which is trickle fed and a higher cache hit ratio than was previously possible.
此外，DynamicQueryMode包含一个细粒度元数据和单元数据缓存(即一个trickle fed)以及一个比以前更高的缓存命中率。
In addition the Dynamic Query Mode contains a fine grained metadata and cell data cache which is trickle fed and a higher cache hit ratio than was previously possible.
此外，DynamicQueryMode包含一个细粒度元数据和单元数据缓存(即一个trickle fed)以及一个比以前更高的缓存命中率。
应用推荐