Debian Codegraph @

mysql-test/suite/galera/r/galera_parallel_simple.result

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE t1 (id INT) ENGINE=InnoDB;
4 CREATE TABLE t2 (id INT) ENGINE=InnoDB;
5 connection node_2;
6 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE 'test/t%';
7 NAME
8 test/t1
9 test/t2
10 SET GLOBAL wsrep_slave_threads = 2;
11 LOCK TABLE t1 WRITE;
12 connection node_1;
13 INSERT INTO t1 VALUES (1);
14 INSERT INTO t2 VALUES (1);
15 INSERT INTO t1 VALUES (1);
16 INSERT INTO t2 VALUES (1);
17 INSERT INTO t1 VALUES (1);
18 INSERT INTO t2 VALUES (1);
19 INSERT INTO t1 VALUES (1);
20 INSERT INTO t2 VALUES (1);
21 INSERT INTO t1 VALUES (1);
22 INSERT INTO t2 VALUES (1);
23 INSERT INTO t1 select * from t1;
24 INSERT INTO t2 select * from t2;
25 INSERT INTO t1 select * from t1;
26 INSERT INTO t2 select * from t2;
27 connection node_2;
28 SET SESSION wsrep_sync_wait = 0;
29 UNLOCK TABLES;
30 SET SESSION wsrep_sync_wait = 15;
31 SELECT COUNT(*) as expect_20 FROM t1;
32 expect_20
33 20
34 SELECT COUNT(*) as expect_20 FROM t2;
35 expect_20
36 20
37 DROP TABLE t1;
38 DROP TABLE t2;