Debian Codegraph @

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

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