content_image/791096.jpg content_image/791101.jpg content_image/791113.jpg
<img src='content_image/791096.jpg'>

The memory allocated, in bytes, for the InnoDB FULLTEXT  search index cache, which holds a parsed document in memory while creating an InnoDB FULLTEXT  index. Index inserts and updates are only committed to disk when the innodb_ft_cache_size  size limit is reached. 

innodb_ft_cache_size  defines the cache size on a per table basis. To set a global limit for all tables, see innodb_ft_total_cache_size . 

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

• innodb_ft_enable_diag_print 

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

Whether to enable additional full-text search (FTS) diagnostic output. This option is primarily intended for advanced FTS debugging and is not of interest to most users. Output is printed to the error log and includes information such as: 

•FTS index sync progress (when the FTS cache limit is reached). For example: 

FTS SYNC for table test, deleted count: 100 size: 10000 bytes SYNC words: 100 

•FTS optimize progress. For example: 

FTS start optimize test FTS_OPTIMIZE: optimize "mysql" FTS_OPTIMIZE: processed "mysql" 

•FTS index build progress. For example: 

Number of doc processed: 1000 

•For FTS queries, the query parsing tree, word weight, query processing time, and memory usage are printed. For example: 

FTS Search Processing time: 1 secs: 100 millisec: row(s) 10000 Full Search Memory: 245666 (bytes), Row: 10000 

• innodb_ft_enable_stopword 

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

