InnoDB System Variables Type Integer Default Value 8000000 Minimum Value 1600000 Maximum Value 80000000 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 Command-Line Format --innodb-ft-enable-diag-print[={OFF| ON}] System Variable innodb_ft_enable_diag_print Scope Global Dynamic Yes SET_VAR  Hint Applies No Type Boolean Default Value OFF 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: •For FTS queries, the query parsing tree, word weight, query processing time, and memory usage are printed. For example: •FTS index build progress. For example: •FTS optimize progress. For example: •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 start optimize test FTS_OPTIMIZE: optimize "mysql" FTS_OPTIMIZE: processed "mysql" Number of doc processed: 1000 FTS Search Processing time: 1 secs: 100 millisec: row(s) 10000 Full Search Memory: 245666 (bytes), Row: 10000 • innodb_ft_enable_stopword 3250 Command-Line Format --innodb-ft-enable-stopword[={OFF| ON}]