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