| innodb_ft_min_token_size | 3 | | innodb_ft_num_word_optimize | 2000 | | 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 | | |...
If the limit is exceeded, the query returns an error. Commandline: --innodb-ft-result-cache-limit=# Scope: Global Dynamic: Yes Data Type: numeric Default Value: 2000000000 Range: 1000000 to 18446744073709551615 innodb_ft_server_stopword_table...
This bug report stems from http://dba.stackexchange.com/questions/157462/how-innodb-ft-result-cache-limit-work by Hamoon Mohammadian Pour How to repeat: N/A Suggested fix: Plan A: If this is not really per-FT-query, then change the documentation. Plan B: Lower the default to either ...
innodb_ft_num_word_optimize Yes Yes Yes Global Yes 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...
すべてのプラットフォームタイプおよびビットサイズに対する innodb_ft_result_cache_limit の最大値は、2**32-1 です。 innodb_ft_server_stopword_table コマンド行形式 --innodb-ft-server-stopword-table=db_name/table_name システム変数 innodb_ft_server_stopword_table スコープ グロ...
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_num_word_optimize | 2000 | | 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_ft_num_word_optimize Yes Yes Yes Global Yes 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...
| 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_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_server_stopword_table ...