最近在看mysql performance这本书,其中有一段话讲到 innodb_max_dirty_pages_pct,有点不太明白,希望大家指教:
原文:
You can tweak the threshold for your workload if you wish to spread out the writes a
bit more. For example, lowering it to 50 will generally cause InnoDB to do more write
operations, because it will flush pages sooner and therefore be unable to batch the
writes as well. However, if your workload has a lot of write spikes, using a lower
value may help InnoDB absorb the spikes better: it will have more “spare” memory to
hold dirty pages, so it won’t have to wait for other dirty pages to be flushed to disk.为什么降低nnodb_max_dirty_pages_pct会增加写操作
原文:
You can tweak the threshold for your workload if you wish to spread out the writes a
bit more. For example, lowering it to 50 will generally cause InnoDB to do more write
operations, because it will flush pages sooner and therefore be unable to batch the
writes as well. However, if your workload has a lot of write spikes, using a lower
value may help InnoDB absorb the spikes better: it will have more “spare” memory to
hold dirty pages, so it won’t have to wait for other dirty pages to be flushed to disk.为什么降低nnodb_max_dirty_pages_pct会增加写操作
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货