Debian Codegraph @

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

raw
1 Test with default setting
2 CREATE TABLE t (a INT, PRIMARY KEY (a)) ENGINE=INNODB;
3 SELECT COUNT(*) FROM mysql.innodb_table_stats WHERE table_name = 't';
4 COUNT(*) 1
5 SELECT COUNT(*) FROM mysql.innodb_index_stats WHERE table_name = 't';
6 COUNT(*) 3
7 SELECT * FROM t;
8 DELETE FROM mysql.innodb_index_stats WHERE table_name = 't';
9 DELETE FROM mysql.innodb_table_stats WHERE table_name = 't';
10 SELECT COUNT(*) FROM mysql.innodb_table_stats WHERE table_name = 't';
11 COUNT(*) 0
12 SELECT COUNT(*) FROM mysql.innodb_index_stats WHERE table_name = 't';
13 COUNT(*) 0
14 RENAME TABLE t TO tmp, tmp TO t;
15 SELECT * FROM t;
16 SELECT COUNT(*) FROM mysql.innodb_table_stats WHERE table_name = 't';
17 COUNT(*) 1
18 SELECT COUNT(*) FROM mysql.innodb_index_stats WHERE table_name = 't';
19 COUNT(*) 3
20 DROP TABLE t;
21 Test with explicit enable
22 CREATE TABLE t (a INT, PRIMARY KEY (a)) ENGINE=INNODB STATS_AUTO_RECALC=1;
23 SELECT COUNT(*) FROM mysql.innodb_table_stats WHERE table_name = 't';
24 COUNT(*) 1
25 SELECT COUNT(*) FROM mysql.innodb_index_stats WHERE table_name = 't';
26 COUNT(*) 3
27 SELECT * FROM t;
28 DELETE FROM mysql.innodb_index_stats WHERE table_name = 't';
29 DELETE FROM mysql.innodb_table_stats WHERE table_name = 't';
30 SELECT COUNT(*) FROM mysql.innodb_table_stats WHERE table_name = 't';
31 COUNT(*) 0
32 SELECT COUNT(*) FROM mysql.innodb_index_stats WHERE table_name = 't';
33 COUNT(*) 0
34 RENAME TABLE t TO tmp, tmp TO t;
35 SELECT * FROM t;
36 SELECT COUNT(*) FROM mysql.innodb_table_stats WHERE table_name = 't';
37 COUNT(*) 1
38 SELECT COUNT(*) FROM mysql.innodb_index_stats WHERE table_name = 't';
39 COUNT(*) 3
40 DROP TABLE t;
41 Test with explicit disable
42 CREATE TABLE t (a INT, PRIMARY KEY (a)) ENGINE=INNODB STATS_AUTO_RECALC=0;
43 SELECT COUNT(*) FROM mysql.innodb_table_stats WHERE table_name = 't';
44 COUNT(*) 1
45 SELECT COUNT(*) FROM mysql.innodb_index_stats WHERE table_name = 't';
46 COUNT(*) 3
47 SELECT * FROM t;
48 DELETE FROM mysql.innodb_index_stats WHERE table_name = 't';
49 DELETE FROM mysql.innodb_table_stats WHERE table_name = 't';
50 SELECT COUNT(*) FROM mysql.innodb_table_stats WHERE table_name = 't';
51 COUNT(*) 0
52 SELECT COUNT(*) FROM mysql.innodb_index_stats WHERE table_name = 't';
53 COUNT(*) 0
54 RENAME TABLE t TO tmp, tmp TO t;
55 SELECT * FROM t;
56 SELECT COUNT(*) FROM mysql.innodb_table_stats WHERE table_name = 't';
57 COUNT(*) 0
58 SELECT COUNT(*) FROM mysql.innodb_index_stats WHERE table_name = 't';
59 COUNT(*) 0
60 DROP TABLE t;