这个参数的作用是:InnoDB使用后台线程处理数据页上读写I/O(输入输出)请求的数量。 在MySQL5.5.X版本中,或者说是在InnoDB Plugin1.0.4以后,就用两个新的参数,即innodb_read_io_threads和innodb_write_io_threads,取代了innodb_file_io_threads如此调整后,在Linux平台上就可以根据CPU核数来更改相应的参数值了,默认...
Description:To avoid downtime and to ease testing, please make these settings dynamic: mysql> set global innodb_read_io_threads=8; ERROR 1238 (HY000): Variable 'innodb_read_io_threads' is a read only variable mysql> set global innodb_write_io_threads=8; ERROR 1238 (HY000): Variable 'inn...
# On Unix, increasing the number has no effect; InnoDB always uses the default value. ### 5.5 innodb_read_io_threads=4 # (default) innodb_write_io_threads=4 # (default) --- root@127.0.0.1 : (none) 10:46:59> show variables like 'innodb_%io%threads'; +---+---+ | Variable_n...