Bug #96227 please make innodb_read_io_threads and innodb_write_io_threads dynamic

Submitted: 17 Jul 2019 7:03
Reporter: Shane Bester (Platinum Quality Contributor) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S4 (Feature request)
Version:8.0.16 OS:Any
Assigned to: CPU Architecture:Any

[17 Jul 2019 7:03] Shane Bester
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 'innodb_write_io_threads' is a read only variable
mysql> select version();
+-----------+
| version() |
+-----------+
| 8.0.16    |
+-----------+
1 row in set (0.00 sec)

How to repeat:
set global innodb_read_io_threads=8;
set global innodb_write_io_threads=8;
[17 Jul 2019 8:17] Simon Mudd
Yes please.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.039 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.