Compare application hit ratio of databases.
比较数据库的应用程序命中率。
Compare application hit ratio of buffer pools.
比较缓冲池的应用程序命中率。
Pay close attention to your overall buffer pool hit ratio.
密切关注您的总体缓冲池命中率。
The buffer pool hit ratio is now showing excellent results.
现在的缓冲池命中率就显示了较好的结果。
The above example shows a good buffer pool hit ratio of 98.4%.
以上示例显示了98.4%的良好缓冲池命中率。
A well-tuned system can easily have a hit ratio well above 90%.
一个良好调优的系统可以轻松实现远高于90%的命中率。
In general, a buffer pool hit ratio above 80% is considered good.
一般情况下,缓冲池命中率在80%以上就认为是良好的。
Dbrun.snap - This script provides the hit ratio for the package cache.
perl packhitratio . pl dbrun. snap——该脚本提供了包缓存器的命中率。
Dbrun.snap - This script provides the hit ratio for the catalog cache.
perl cathitratio . pl dbrun. snap——该脚本提供了目录缓存器的命中率。
Catalog cache hit ratio can be calculated by using the following formula.
可使用下列公式计算目录缓存器的命中率。
Take a new snapshot, and calculate the new bufferpool hit ratio as follows
获取新的快照,并计算新的缓冲池命中率,如下
The package cache hit ratio can be calculated using the following formula.
可使用下列公式计算包缓存器的命中率。
The query returns only the buffer pools that have a lower hit ratio than 90%.
该查询只返回命中率低于90%的缓冲池。
The buffer pool hit ratio = (1 - (1838 + 50) / (269482 + 82)) * 100% = 99.29%
缓冲池命中率 = (1- (1838 +50) / (269482 + 82)) * 100% = 99.29%
The buffer pool hit ratio = (1- (273548 + 52) / (183925 + 82)) * 100% = 48.69%
缓冲池命中率 = (1- (273548 +52) / (183925 + 82)) * 100% = 48.69%
A smaller hit ratio indicates that the pckcachesz parameter should be increased.
较小的命中率表明应该增大参数pckcachesz。
Package and catalog caches, and workspaces (for example, package cache hit ratio)
包与目录缓存,以及工作空间(如包高速缓冲区命中率)。
Use one buffer pool, but increase its size until the index hit ratio stops increasing.
使用一个缓冲池,但是增加其大小直至索引命中率停止增长。
Figure 3 shows the hit ratio highlighted in red, which indicates a performance problem.
图3用红色高亮显示了命中率,这表示存在性能问题。
For certain workloads cache hit ratio is lower than would justify having it enabled.
在一定的负载压力下,如果缓存命中率太低了,就启用它。
If the hit ratio is low, increasing the number of buffer pool pages may improve performance.
如果命中率较低,则可以增加缓冲池页数来提高性能。
Dbrun.snap - This script provides the hit ratio for the data and index pages of every buffer pool.
perl buffhitratio . pl dbrun. snap——该脚本提供了每个缓冲池的数据和索引页命中率。
A desirable goal for your buffer pool hit ratio is 80% or higher for data, and 90% or higher for index.
您的缓冲池命中率的理想目标是数据80%或更高,索引90%或更高。
The hit ratio is a function of the cache size, the amount of underlying data, and the data access pattern.
命中率与缓存大小、底层数据的数量和数据访问模式有关。
The fewer pages would mean that the TLB process would have a higher hit ratio and therefore improved performance.
页数越少,意味着TLB进程将具有更高的命中率,因而性能更好。
With the buffer pool size of 250 pages, the application test run experienced very poor buffer pool hit ratio of 48.69%.
通过250个页面的缓冲池大小,应用程序测试运行呈现了48.69%的糟糕的缓冲池命中率。
The cache hit ratio tells you the percentage of times you are performing a get versus the number of times that get misses.
缓存命中率表示执行get的次数与错过get的次数的百分比。
Lower bounded indicators are identified as unhealthy as they decrease in value (for example, the cache hit ratio indicator).
当设有下界的指示器(例如,缓存命中率指示器)的值降低时,它将标识为不健康。
If necessary, you can separate data and index into two different buffer pools to help ensure a good index buffer pool hit ratio.
如果必要,可以将数据和索引分隔到两个不同的缓冲池中,以帮助确保一个良好的索引缓冲池命中率。
Check that the cache size is sufficiently large and that the cache hit ratio is high for each of the dynamic SQL statements being executed.
对于每个被执行的动态sql语句,请检查高速缓存是否足够大且高速缓存的命中率是否较高。
应用推荐