1SELECT @@innodb_stats_auto_recalc;
2@@innodb_stats_auto_recalc
31
4SET GLOBAL innodb_stats_auto_recalc=ON;
5SELECT @@innodb_stats_auto_recalc;
6@@innodb_stats_auto_recalc
71
8SET GLOBAL innodb_stats_auto_recalc=OFF;
9SELECT @@innodb_stats_auto_recalc;
10@@innodb_stats_auto_recalc
110
12SET GLOBAL innodb_stats_auto_recalc=1;
13SELECT @@innodb_stats_auto_recalc;
14@@innodb_stats_auto_recalc
151
16SET GLOBAL innodb_stats_auto_recalc=0;
17SELECT @@innodb_stats_auto_recalc;
18@@innodb_stats_auto_recalc
190
20SET GLOBAL innodb_stats_auto_recalc=123;
21ERROR 42000: Variable 'innodb_stats_auto_recalc' can't be set to the value of '123'
22SET GLOBAL innodb_stats_auto_recalc='foo';
23ERROR 42000: Variable 'innodb_stats_auto_recalc' can't be set to the value of 'foo'
24SET GLOBAL innodb_stats_auto_recalc=default;
25