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 FLUSH TABLE 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 SELECT * FROM t;
15 SELECT COUNT(*) FROM mysql.innodb_table_stats WHERE table_name = 't';
16 COUNT(*) 1
17 SELECT COUNT(*) FROM mysql.innodb_index_stats WHERE table_name = 't';
18 COUNT(*) 3
19 DROP TABLE t;
20 Test with explicit enable
21 CREATE TABLE t (a INT, PRIMARY KEY (a)) ENGINE=INNODB STATS_AUTO_RECALC=1;
22 SELECT COUNT(*) FROM mysql.innodb_table_stats WHERE table_name = 't';
23 COUNT(*) 1
24 SELECT COUNT(*) FROM mysql.innodb_index_stats WHERE table_name = 't';
25 COUNT(*) 3
26 FLUSH TABLE t;
27 DELETE FROM mysql.innodb_index_stats WHERE table_name = 't';
28 DELETE FROM mysql.innodb_table_stats WHERE table_name = 't';
29 SELECT COUNT(*) FROM mysql.innodb_table_stats WHERE table_name = 't';
30 COUNT(*) 0
31 SELECT COUNT(*) FROM mysql.innodb_index_stats WHERE table_name = 't';
32 COUNT(*) 0
33 SELECT * FROM t;
34 SELECT COUNT(*) FROM mysql.innodb_table_stats WHERE table_name = 't';
35 COUNT(*) 1
36 SELECT COUNT(*) FROM mysql.innodb_index_stats WHERE table_name = 't';
37 COUNT(*) 3
38 DROP TABLE t;
39 Test with explicit disable
40 CREATE TABLE t (a INT, PRIMARY KEY (a)) ENGINE=INNODB STATS_AUTO_RECALC=0;
41 SELECT COUNT(*) FROM mysql.innodb_table_stats WHERE table_name = 't';
42 COUNT(*) 1
43 SELECT COUNT(*) FROM mysql.innodb_index_stats WHERE table_name = 't';
44 COUNT(*) 3
45 FLUSH TABLE t;
46 DELETE FROM mysql.innodb_index_stats WHERE table_name = 't';
47 DELETE FROM mysql.innodb_table_stats WHERE table_name = 't';
48 SELECT COUNT(*) FROM mysql.innodb_table_stats WHERE table_name = 't';
49 COUNT(*) 0
50 SELECT COUNT(*) FROM mysql.innodb_index_stats WHERE table_name = 't';
51 COUNT(*) 0
52 SELECT * FROM t;
53 SELECT COUNT(*) FROM mysql.innodb_table_stats WHERE table_name = 't';
54 COUNT(*) 0
55 SELECT COUNT(*) FROM mysql.innodb_index_stats WHERE table_name = 't';
56 COUNT(*) 0
57 DROP TABLE t;