result cache size limit is reached, an error is returned indicating that the query exceeds the maximum allowed memory. The maximum value of innodb_ft_result_cache_limit for all platform types and bit sizes is 2**32-1." This limit applies to all recent versions (inclusing 5.6.x as well)...
| innodb_ft_result_cache_limit | 2000000000 | | innodb_ft_server_stopword_table | | | innodb_ft_sort_pll_degree | 2 | | innodb_ft_total_cache_size | 640000000 | | innodb_ft_user_stopword_table | | | innodb_io_capacity | 200 | | innodb_io_capacity_max | 2000 | | innodb_larg...
innodb_ft_cache_size=8000000 innodb_ft_enable_diag_print=OFF innodb_ft_enable_stopword=ON innodb_ft_max_token_size=84 innodb_ft_min_token_size=3 innodb_ft_num_word_optimize=2000 innodb_ft_result_cache_limit=2000000000 innodb_ft_sort_pll_degree=2 innodb_ft_total_cache_size=640000000 innodb...
| innodb_ft_enable_diag_print | OFF | | innodb_ft_enable_stopword | ON | | innodb_ft_max_token_size | 84 | | innodb_ft_min_token_size | 3 | | innodb_ft_num_word_optimize | 2000 | | innodb_ft_result_cache_limit | 2000000000 | | innodb_ft_server_stopword_table | | | inno...
innodb_ft_result_cache_limit Yes Yes Yes Global Yes innodb_ft_server_stopword_table Yes Yes Yes Global Yes innodb_ft_sort_pll_degree Yes Yes Yes Global No innodb_ft_total_cache_size Yes Yes Yes Global No innodb_ft_user_stopword_table Yes Yes Yes Both Yes Innodb_have_atomic_builtins ...
innodb_ft_result_cache_limit 否 2000000000 1,000,000～4,294,967,295 每一个FTS查询或每个线程,InnoDBFULLTEXT搜索(FTS)的查询结果缓存限值(单位为字节)。 innodb_ft_server_stopword_table 否 default -- 创建InnoDB FULLTEXT索引进程中,包含可以忽略单词列表的表格名,格式为db_name/table_name。 innodb_ft...
innodb_ft_result_cache_limit 否 2000000000 1,000,000～4,294,967,295 每一个FTS查询或每个线程,InnoDBFULLTEXT搜索(FTS)的查询结果缓存限值(单位为字节)。 innodb_ft_server_stopword_table 否 default -- 创建InnoDB FULLTEXT索引进程中,包含可以忽略单词列表的表格名,格式为db_name/table_name。 innodb_ft...
1、增加innodb_ft_result_cache_limit的值,使其大于4G SHOW VARIABLES LIKE 'innodb_ft_result_cache_limit%';set global innodb_ft_result_cache_limit=4000000000; 2、优化查询语句,限制查询返回的记录条数,减少来自中间结果的巨大缓存。一般通过显示指定limit来限制。
| innodb_ft_enable_diag_print | OFF | | innodb_ft_enable_stopword | ON | | innodb_ft_max_token_size | 84 | | innodb_ft_min_token_size | 3 | | innodb_ft_num_word_optimize | 2000 | | innodb_ft_result_cache_limit | 2000000000 | ...
innodb_ft_result_cache_limit Yes Yes Yes Global Yes innodb_ft_server_stopword_table Yes Yes Yes Global Yes innodb_ft_sort_pll_degree Yes Yes Yes Global No innodb_ft_total_cache_size Yes Yes Yes Global No innodb_ft_user_stopword_table Yes Yes Yes Both Yes innodb_idle_flush_pct Yes Ye...