1select @@global.innodb_ft_result_cache_limit; 2@@global.innodb_ft_result_cache_limit 32000000000 4select @@session.innodb_ft_result_cache_limit; 5ERROR HY000: Variable 'innodb_ft_result_cache_limit' is a GLOBAL variable 6show global variables like 'innodb_ft_result_cache_limit'; 7Variable_name Value 8innodb_ft_result_cache_limit 2000000000 9show session variables like 'innodb_ft_result_cache_limit'; 10Variable_name Value 11innodb_ft_result_cache_limit 2000000000 12select * from information_schema.global_variables where variable_name='innodb_ft_result_cache_limit'; 13VARIABLE_NAME VARIABLE_VALUE 14INNODB_FT_RESULT_CACHE_LIMIT 2000000000 15select * from information_schema.session_variables where variable_name='innodb_ft_result_cache_limit'; 16VARIABLE_NAME VARIABLE_VALUE 17INNODB_FT_RESULT_CACHE_LIMIT 2000000000 18SET @save_limit = @@innodb_ft_result_cache_limit; 19set global innodb_ft_result_cache_limit=900000; 20Warnings: 21Warning 1292 Truncated incorrect innodb_ft_result_cache_limit value: '900000' 22select @@innodb_ft_result_cache_limit; 23@@innodb_ft_result_cache_limit 241000000 25set global innodb_ft_result_cache_limit=1000000; 26select @@innodb_ft_result_cache_limit; 27@@innodb_ft_result_cache_limit 281000000 29set global innodb_ft_result_cache_limit=4294967295; 30select @@innodb_ft_result_cache_limit; 31@@innodb_ft_result_cache_limit 324294967295 33set global innodb_ft_result_cache_limit=4*1024*1024*1024; 34select @@innodb_ft_result_cache_limit; 35@@innodb_ft_result_cache_limit 364294967296 37set global innodb_ft_result_cache_limit = @save_limit; 38