Debian Codegraph @

mysql-test/suite/galera/r/MW-336.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 SET @wsrep_slave_threads_orig = @@wsrep_slave_threads;
5 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY AUTO_INCREMENT) Engine=InnoDB;
6 SET GLOBAL wsrep_slave_threads = 10;
7 # Set slave threads to 10 step 1
8 SELECT VARIABLE_VALUE AS EXPECT_10 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_applier_thread_count';
9 EXPECT_10
10 10
11 SET GLOBAL wsrep_slave_threads = 1;
12 connection node_2;
13 INSERT INTO t1 VALUES (NULL);
14 connection node_1;
15 # Wait until one of the appliers has exited
16 SELECT VARIABLE_VALUE AS EXPECT_9 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_applier_thread_count';
17 EXPECT_9
18 9
19 SET GLOBAL wsrep_slave_threads = 10;
20 # Set slave threads to 10 step 2
21 SELECT VARIABLE_VALUE AS EXPECT_10 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_applier_thread_count';
22 EXPECT_10
23 10
24 SET GLOBAL wsrep_slave_threads = 20;
25 # Set slave threads to 20
26 SELECT VARIABLE_VALUE AS EXPECT_20 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_applier_thread_count';
27 EXPECT_20
28 20
29 SET GLOBAL wsrep_slave_threads = 1;
30 connection node_2;
31 connection node_1;
32 # Wait until 19 of the appliers has exited
33 SELECT VARIABLE_VALUE AS EXPECT_1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_applier_thread_count';
34 EXPECT_1
35 1
36 SELECT COUNT(*) AS EXPECT_51 FROM t1;
37 EXPECT_51
38 51
39 SET GLOBAL wsrep_slave_threads = 10;
40 # Set slave threads to 10 step 3
41 SELECT VARIABLE_VALUE AS EXPECT_10 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_applier_thread_count';
42 EXPECT_10
43 10
44 connection node_1;
45 SET GLOBAL wsrep_slave_threads = 1;
46 connection node_2;
47 connection node_1;
48 # Wait until slave threads back to 1
49 SELECT VARIABLE_VALUE AS EXPECT_1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_applier_thread_count';
50 EXPECT_1
51 1
52 SELECT COUNT(*) AS EXPECT_101 FROM t1;
53 EXPECT_101
54 101
55 DROP TABLE t1;