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