Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 select @@slave_connections_needed_for_purge;
4 @@slave_connections_needed_for_purge
5 0
6 select VARIABLE_NAME, GLOBAL_VALUE, GLOBAL_VALUE_ORIGIN from information_schema.system_variables where variable_name="slave_connections_needed_for_purge";
7 VARIABLE_NAME GLOBAL_VALUE GLOBAL_VALUE_ORIGIN
8 SLAVE_CONNECTIONS_NEEDED_FOR_PURGE 0 AUTO
9 USE test;
10 CREATE TABLE t1(c1 INT PRIMARY KEY) ENGINE=INNODB;
11 INSERT INTO t1 VALUES (1), (2), (3), (4), (5);
12 SELECT * FROM t1;
13 c1
14 1
15 2
16 3
17 4
18 5
19
20 # On node_1
21 connection node_1;
22 SELECT * FROM test.t1;
23 c1
24 1
25 2
26 3
27 4
28 5
29
30 # On node_2
31 connection node_2;
32 SELECT * FROM test.t1;
33 c1
34 1
35 2
36 3
37 4
38 5
39 DROP TABLE t1;
40 disconnect node_2;
41 disconnect node_1;
42 # End of test