mysql innodbmaxdirtypagespct_关于innodb_max_dirty_pages_pct选项

最近在看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