The hit ratios for data and index pages reflect the number of times a page request was handled by the buffer pool directly without requiring disk I/O.
数据和索引页面的击中率反映了缓冲池在不需要磁盘I/O的情况下直接处理一个页面请求的时间量。
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%的糟糕的缓冲池命中率。
Use one buffer pool, but increase its size until the index hit ratio stops increasing.
使用一个缓冲池，但是增加其大小直至索引命中率停止增长。
When multiple buffer pools are in use, the buffer pool snapshot data can be used to calculate the buffer pool hit ratio of each pool to indicate the effectiveness of each buffer pool.
当多个缓冲池同时在用时，缓冲池快照数据可用于计算每个缓冲池的命中率，来表示每个缓冲池的有效性。
Obviously, with availability of physical memory on the database server, a high buffer pool hit ratio is always better for your database performance.
显然，随着数据库服务器上物理内存的使用，高缓冲池命中率对于您的数据库性能而言始终比较好。
Rather than accepting the performance hit, clients can request objects from a pool and then return them to the pool after finishing their use case.
客户机可以不接受性能命中，而从池中请求对象，然后在用完之后将其返回池中。
If your system has a low buffer pool hit ratio, you can increase the buffer pool size further to achieve better application performance result.
如果您的系统具有较低的缓冲池命中率，您就可以通过增加缓冲池大小来进一步地取得更好的应用程序性能结果。
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.
您可以使用快照来获得诸如缓冲池命中率、排序堆溢出的次数以及系统工作负载之类的信息。
The buffer pool hit ratio is now showing excellent results.
现在的缓冲池命中率就显示了较好的结果。
As a result, compression allows more data to be in memory than without compression, which increases the buffer-pool hit ratio and makes higher utilization of the available memory.
因此，相比不压缩，压缩能让内存存储更多的数据，进而提高了缓冲池命中率和可用内存的利用率。
The above example shows a good buffer pool hit ratio of 98.4%.
以上示例显示了98.4%的良好缓冲池命中率。
When doing the performance testing, it becomes much more interesting to see users, SQL, buffer pool hit rates, etc.
在进行性能测试时，若能看到用户、SQL、缓冲池命中率等，无疑更为有趣。
If the hit ratio is low, increasing the number of buffer pool pages may improve performance.
如果命中率较低，则可以增加缓冲池页数来提高性能。
If you use multiple buffer pools, you might take the buffer pool hit ratio together with the buffer pool name from the PWH.BUFFERPOOL table.
若使用多个缓冲池，可能要从PWH . BUFFERpool表取得缓冲池命中率和缓冲池名称。
Dbrun.snap - This script provides the hit ratio for the data and index pages of every buffer pool.
perl buffhitratio . pl dbrun. snap——该脚本提供了每个缓冲池的数据和索引页命中率。
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%
Ideally this ratio should be over 95%, and as close to 100% as possible. To increase the buffer pool hit ration, try the following.
理想情况下，该比率应当超过95%，并尽可能接近100%。
As experts continue to study the science of risk-seeking, we'll continue to hit the mountains, the waves or the shallow end of the pool.
当专家继续研究追求冒险这一科学时，我们也会继续攀登高山，乘风破浪，或者只在泳池的浅水区徘徊。
Please swim along the white line, don't swim across the swimming pool otherwise you could hit somebody else.
请在游泳时按泳道来游，不要横穿泳池，那样会撞到别人。
Yeah, a a kid he he hit his head, and and he fell in the pool.
是，一个年轻人他撞到头，然后掉进游泳池里。
Yeah, a a kid he he hit his head, and and he fell in the pool.
是，一个年轻人他撞到头，然后掉进游泳池里。
应用推荐