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