Debian Codegraph @

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

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