Debian Codegraph @

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

raw
1 SELECT @@innodb_stats_auto_recalc;
2 @@innodb_stats_auto_recalc
3 1
4 SET GLOBAL innodb_stats_auto_recalc=ON;
5 SELECT @@innodb_stats_auto_recalc;
6 @@innodb_stats_auto_recalc
7 1
8 SET GLOBAL innodb_stats_auto_recalc=OFF;
9 SELECT @@innodb_stats_auto_recalc;
10 @@innodb_stats_auto_recalc
11 0
12 SET GLOBAL innodb_stats_auto_recalc=1;
13 SELECT @@innodb_stats_auto_recalc;
14 @@innodb_stats_auto_recalc
15 1
16 SET GLOBAL innodb_stats_auto_recalc=0;
17 SELECT @@innodb_stats_auto_recalc;
18 @@innodb_stats_auto_recalc
19 0
20 SET GLOBAL innodb_stats_auto_recalc=123;
21 ERROR 42000: Variable 'innodb_stats_auto_recalc' can't be set to the value of '123'
22 SET GLOBAL innodb_stats_auto_recalc='foo';
23 ERROR 42000: Variable 'innodb_stats_auto_recalc' can't be set to the value of 'foo'
24 SET GLOBAL innodb_stats_auto_recalc=default;