content_image/700115.jpg content_image/700126.jpg content_image/700127.jpg
<img src='content_image/700115.jpg'>

The total memory allocated, in bytes, for the InnoDB  full-text search index cache for all tables. Creating numerous tables, each with a FULLTEXT  search index, could consume a significant portion of available memory. innodb_ft_total_cache_size  defines a global memory limit for all full-text search indexes to help avoid excessive memory consumption. If the global limit is reached by an index operation, a forced sync is triggered. 

For more information, see InnoDB Full-Text Index Cache. 

• innodb_ft_user_stopword_table 

<img src='content_image/700126.jpg'>

This option is used to specify your own InnoDB FULLTEXT  index stopword list on a specific table. To configure your own stopword list for all InnoDB  tables, use innodb_ft_server_stopword_table . 

Set innodb_ft_user_stopword_table  to the name of the table containing a list of stopwords, in the format db_name / table_name . 

The stopword table must exist before you configure innodb_ft_user_stopword_table . innodb_ft_enable_stopword  must be enabled and innodb_ft_user_stopword_table  must be configured before you create the FULLTEXT  index. 

The stopword table must be an InnoDB  table, containing a single VARCHAR  column named value . 

For more information, see Section 12.10.4, “Full-Text Stopwords” . 

• innodb_idle_flush_pct 

<img src='content_image/700127.jpg'>

