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%。