InnoDB System Variables Type Integer Default Value 100 Minimum Value 0 Maximum Value 100 Command-Line Format --innodb-io-capacity=# System Variable innodb_io_capacity Scope Global Dynamic Yes SET_VAR  Hint Applies No Type Integer Default Value 200 Minimum Value 100 Maximum Value (64-bit platforms) 2**64-1 Maximum Value (32-bit platforms) 2**32-1 Command-Line Format --innodb-io-capacity-max=# System Variable innodb_io_capacity_max Scope Global Dynamic Yes SET_VAR  Hint Applies No Type Integer Default Value see description Minimum Value 100 Maximum Value (32-bit platforms) 2**32-1 Maximum Value (Unix, 64-bit platforms) 2**64-1 Maximum Value (Windows, 64-bit platforms) 2**32-1 3255 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 For information about configuring the  innodb_io_capacity  variable, see Section 15.8.7, “Configuring InnoDB I/O Capacity” . 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. 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 • innodb_io_capacity_max