1Valid values are 'ON' and 'OFF'
2select @@global.innodb_read_only;
3@@global.innodb_read_only
40
5select @@session.innodb_read_only;
6ERROR HY000: Variable 'innodb_read_only' is a GLOBAL variable
7show global variables like 'innodb_read_only';
8Variable_name	Value
9innodb_read_only	OFF
10show session variables like 'innodb_read_only';
11Variable_name	Value
12innodb_read_only	OFF
13select * from information_schema.global_variables where variable_name='innodb_read_only';
14VARIABLE_NAME	VARIABLE_VALUE
15INNODB_READ_ONLY	OFF
16select * from information_schema.session_variables where variable_name='innodb_read_only';
17VARIABLE_NAME	VARIABLE_VALUE
18INNODB_READ_ONLY	OFF
19set global innodb_read_only=1;
20ERROR HY000: Variable 'innodb_read_only' is a read only variable
21set session innodb_read_only=1;
22ERROR HY000: Variable 'innodb_read_only' is a read only variable
23