2
set @@global.slave_net_timeout= 10;
3
change master to master_host='127.0.0.1',master_port=MASTER_PORT, master_user='root';
4
show status like 'Slave_heartbeat_period';;
5
Variable_name Slave_heartbeat_period
7
change master to master_host='127.0.0.1',master_port=MASTER_PORT, master_user='root', master_heartbeat_period= 4294968;
8
ERROR HY000: The requested value for the heartbeat period is negative or exceeds the maximum 4294967 seconds
9
show status like 'Slave_heartbeat_period';;
10
Variable_name Slave_heartbeat_period
12
change master to master_host='127.0.0.1',master_port=MASTER_PORT, master_user='root', master_heartbeat_period= 0.0009999;
14
Warning 1669 The requested value for the heartbeat period is less than 1 msec. The period is reset to zero which means no heartbeats will be sending
15
show status like 'Slave_heartbeat_period';;
16
Variable_name Slave_heartbeat_period
18
change master to master_host='127.0.0.1',master_port=MASTER_PORT, master_user='root', master_heartbeat_period= 4294967;
20
Warning 1669 The requested value for the heartbeat period exceeds the value of `slave_net_timeout' sec. A sensible value for the period should be less than the timeout.
21
show status like 'Slave_heartbeat_period';;
22
Variable_name Slave_heartbeat_period
24
change master to master_host='127.0.0.1',master_port=MASTER_PORT, master_user='root', master_heartbeat_period= 0.001;
25
show status like 'Slave_heartbeat_period';;
26
Variable_name Slave_heartbeat_period
29
set @@global.slave_net_timeout= 5;
30
change master to master_host='127.0.0.1',master_port=MASTER_PORT, master_user='root', master_heartbeat_period= 5.001;
32
Warning 1669 The requested value for the heartbeat period exceeds the value of `slave_net_timeout' sec. A sensible value for the period should be less than the timeout.
33
show status like 'Slave_heartbeat_period';;
34
Variable_name Slave_heartbeat_period
37
set @@global.slave_net_timeout= 5;
38
change master to master_host='127.0.0.1',master_port=MASTER_PORT, master_user='root', master_heartbeat_period= 4;
39
show status like 'Slave_heartbeat_period';;
40
Variable_name Slave_heartbeat_period
42
set @@global.slave_net_timeout= 3 /* must be a warning */;
44
Warning 1669 The currect value for master_heartbeat_period exceeds the new value of `slave_net_timeout' sec. A sensible value for the period should be less than the timeout.
46
drop table if exists t1;
47
set @@global.slave_net_timeout= 10;
48
change master to master_host='127.0.0.1',master_port=MASTER_PORT, master_user='root', master_heartbeat_period= 0.5;
49
show status like 'Slave_heartbeat_period';;
50
Variable_name Slave_heartbeat_period
53
create table t1 (f1 int);
58
Master_Port MASTER_PORT
60
Master_Log_File master-bin.000001
61
Read_Master_Log_Pos 280
64
Relay_Master_Log_File master-bin.000001
70
Replicate_Ignore_Table #
71
Replicate_Wild_Do_Table
72
Replicate_Wild_Ignore_Table
76
Exec_Master_Log_Pos 280
87
Seconds_Behind_Master #
88
Master_SSL_Verify_Server_Cert No
97
Master_Port MASTER_PORT
99
Master_Log_File master-bin.000001
100
Read_Master_Log_Pos 280
103
Relay_Master_Log_File master-bin.000001
105
Slave_SQL_Running Yes
109
Replicate_Ignore_Table #
110
Replicate_Wild_Do_Table
111
Replicate_Wild_Ignore_Table
115
Exec_Master_Log_Pos 280
120
Master_SSL_Allowed No
126
Seconds_Behind_Master #
127
Master_SSL_Verify_Server_Cert No
132
show status like 'Slave_heartbeat_period';;
133
Variable_name Slave_heartbeat_period
135
A heartbeat has been received by the slave