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