Debian Codegraph @

mysql-test/suite/galera/r/mysql-wsrep#198.result

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE t1 (id INT PRIMARY KEY) ENGINE=InnoDB;
4 CREATE TABLE t2 (id INT PRIMARY KEY) ENGINE=InnoDB;
5 connection node_2;
6 SELECT 1 FROM DUAL;
7 1
8 1
9 LOCK TABLE t2 WRITE;
10 connect node_2_ctrl, 127.0.0.1, root, , test, $NODE_MYPORT_2;
11 connection node_2_ctrl;
12 SET SESSION wsrep_sync_wait=0;
13 connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2;
14 connection node_2a;
15 OPTIMIZE TABLE t1,t2;;
16 connection node_2_ctrl;
17 SET SESSION wsrep_sync_wait = 0;
18 connect node_2b, 127.0.0.1, root, , test, $NODE_MYPORT_2;
19 connection node_2b;
20 REPAIR TABLE t1,t2;;
21 connection node_2_ctrl;
22 connection node_1;
23 INSERT INTO t2 VALUES (1);
24 connection node_2;
25 UNLOCK TABLES;
26 connection node_2a;
27 Table Op Msg_type Msg_text
28 test.t1 optimize note Table does not support optimize, doing recreate + analyze instead
29 test.t1 optimize status OK
30 test.t2 optimize note Table does not support optimize, doing recreate + analyze instead
31 test.t2 optimize status OK
32 connection node_2b;
33 Table Op Msg_type Msg_text
34 test.t1 repair status OK
35 test.t2 repair status OK
36 DROP TABLE t1;
37 DROP TABLE t2;
38 connection node_1;
39 disconnect node_2a;
40 disconnect node_2b;
41 disconnect node_2_ctrl;