Edit File: rpl_semi_sync_master_trace_level_basic.result
INSTALL PLUGIN rpl_semi_sync_master SONAME 'semisync_master.so'; select @@global.rpl_semi_sync_master_trace_level; @@global.rpl_semi_sync_master_trace_level 32 SET @start_global_value = @@global.rpl_semi_sync_master_trace_level; select @@global.rpl_semi_sync_master_trace_level in (1,16,32,64); @@global.rpl_semi_sync_master_trace_level in (1,16,32,64) 1 select @@session.rpl_semi_sync_master_trace_level; ERROR HY000: Variable 'rpl_semi_sync_master_trace_level' is a GLOBAL variable show global variables like 'rpl_semi_sync_master_trace_level'; Variable_name Value rpl_semi_sync_master_trace_level 32 show session variables like 'rpl_semi_sync_master_trace_level'; Variable_name Value rpl_semi_sync_master_trace_level 32 select * from information_schema.global_variables where variable_name='rpl_semi_sync_master_trace_level'; VARIABLE_NAME VARIABLE_VALUE RPL_SEMI_SYNC_MASTER_TRACE_LEVEL 32 select * from information_schema.session_variables where variable_name='rpl_semi_sync_master_trace_level'; VARIABLE_NAME VARIABLE_VALUE RPL_SEMI_SYNC_MASTER_TRACE_LEVEL 32 set global rpl_semi_sync_master_trace_level=16; set session rpl_semi_sync_master_trace_level=99; ERROR HY000: Variable 'rpl_semi_sync_master_trace_level' is a GLOBAL variable and should be set with SET GLOBAL select @@global.rpl_semi_sync_master_trace_level; @@global.rpl_semi_sync_master_trace_level 16 select @@session.rpl_semi_sync_master_trace_level; ERROR HY000: Variable 'rpl_semi_sync_master_trace_level' is a GLOBAL variable show global variables like 'rpl_semi_sync_master_trace_level'; Variable_name Value rpl_semi_sync_master_trace_level 16 show session variables like 'rpl_semi_sync_master_trace_level'; Variable_name Value rpl_semi_sync_master_trace_level 16 select * from information_schema.global_variables where variable_name='rpl_semi_sync_master_trace_level'; VARIABLE_NAME VARIABLE_VALUE RPL_SEMI_SYNC_MASTER_TRACE_LEVEL 16 select * from information_schema.session_variables where variable_name='rpl_semi_sync_master_trace_level'; VARIABLE_NAME VARIABLE_VALUE RPL_SEMI_SYNC_MASTER_TRACE_LEVEL 16 NOTE: Value can also be set to values that are combinations of values set global rpl_semi_sync_master_trace_level=42; select @@global.rpl_semi_sync_master_trace_level; @@global.rpl_semi_sync_master_trace_level 42 select @@session.rpl_semi_sync_master_trace_level; ERROR HY000: Variable 'rpl_semi_sync_master_trace_level' is a GLOBAL variable show global variables like 'rpl_semi_sync_master_trace_level'; Variable_name Value rpl_semi_sync_master_trace_level 42 show session variables like 'rpl_semi_sync_master_trace_level'; Variable_name Value rpl_semi_sync_master_trace_level 42 select * from information_schema.global_variables where variable_name='rpl_semi_sync_master_trace_level'; VARIABLE_NAME VARIABLE_VALUE RPL_SEMI_SYNC_MASTER_TRACE_LEVEL 42 select * from information_schema.session_variables where variable_name='rpl_semi_sync_master_trace_level'; VARIABLE_NAME VARIABLE_VALUE RPL_SEMI_SYNC_MASTER_TRACE_LEVEL 42 set global rpl_semi_sync_master_trace_level=1.1; ERROR 42000: Incorrect argument type to variable 'rpl_semi_sync_master_trace_level' set global rpl_semi_sync_master_trace_level=1e1; ERROR 42000: Incorrect argument type to variable 'rpl_semi_sync_master_trace_level' set global rpl_semi_sync_master_trace_level="some text"; ERROR 42000: Incorrect argument type to variable 'rpl_semi_sync_master_trace_level' SET @@global.rpl_semi_sync_master_trace_level = @start_global_value; select @@global.rpl_semi_sync_master_trace_level; @@global.rpl_semi_sync_master_trace_level 32 UNINSTALL PLUGIN rpl_semi_sync_master;
Back to File Manager