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