1select @@global.skip_replication; 2ERROR HY000: Variable 'skip_replication' is a SESSION variable 3select @@session.skip_replication between 1 and 10000; 4@@session.skip_replication between 1 and 10000 50 6should be empty 7show global variables like 'skip_replication'; 8Variable_name Value 9show session variables like 'skip_replication'; 10Variable_name Value 11skip_replication OFF 12should be empty 13select * from information_schema.global_variables where variable_name='skip_replication'; 14VARIABLE_NAME VARIABLE_VALUE 15select @@session.skip_replication = variable_value from information_schema.session_variables where variable_name='skip_replication'; 16@@session.skip_replication = variable_value 171 18Warnings: 19Warning 1292 Truncated incorrect DOUBLE value: 'OFF' 20set session skip_replication=0; 21select @@session.skip_replication; 22@@session.skip_replication 230 24set session skip_replication=1; 25select @@session.skip_replication; 26@@session.skip_replication 271 28select * from information_schema.global_variables where variable_name='skip_replication'; 29VARIABLE_NAME VARIABLE_VALUE 30select variable_value from information_schema.session_variables where variable_name='skip_replication'; 31variable_value 32ON 33set global skip_replication=1; 34ERROR HY000: Variable 'skip_replication' is a SESSION variable and can't be used with SET GLOBAL 35