Debian Codegraph @

mysql-test/suite/innodb/t/innodb-index-online-purge.test

raw
1 --source include/have_innodb.inc
2 --source include/have_debug_sync.inc
3
4 # Save the initial number of concurrent sessions.
5 --source include/count_sessions.inc
6
7 connect (con1,localhost,root,,);
8
9 connect (con2,localhost,root,,);
10 connection default;
11
12 CREATE TABLE t (a INT PRIMARY KEY, c TEXT) ENGINE=InnoDB;
13 CREATE TABLE u (a INT PRIMARY KEY, b INT, c INT NOT NULL) ENGINE=InnoDB;
14
15 INSERT INTO t VALUES (1,'aa');
16 BEGIN;
17 INSERT INTO u SET a=1, c=1;
18 INSERT INTO u SELECT a+1,NULL,a+1 FROM u;
19 INSERT INTO u SELECT a+2,NULL,a+2 FROM u;
20 INSERT INTO u SELECT a+4,NULL,a+4 FROM u;
21 INSERT INTO u SELECT a+8,NULL,a+8 FROM u;
22 INSERT INTO u SELECT a+16,NULL,a+16 FROM u;
23 INSERT INTO u SELECT a+32,NULL,a+32 FROM u;
24 INSERT INTO u SELECT a+64,NULL,a+64 FROM u;
25 INSERT INTO u SELECT a+128,NULL,a+64 FROM u;
26 INSERT INTO u SELECT a+256,NULL,a+64 FROM u;
27 COMMIT;
28
29 BEGIN;
30 DELETE FROM u;
31
32 connection con2;
33 SET DEBUG_SYNC='row_log_apply_before SIGNAL created_u WAIT_FOR dml_done_u';
34 --send
35 ALTER TABLE u ADD INDEX (c);
36
37 connection default;
38 # Check that the above SELECT is blocked
39 let $wait_condition=
40 SELECT COUNT(*) = 1 from information_schema.processlist
41 WHERE state = 'Waiting for table metadata lock' AND
42 info = 'ALTER TABLE u ADD INDEX (c)';
43 --source include/wait_condition.inc
44
45 COMMIT;
46 SET DEBUG_SYNC='now WAIT_FOR created_u';
47 SELECT state FROM information_schema.processlist
48 WHERE info='ALTER TABLE u ADD INDEX (c)';
49
50 connection con1;
51 SET DEBUG_SYNC='row_log_apply_before SIGNAL created_t WAIT_FOR dml_done_t';
52 --send
53 CREATE INDEX c1 ON t (c(1));
54 connection default;
55 SET DEBUG_SYNC='now WAIT_FOR created_t';
56 UPDATE t SET c='ab';
57 # Allow purge to kick in. TODO: Trigger this faster, somehow.
58 SELECT SLEEP(10);
59 SET DEBUG_SYNC='now SIGNAL dml_done_u';
60 connection con2;
61 reap;
62 SET DEBUG_SYNC='now SIGNAL dml_done_t';
63 disconnect con2;
64 connection con1;
65 reap;
66 disconnect con1;
67 connection default;
68 SET DEBUG_SYNC='RESET';
69 DROP TABLE t,u;
70
71 # Check that all connections opened by test cases in this file are really
72 # gone so execution of other tests won't be affected by their presence.
73 --source include/wait_until_count_sessions.inc