content_image/844492.jpg content_image/844493.jpg content_image/844494.jpg
<img src='content_image/844492.jpg'>

Maximum size for the InnoDB  change buffer, as a percentage of the total size of the buffer pool. You might increase this value for a MySQL server with heavy insert, update, and delete activity, or decrease it for a MySQL server with unchanging data used for reporting. For more information, see Section 15.5.2, “Change Buffer” . For general I/O tuning advice, see Section 8.5.8, “Optimizing InnoDB Disk I/O” . 

• innodb_change_buffering 

<img src='content_image/844493.jpg'>

Whether InnoDB  performs change buffering, an optimization that delays write operations to secondary indexes so that the I/O operations can be performed sequentially. Permitted values are described in the following table. Values may also be specified numerically. 

<img src='content_image/844494.jpg'>

