Debian Codegraph @

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

raw
1 select @@global.rpl_semi_sync_master_timeout;
2 @@global.rpl_semi_sync_master_timeout
3 10000
4 SET @start_global_value = @@global.rpl_semi_sync_master_timeout;
5 Assuming value will not be more then 100 sec
6 select @@global.rpl_semi_sync_master_timeout between 1 and 100000;
7 @@global.rpl_semi_sync_master_timeout between 1 and 100000
8 1
9 select @@session.rpl_semi_sync_master_timeout;
10 ERROR HY000: Variable 'rpl_semi_sync_master_timeout' is a GLOBAL variable
11 show global variables like 'rpl_semi_sync_master_timeout';
12 Variable_name Value
13 rpl_semi_sync_master_timeout 10000
14 show session variables like 'rpl_semi_sync_master_timeout';
15 Variable_name Value
16 rpl_semi_sync_master_timeout 10000
17 select * from information_schema.global_variables where variable_name='rpl_semi_sync_master_timeout';
18 VARIABLE_NAME VARIABLE_VALUE
19 RPL_SEMI_SYNC_MASTER_TIMEOUT 10000
20 select * from information_schema.session_variables where variable_name='rpl_semi_sync_master_timeout';
21 VARIABLE_NAME VARIABLE_VALUE
22 RPL_SEMI_SYNC_MASTER_TIMEOUT 10000
23 set global rpl_semi_sync_master_timeout=42;
24 set session rpl_semi_sync_master_timeout=99;
25 ERROR HY000: Variable 'rpl_semi_sync_master_timeout' is a GLOBAL variable and should be set with SET GLOBAL
26 select @@global.rpl_semi_sync_master_timeout;
27 @@global.rpl_semi_sync_master_timeout
28 42
29 select @@session.rpl_semi_sync_master_timeout;
30 ERROR HY000: Variable 'rpl_semi_sync_master_timeout' is a GLOBAL variable
31 show global variables like 'rpl_semi_sync_master_timeout';
32 Variable_name Value
33 rpl_semi_sync_master_timeout 42
34 show session variables like 'rpl_semi_sync_master_timeout';
35 Variable_name Value
36 rpl_semi_sync_master_timeout 42
37 select * from information_schema.global_variables where variable_name='rpl_semi_sync_master_timeout';
38 VARIABLE_NAME VARIABLE_VALUE
39 RPL_SEMI_SYNC_MASTER_TIMEOUT 42
40 select * from information_schema.session_variables where variable_name='rpl_semi_sync_master_timeout';
41 VARIABLE_NAME VARIABLE_VALUE
42 RPL_SEMI_SYNC_MASTER_TIMEOUT 42
43 set global rpl_semi_sync_master_timeout=1.1;
44 ERROR 42000: Incorrect argument type to variable 'rpl_semi_sync_master_timeout'
45 set global rpl_semi_sync_master_timeout=1e1;
46 ERROR 42000: Incorrect argument type to variable 'rpl_semi_sync_master_timeout'
47 set global rpl_semi_sync_master_timeout="some text";
48 ERROR 42000: Incorrect argument type to variable 'rpl_semi_sync_master_timeout'
49 SET @@global.rpl_semi_sync_master_timeout = @start_global_value;
50 select @@global.rpl_semi_sync_master_timeout;
51 @@global.rpl_semi_sync_master_timeout
52 10000