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