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