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