select @@global.ft_query_expansion_limit; @@global.ft_query_expansion_limit 20 select @@session.ft_query_expansion_limit; ERROR HY000: Variable 'ft_query_expansion_limit' is a GLOBAL variable show global variables like 'ft_query_expansion_limit'; Variable_name Value ft_query_expansion_limit 20 show session variables like 'ft_query_expansion_limit'; Variable_name Value ft_query_expansion_limit 20 select * from information_schema.global_variables where variable_name='ft_query_expansion_limit'; VARIABLE_NAME VARIABLE_VALUE FT_QUERY_EXPANSION_LIMIT 20 select * from information_schema.session_variables where variable_name='ft_query_expansion_limit'; VARIABLE_NAME VARIABLE_VALUE FT_QUERY_EXPANSION_LIMIT 20 set global ft_query_expansion_limit=1; ERROR HY000: Variable 'ft_query_expansion_limit' is a read only variable set session ft_query_expansion_limit=1; ERROR HY000: Variable 'ft_query_expansion_limit' is a read only variable