# # only global # select @@global.log_error; --error ER_INCORRECT_GLOBAL_LOCAL_VAR select @@session.log_error; show global variables like 'log_error'; show session variables like 'log_error'; select * from information_schema.global_variables where variable_name='log_error'; select * from information_schema.session_variables where variable_name='log_error'; # # show that it's read-only # --error ER_INCORRECT_GLOBAL_LOCAL_VAR set global log_error=1; --error ER_INCORRECT_GLOBAL_LOCAL_VAR set session log_error=1;