Debian Codegraph @

mysql-test/suite/sys_vars/r/innodb_read_only_basic.result

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