1INSTALL PLUGIN rpl_semi_sync_master SONAME 'semisync_master.so'; 2select @@global.rpl_semi_sync_master_wait_no_slave; 3@@global.rpl_semi_sync_master_wait_no_slave 41 5SET @start_global_value = @@global.rpl_semi_sync_master_wait_no_slave; 6select @@global.rpl_semi_sync_master_wait_no_slave in (0,1); 7@@global.rpl_semi_sync_master_wait_no_slave in (0,1) 81 9select @@session.rpl_semi_sync_master_wait_no_slave; 10ERROR HY000: Variable 'rpl_semi_sync_master_wait_no_slave' is a GLOBAL variable 11show global variables like 'rpl_semi_sync_master_wait_no_slave'; 12Variable_name Value 13rpl_semi_sync_master_wait_no_slave ON 14show session variables like 'rpl_semi_sync_master_wait_no_slave'; 15Variable_name Value 16rpl_semi_sync_master_wait_no_slave ON 17select * from information_schema.global_variables where variable_name='rpl_semi_sync_master_wait_no_slave'; 18VARIABLE_NAME VARIABLE_VALUE 19RPL_SEMI_SYNC_MASTER_WAIT_NO_SLAVE ON 20select * from information_schema.session_variables where variable_name='rpl_semi_sync_master_wait_no_slave'; 21VARIABLE_NAME VARIABLE_VALUE 22RPL_SEMI_SYNC_MASTER_WAIT_NO_SLAVE ON 23set global rpl_semi_sync_master_wait_no_slave=0; 24set session rpl_semi_sync_master_wait_no_slave=0; 25ERROR HY000: Variable 'rpl_semi_sync_master_wait_no_slave' is a GLOBAL variable and should be set with SET GLOBAL 26select @@global.rpl_semi_sync_master_wait_no_slave; 27@@global.rpl_semi_sync_master_wait_no_slave 280 29select @@session.rpl_semi_sync_master_wait_no_slave; 30ERROR HY000: Variable 'rpl_semi_sync_master_wait_no_slave' is a GLOBAL variable 31show global variables like 'rpl_semi_sync_master_wait_no_slave'; 32Variable_name Value 33rpl_semi_sync_master_wait_no_slave OFF 34show session variables like 'rpl_semi_sync_master_wait_no_slave'; 35Variable_name Value 36rpl_semi_sync_master_wait_no_slave OFF 37select * from information_schema.global_variables where variable_name='rpl_semi_sync_master_wait_no_slave'; 38VARIABLE_NAME VARIABLE_VALUE 39RPL_SEMI_SYNC_MASTER_WAIT_NO_SLAVE OFF 40select * from information_schema.session_variables where variable_name='rpl_semi_sync_master_wait_no_slave'; 41VARIABLE_NAME VARIABLE_VALUE 42RPL_SEMI_SYNC_MASTER_WAIT_NO_SLAVE OFF 43set global rpl_semi_sync_master_wait_no_slave=1; 44set session rpl_semi_sync_master_wait_no_slave=1; 45ERROR HY000: Variable 'rpl_semi_sync_master_wait_no_slave' is a GLOBAL variable and should be set with SET GLOBAL 46select @@global.rpl_semi_sync_master_wait_no_slave; 47@@global.rpl_semi_sync_master_wait_no_slave 481 49select @@session.rpl_semi_sync_master_wait_no_slave; 50ERROR HY000: Variable 'rpl_semi_sync_master_wait_no_slave' is a GLOBAL variable 51show global variables like 'rpl_semi_sync_master_wait_no_slave'; 52Variable_name Value 53rpl_semi_sync_master_wait_no_slave ON 54show session variables like 'rpl_semi_sync_master_wait_no_slave'; 55Variable_name Value 56rpl_semi_sync_master_wait_no_slave ON 57select * from information_schema.global_variables where variable_name='rpl_semi_sync_master_wait_no_slave'; 58VARIABLE_NAME VARIABLE_VALUE 59RPL_SEMI_SYNC_MASTER_WAIT_NO_SLAVE ON 60select * from information_schema.session_variables where variable_name='rpl_semi_sync_master_wait_no_slave'; 61VARIABLE_NAME VARIABLE_VALUE 62RPL_SEMI_SYNC_MASTER_WAIT_NO_SLAVE ON 63set global rpl_semi_sync_master_wait_no_slave=1.1; 64ERROR 42000: Incorrect argument type to variable 'rpl_semi_sync_master_wait_no_slave' 65set global rpl_semi_sync_master_wait_no_slave=1e1; 66ERROR 42000: Incorrect argument type to variable 'rpl_semi_sync_master_wait_no_slave' 67set global rpl_semi_sync_master_wait_no_slave="some text"; 68ERROR 42000: Variable 'rpl_semi_sync_master_wait_no_slave' can't be set to the value of 'some text' 69SET @@global.rpl_semi_sync_master_wait_no_slave = @start_global_value; 70select @@global.rpl_semi_sync_master_wait_no_slave; 71@@global.rpl_semi_sync_master_wait_no_slave 721 73UNINSTALL PLUGIN rpl_semi_sync_master; 74