比较缓冲池的应用程序命中率。
可使用下列公式计算包缓存器的命中率。
The package cache hit ratio can be calculated using the following formula.
现在的缓冲池命中率就显示了较好的结果。
该查询只返回命中率低于90%的缓冲池。
The query returns only the buffer pools that have a lower hit ratio than 90%.
可使用下列公式计算目录缓存器的命中率。
Catalog cache hit ratio can be calculated by using the following formula.
例如,使用此关联会产生较高的缓存命中率。
For example, with this affinity there would be a higher cache-hit rate.
获取新的快照,并计算新的缓冲池命中率,如下
Take a new snapshot, and calculate the new bufferpool hit ratio as follows
4分,7.3板,1.4冒57.7%命中率。
4 points, 7.3 boards 1.4 blocks, and 57.7 percent shooting from the floor.
图3用红色高亮显示了命中率,这表示存在性能问题。
Figure 3 shows the hit ratio highlighted in red, which indicates a performance problem.
如果命中率较低,则可以增加缓冲池页数来提高性能。
If the hit ratio is low, increasing the number of buffer pool pages may improve performance.
较小的命中率表明应该增大参数pckcachesz。
A smaller hit ratio indicates that the pckcachesz parameter should be increased.
为数据分区设计相应的方法,以尽可能地增大缓存命中率。
Devising methodologies for partitioning the data to maximize cache hits.
命中率与缓存大小、底层数据的数量和数据访问模式有关。
The hit ratio is a function of the cache size, the amount of underlying data, and the data access pattern.
使用一个缓冲池,但是增加其大小直至索引命中率停止增长。
Use one buffer pool, but increase its size until the index hit ratio stops increasing.
他也在小前锋球员效率榜上排名前五,而且引领着投射命中率。
He's top five in per among similar small forwards and leads that group in true shooting percentage.
图13 - 15使用定量的模型说明了较高缓存命中率的好处。
Figures 13-15 illustrate the advantages of higher cache hits with a quantitative model.
提高tlb命中率可以提高CP i度量,从而也提高程序的性能。
An increase in TLB hit rate improves the CPI metric and, therefore, performance of that program.
页数越少,意味着TLB进程将具有更高的命中率,因而性能更好。
The fewer pages would mean that the TLB process would have a higher hit ratio and therefore improved performance.
近缓存中缓存命中率逐渐增加,其效果是数据访问时间提高了 42%。
The effect of increasing the probability of a cache hit in the near cache is a 42% improvement in data access time.
您的缓冲池命中率的理想目标是数据80%或更高,索引90%或更高。
A desirable goal for your buffer pool hit ratio is 80% or higher for data, and 90% or higher for index.
两人都有超过50%的有效投篮命中率以及明显高过刘易斯的篮板效率。
Each has a true shooting percentage in the high 50s and both have a dramatically higher rebound rate than Lewis.
毕竟,詹姆斯在场均得分、篮板、投篮命中率比罗斯要高一些。
After all, James averages more points, rebounds and shoots a better field goal percentage than Rose.
它们返回高命中率sql语句,例如耗用排序时间最多的语句。
They return heavy hitter SQL statements, for example, the statement that consumed the most sort time.
读命中率应超过 99%,写缓存命中率最好达到 95% 左右。
Read cache hits should be in excess of 99 percent, and we would like write cache hits to be above 95 percent.
在进行性能测试时,若能看到用户、SQL、缓冲池命中率等,无疑更为有趣。
When doing the performance testing, it becomes much more interesting to see users, SQL, buffer pool hit rates, etc.
由于我们一遍又一遍地顺序扫描一个巨大的表,这样我们就无法关注读缓存命中率。
We cannot pay attention to read cache hit rate since we have been sequentially scanning a huge table over and over.
如果他的防守和罚球命中率能够有所提高的话,他绝对会成为NBA中最好的球员。
Should his defense and free throw shooting improve to anywhere north of average, he'll have an argument to be the best player in the NBA.
缓存的有效性与命中率成正比关系,命中率是缓存中的项能满足请求的比例。
The effectiveness of the cache is directly proportional to the hit ratio, which is the percentage of requests satisfied by having the item in the cache.
使用这个模型,您可以对较高近距离缓存命中率对平均数据访问时间造成的影响进行模拟。
With this model, you can simulate the effects a higher near-cache hit will have on the average data access time.
您可以使用快照来获得诸如缓冲池命中率、排序堆溢出的次数以及系统工作负载之类的信息。
You can use the snapshot report to derive information such as the buffer pool hit ratio, amount of sort heap overflows, and the system workload.
应用推荐