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