2
set @my_slave_net_timeout =@@global.slave_net_timeout;
4
set global slave_net_timeout=100;
5
set global sql_slave_skip_counter=100;
6
show variables like 'slave_compressed_protocol';
8
slave_compressed_protocol OFF
9
show variables like 'slave_load_tmpdir';
11
slave_load_tmpdir SLAVE_LOAD_TMPDIR
12
show variables like 'slave_skip_errors';
14
slave_skip_errors 0,3,100,137,643,1752
16
set global slave_net_timeout=default;
17
set global sql_slave_skip_counter= 0;
18
set @@global.slave_net_timeout= @my_slave_net_timeout;
21
SHOW VARIABLES like 'log_slave_updates';
24
SELECT @@session.log_slave_updates;
25
ERROR HY000: Variable 'log_slave_updates' is a GLOBAL variable
26
SELECT @@global.log_slave_updates;
27
@@global.log_slave_updates
29
SET @@session.log_slave_updates= true;
30
ERROR HY000: Variable 'log_slave_updates' is a read only variable
31
SET @@global.log_slave_updates= true;
32
ERROR HY000: Variable 'log_slave_updates' is a read only variable
34
SHOW VARIABLES like 'relay_log';
37
SELECT @@session.relay_log;
38
ERROR HY000: Variable 'relay_log' is a GLOBAL variable
39
SELECT @@global.relay_log;
42
SET @@session.relay_log= 'x';
43
ERROR HY000: Variable 'relay_log' is a read only variable
44
SET @@global.relay_log= 'x';
45
ERROR HY000: Variable 'relay_log' is a read only variable
47
SHOW VARIABLES like 'relay_log_index';
50
SELECT @@session.relay_log_index;
51
ERROR HY000: Variable 'relay_log_index' is a GLOBAL variable
52
SELECT @@global.relay_log_index;
53
@@global.relay_log_index
55
SET @@session.relay_log_index= 'x';
56
ERROR HY000: Variable 'relay_log_index' is a read only variable
57
SET @@global.relay_log_index= 'x';
58
ERROR HY000: Variable 'relay_log_index' is a read only variable
60
SHOW VARIABLES like 'relay_log_info_file';
62
relay_log_info_file relay-log.info
63
SELECT @@session.relay_log_info_file;
64
ERROR HY000: Variable 'relay_log_info_file' is a GLOBAL variable
65
SELECT @@global.relay_log_info_file;
66
@@global.relay_log_info_file
68
SET @@session.relay_log_info_file= 'x';
69
ERROR HY000: Variable 'relay_log_info_file' is a read only variable
70
SET @@global.relay_log_info_file= 'x';
71
ERROR HY000: Variable 'relay_log_info_file' is a read only variable
73
SHOW VARIABLES like 'relay_log_space_limit';
75
relay_log_space_limit 0
76
SELECT @@session.relay_log_space_limit;
77
ERROR HY000: Variable 'relay_log_space_limit' is a GLOBAL variable
78
SELECT @@global.relay_log_space_limit;
79
@@global.relay_log_space_limit
81
SET @@session.relay_log_space_limit= 7;
82
ERROR HY000: Variable 'relay_log_space_limit' is a read only variable
83
SET @@global.relay_log_space_limit= 7;
84
ERROR HY000: Variable 'relay_log_space_limit' is a read only variable
86
SHOW VARIABLES like 'slave_load_tmpdir';
89
SELECT @@session.slave_load_tmpdir;
90
ERROR HY000: Variable 'slave_load_tmpdir' is a GLOBAL variable
91
SELECT @@global.slave_load_tmpdir;
92
@@global.slave_load_tmpdir
94
SET @@session.slave_load_tmpdir= 'x';
95
ERROR HY000: Variable 'slave_load_tmpdir' is a read only variable
96
SET @@global.slave_load_tmpdir= 'x';
97
ERROR HY000: Variable 'slave_load_tmpdir' is a read only variable
99
SHOW VARIABLES like 'slave_skip_errors';
101
slave_skip_errors 0,3,100,137,643,1752
102
SELECT @@session.slave_skip_errors;
103
ERROR HY000: Variable 'slave_skip_errors' is a GLOBAL variable
104
SELECT @@global.slave_skip_errors;
105
@@global.slave_skip_errors
107
SET @@session.slave_skip_errors= 7;
108
ERROR HY000: Variable 'slave_skip_errors' is a read only variable
109
SET @@global.slave_skip_errors= 7;
110
ERROR HY000: Variable 'slave_skip_errors' is a read only variable