innodb_change_buffer_max_size

With MySQL 5.6.2, you can set the maximum size of the change buffer as a percentage of the total size of the buffer pool using the innodb change buffer max size configuration option. The default value for innodb change buffer max size is 25. The maximum number of characters is 50.

On a MySQL server with a lot of insert, update, and delete activity, you might want to increase innodb change buffer max size so that change buffer merging keeps up with new change buffer entries and the change buffer doesn't hit its maximum size limit.

If the change buffer occupies too much of the shared memory space with the buffer pool, leading pages to age out of the buffer pool sooner than desired, you might want to reduce innodb change buffer max size on a MySQL server with static data used for reporting.

To get the best configuration, try different settings with a representative workload. The innodb change buffer max size setting is dynamic, so you can change it without having to restart the server.

Set to 25 to use up to 25% of the buffer pool to buffer changes. The default is 25, which is a reasonable quantity; if you want to increase it, simply increase the amount of RAM and the buffer pool size.