I will give an example of changing innodb_read_io_threads in MySQL.
The innodb_read_io_threads value determines the number of I/O threads for read operations in InnoDB. The default is 4, the minimum possible is 1, the maximum is 64.
I will give an example of viewing the current value:
show variables like 'innodb_read_io_threads';
You cannot change the value without restarting the MySQL server, I will give an example of an error:
SET global innodb_read_io_threads=64; ERROR 1238 (HY000): Variable 'innodb_read_io_threads' is a read only variable
Therefore, we will indicate it in the MySQL server configuration file:
And restart the MySQL server:
service mysql restart