Debian Codegraph @

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

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