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