Debian Codegraph @

mysql-test/suite/multi_source/status_vars.result

raw
1 connect slave,127.0.0.1,root,,,$SERVER_MYPORT_3;
2 call mtr.add_suppression("Connection 'master1' already exists");
3 change master 'master1' to
4 master_port=MYPORT_1,
5 master_host='127.0.0.1',
6 master_user='root', master_ssl_verify_server_cert=0,
7 master_heartbeat_period = 25;
8 start slave 'master1';
9 set default_master_connection = 'master1';
10 include/wait_for_slave_to_start.inc
11 set default_master_connection = '';
12 change master to
13 master_port=MYPORT_2,
14 master_host='127.0.0.1',
15 master_user='root', master_ssl_verify_server_cert=0,
16 master_heartbeat_period=35;
17 start slave;
18 include/wait_for_slave_to_start.inc
19 #
20 # Check how status works for the default connection, anonymous or named
21 #
22 # Slave_running and Slave_heartbeat_period should be local for a connection
23 #
24 set default_master_connection = '';
25 show status like 'Slave_running';
26 Variable_name Value
27 Slave_running ON
28 show status like 'Slave_heartbeat_period';
29 Variable_name Value
30 Slave_heartbeat_period 35.000
31 stop slave io_thread;
32 include/wait_for_slave_io_to_stop.inc
33 show status like 'Slave_running';
34 Variable_name Value
35 Slave_running OFF
36 set default_master_connection = 'master1';
37 show status like 'Slave_running';
38 Variable_name Value
39 Slave_running ON
40 show status like 'Slave_heartbeat_period';
41 Variable_name Value
42 Slave_heartbeat_period 25.000
43 #
44 # Slave_received_heartbeats should also be local
45 #
46 set default_master_connection = '';
47 stop slave sql_thread;
48 include/wait_for_slave_sql_to_stop.inc
49 change master to master_heartbeat_period=1;
50 show status like 'Slave_received_heartbeats';
51 Variable_name Value
52 Slave_received_heartbeats 0
53 start slave;
54 include/wait_for_slave_to_start.inc
55 show status like 'Slave_received_heartbeats';
56 Variable_name Value
57 Slave_received_heartbeats 2
58 stop slave;
59 include/wait_for_slave_to_stop.inc
60 set default_master_connection = 'master1';
61 show status like 'Slave_received_heartbeats';
62 Variable_name Value
63 Slave_received_heartbeats 0
64 stop slave;
65 include/wait_for_slave_to_stop.inc
66 change master to master_heartbeat_period=2;
67 start slave;
68 include/wait_for_slave_to_start.inc
69 show status like 'Slave_received_heartbeats';
70 Variable_name Value
71 Slave_received_heartbeats 1
72 #
73 # Slave_open_temp_tables should be global
74 #
75 set default_master_connection = '';
76 start slave;
77 include/wait_for_slave_to_start.inc
78 connect master1,127.0.0.1,root,,,$SERVER_MYPORT_1;
79 set binlog_format = statement;
80 create temporary table tmp1 (i int) engine=MyISAM;
81 connection slave;
82 show status like 'Slave_open_temp_tables';
83 Variable_name Value
84 Slave_open_temp_tables 1
85 set default_master_connection = 'master1';
86 show status like 'Slave_open_temp_tables';
87 Variable_name Value
88 Slave_open_temp_tables 1
89 connect master2,127.0.0.1,root,,,$SERVER_MYPORT_2;
90 set binlog_format = statement;
91 create temporary table tmp1 (i int) engine=MyISAM;
92 connection slave;
93 show status like 'Slave_open_temp_tables';
94 Variable_name Value
95 Slave_open_temp_tables 2
96 set default_master_connection = '';
97 show status like 'Slave_open_temp_tables';
98 Variable_name Value
99 Slave_open_temp_tables 2
100 include/reset_master_slave.inc
101 disconnect slave;
102 connection master1;
103 include/reset_master_slave.inc
104 disconnect master1;
105 connection master2;
106 include/reset_master_slave.inc
107 disconnect master2;