buffer pool hit ratio的意思|示意
缓冲池命中率
buffer pool hit ratio的网络常见释义
缓冲池命中率 ...第16章优化器与功能调优16.1优化器简介16.2功能调优简介16.2.1索引16.2.2排序16.3KPI16.3.1缓冲池命中率(bufferpool hit ratio)16.3.2无效索引读16.3.3包缓存命中率 (package cache hit ratio)16.3.4均匀后果集大小16.3.5同步读取比例16.3.6数据、索引页肃...
buffer pool hit ratio相关例句
The buffer pool hit ratio = (1 - (1838 + 50) / (269482 + 82)) * 100% = 99.29%
缓冲池命中率 = (1 - (1838 + 50) / (269482 + 82)) * 100% = 99.29%
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.
使用一个缓冲池,但是增加其大小直至索引命中率停止增长。
The above example shows a good buffer pool hit ratio of 98.4%.
以上示例显示了98.4%的良好缓冲池命中率。
Obviously, with availability of physical memory on the database server, a high buffer pool hit ratio is always better for your database performance.
显然,随着数据库服务器上物理内存的使用,高缓冲池命中率对于您的数据库性能而言始终比较好。
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%。