-
Inaam Rana authored
rb://593 approved by: Marko 1) Make ibuf size configurable. Current behavior is to have a maximum on-disk size equal to half the buffer pool size. This patch introduces a new parameter: innodb_change_buffer_max_size = default 25, min 0, max 50. Value means %age of buffer pool size. Dynamic. 2) Make ibuf merge more aggressive: * upto ibuf::size < ibuf::max_size / 2, merge at PCT_IO(5) same as current. And should be good for most of the workloads. * when ibuf::size > ibuf::max_size / 2, merge at PCT_IO(5) + PCT_IO(excess difference in % of max_size)
Inaam Rana authoredrb://593 approved by: Marko 1) Make ibuf size configurable. Current behavior is to have a maximum on-disk size equal to half the buffer pool size. This patch introduces a new parameter: innodb_change_buffer_max_size = default 25, min 0, max 50. Value means %age of buffer pool size. Dynamic. 2) Make ibuf merge more aggressive: * upto ibuf::size < ibuf::max_size / 2, merge at PCT_IO(5) same as current. And should be good for most of the workloads. * when ibuf::size > ibuf::max_size / 2, merge at PCT_IO(5) + PCT_IO(excess difference in % of max_size)
Loading