Debian Codegraph @

mysql-test/suite/sys_vars/r/slave_parallel_mode_basic.result

raw
1 SET SESSION slave_parallel_mode= none;
2 ERROR HY000: Variable 'slave_parallel_mode' is a GLOBAL variable and should be set with SET GLOBAL
3 SELECT @@slave_parallel_mode;
4 @@slave_parallel_mode
5 minimal
6 SELECT @@m1.slave_parallel_mode;
7 @@m1.slave_parallel_mode
8 NULL
9 Warnings:
10 Warning 1617 There is no master connection 'm1'
11 Warning 1617 There is no master connection 'm1'
12 CHANGE MASTER TO master_host='127.0.0.1', master_port=3310, master_user='root';
13 SELECT @@``.slave_parallel_mode;
14 @@``.slave_parallel_mode
15 minimal
16 SELECT @@slave_parallel_mode;
17 @@slave_parallel_mode
18 minimal
19 Parallel_Mode = 'minimal'
20 SELECT @@m2.slave_parallel_mode;
21 @@m2.slave_parallel_mode
22 NULL
23 Warnings:
24 Warning 1617 There is no master connection 'm2'
25 Warning 1617 There is no master connection 'm2'
26 SET GLOBAL m2.slave_parallel_mode = none;
27 Warnings:
28 Warning 1617 There is no master connection 'm2'
29 CHANGE MASTER 'm1' TO master_host='127.0.0.1', master_port=3311, master_user='root';
30 SELECT @@m1.slave_parallel_mode;
31 @@m1.slave_parallel_mode
32 optimistic
33 Parallel_Mode = 'minimal'
34 SET GLOBAL m1.slave_parallel_mode= conservative;
35 Parallel_Mode = 'minimal'
36 SET default_master_connection= 'm1';
37 SELECT @@slave_parallel_mode;
38 @@slave_parallel_mode
39 conservative
40 SET GLOBAL slave_parallel_mode= aggressive;
41 SELECT @@slave_parallel_mode;
42 @@slave_parallel_mode
43 aggressive
44 Parallel_Mode = 'aggressive'
45 SET default_master_connection= '';
46 SELECT @@slave_parallel_mode;
47 @@slave_parallel_mode
48 minimal
49 RESET SLAVE ALL;
50 RESET SLAVE 'm1' ALL;