Debian Codegraph @

mysql-test/suite/innodb/r/innodb_stats_create_table.result

raw
1 set @save_innodb_stats_persistent= @@innodb_stats_persistent;
2 set global innodb_stats_persistent=default;
3 SELECT COUNT(*) FROM mysql.innodb_table_stats WHERE
4 database_name = 'test' AND
5 table_name = 'test_ps_create_table';
6 COUNT(*) 0
7 CREATE TABLE test_ps_create_table (a INT, PRIMARY KEY (a))
8 ENGINE=INNODB STATS_PERSISTENT=0;
9 SELECT COUNT(*) FROM mysql.innodb_table_stats WHERE
10 database_name = 'test' AND
11 table_name = 'test_ps_create_table';
12 COUNT(*) 0
13 DROP TABLE test_ps_create_table;
14 CREATE TABLE test_ps_create_table (a INT, PRIMARY KEY (a))
15 ENGINE=INNODB;
16 SELECT COUNT(*) FROM mysql.innodb_table_stats WHERE
17 database_name = 'test' AND
18 table_name = 'test_ps_create_table';
19 COUNT(*) 1
20 DROP TABLE test_ps_create_table;
21 CREATE TABLE test_ps_create_table (a INT, PRIMARY KEY (a))
22 ENGINE=INNODB STATS_PERSISTENT=default;
23 SELECT COUNT(*) FROM mysql.innodb_table_stats WHERE
24 database_name = 'test' AND
25 table_name = 'test_ps_create_table';
26 COUNT(*) 1
27 DROP TABLE test_ps_create_table;
28 CREATE TABLE test_ps_create_table (a INT, PRIMARY KEY (a))
29 ENGINE=INNODB STATS_PERSISTENT=1;
30 SELECT COUNT(*) FROM mysql.innodb_table_stats WHERE
31 database_name = 'test' AND
32 table_name = 'test_ps_create_table';
33 COUNT(*) 1
34 DROP TABLE test_ps_create_table;
35 set global innodb_stats_persistent= @save_innodb_stats_persistent;