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