content_image/670017.jpg content_image/670018.jpg content_image/670019.jpg
<img src='content_image/670017.jpg'>

Limits page flushing when InnoDB  is idle. The innodb_idle_flush_pct  value is a percentage of the innodb_io_capacity  setting, which defines the number of I/O operations per second available to InnoDB . For more information, see Limiting Buffer Flushing During Idle Periods. 

• innodb_io_capacity 

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

The innodb_io_capacity  variable defines the number of I/O operations per second (IOPS) available to InnoDB  background tasks, such as flushing pages from the buffer pool and merging data from the change buffer. 

For information about configuring the innodb_io_capacity  variable, see Section 15.8.7, “Configuring InnoDB I/O Capacity” . 

• innodb_io_capacity_max 

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

If flushing activity falls behind, InnoDB  can flush more aggressively, at a higher rate of I/ O operations per second (IOPS) than defined by the innodb_io_capacity  variable. The 

