Debian Codegraph @

mysql-test/suite/innodb/t/innodb_stats_auto_recalc_ddl.test

raw
1 #
2 # Test the persistent stats auto recalc during DDL
3 #
4
5 -- source include/have_innodb.inc
6
7 -- vertical_results
8
9 -- let $check_stats1 = SELECT n_rows FROM mysql.innodb_table_stats WHERE table_name = 'arddl' ORDER BY 1
10 -- let $check_stats2 = SELECT index_name, stat_name, stat_value FROM mysql.innodb_index_stats WHERE table_name = 'arddl' AND index_name = 'PRIMARY' ORDER BY 1, 2, 3
11
12 # Test ADD INDEX during background stats gathering
13
14 CREATE TABLE arddl (a INT, b INT, PRIMARY KEY (a)) ENGINE=INNODB;
15
16 INSERT INTO arddl VALUES (1, 10);
17 INSERT INTO arddl VALUES (2, 10);
18
19 ALTER TABLE arddl ADD INDEX (b);
20
21 # wait for the bg stats thread to update the stats, notice we wait on
22 # innodb_index_stats because innodb_table_stats gets updated first and
23 # it is possible that (if we wait on innodb_table_stats) the wait cond
24 # gets satisfied before innodb_index_stats is updated
25 let $wait_condition = SELECT stat_value = 2 FROM mysql.innodb_index_stats WHERE table_name = 'arddl' AND index_name = 'PRIMARY' AND stat_name = 'n_diff_pfx01';
26 -- source include/wait_condition.inc
27
28 # the second INSERT from above should have triggered an auto-recalc
29 -- eval $check_stats1
30 -- eval $check_stats2
31
32 DROP TABLE arddl;
33
34 # Test DROP INDEX during background stats gathering
35
36 CREATE TABLE arddl (a INT, b INT, PRIMARY KEY (a), KEY (b)) ENGINE=INNODB;
37
38 INSERT INTO arddl VALUES (3, 10);
39 INSERT INTO arddl VALUES (4, 10);
40
41 ALTER TABLE arddl DROP INDEX b;
42
43 let $wait_condition = SELECT stat_value = 2 FROM mysql.innodb_index_stats WHERE table_name = 'arddl' AND index_name = 'PRIMARY' AND stat_name = 'n_diff_pfx01';
44 -- source include/wait_condition.inc
45
46 -- eval $check_stats1
47 -- eval $check_stats2
48
49 DROP TABLE arddl;