innodb_io_capacity

Default: 200

SELECT @@innodb_io_capacity;

To resize this variable online (without the need to restart MySQL Server)...

SET GLOBAL innodb_io_capacity=2000;

innodb_io_capacity_max

Default: 2000

SELECT @@innodb_io_capacity_max;

To resize this variable online (without the need to restart MySQL Server)...

SET GLOBAL innodb_io_capacity_max=4000;

innodb_flush_method

Default (UNIX): fsync

SELECT @@innodb_flush_method;

See the discussion linked in the Bibliography... but, in most cases it would appear that O_DIRECT is the best option.

my.cnf

innodb-flush-method = O_DIRECT

Default: 0

SELECT @@innodb_fsync_threshold;

Default: OFF

SELECT @@innodb_use_fdatasync;

innodb_use_native_aio

Default: ON

SELECT @@innodb_use_native_aio;

innodb_write_io_threads

Default: 4

SELECT @@innodb_write_io_threads;

innodb_read_io_threads

Default: 4

SELECT @@innodb_read_io_threads;

my.cnf

innodb-io-capacity                 = 2000

innodb-io-capacity-max             = 4000

Bibliography