# exists as a session only --error ER_INCORRECT_GLOBAL_LOCAL_VAR select @@global.skip_replication; # Check the variable has a valid numeric value (assumed to be less then 10000) select @@session.skip_replication between 1 and 10000; --echo should be empty show global variables like 'skip_replication'; show session variables like 'skip_replication'; # Global I_S variable is empty --echo should be empty select * from information_schema.global_variables where variable_name='skip_replication'; # Check that I_S value is same as variable select @@session.skip_replication = variable_value from information_schema.session_variables where variable_name='skip_replication'; # # show that it's writable # set session skip_replication=0; select @@session.skip_replication; set session skip_replication=1; select @@session.skip_replication; select * from information_schema.global_variables where variable_name='skip_replication'; select variable_value from information_schema.session_variables where variable_name='skip_replication'; --error ER_LOCAL_VARIABLE set global skip_replication=1;