最近在看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会增加写操作
作者: rj03hou
发布时间: 2010-10-13