1# 2# only global 3# 4select @@global.have_profiling="1"; 5--error ER_INCORRECT_GLOBAL_LOCAL_VAR 6select @@session.have_profiling; 7--replace_column 2 # 8show global variables like 'have_profiling'; 9--replace_column 2 # 10show session variables like 'have_profiling'; 11--replace_column 2 # 12select * from information_schema.global_variables where variable_name='have_profiling'; 13--replace_column 2 # 14select * from information_schema.session_variables where variable_name='have_profiling'; 15 16# 17# show that it's read-only 18# 19--error ER_INCORRECT_GLOBAL_LOCAL_VAR 20set global have_profiling=1; 21--error ER_INCORRECT_GLOBAL_LOCAL_VAR 22set session have_profiling=1; 23 24