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