Hit Ratio = 1 – (physical reads/(db block gets + consistent gets))在凌晨时很少人进行操作,但BUFFER命中率却非常低,这也不能说明什么问题,而且也没什么关系
如果你觉得有必要调整:
Tuning goals:
– Servers find data in memory
– 90% hit ratio for OLTPTuning techniques:
– Increase buffer cache size
– Use multiple buffer pools
– Cache tables
– Bypass the buffer cache for sorting and parallel
reads
如果你觉得有必要调整:
Tuning goals:
– Servers find data in memory
– 90% hit ratio for OLTPTuning techniques:
– Increase buffer cache size
– Use multiple buffer pools
– Cache tables
– Bypass the buffer cache for sorting and parallel
reads
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货