Advanced MySQL 8

Increasing the number of background threads

Increase the number of background threads for read or write operations, if you have a high-end input/output subsystem that is not fully used by default values.

Did you know that you can configure the number of background threads that maintain read/ write I/O on data pages by using the configuration parameters named innodb_read_io_threads and innodb_write_io_threads?

They are very effective on almost all platforms. You can set or change the values for these parameters in the MySQL options file (my.cnf or my.ini); you can't change the values dynamically, unfortunately.

The main goal of these configuration options is to make MySQL more scalable on busy systems. Each background thread can handle up ...