7.14 InnoDB Fulltext Configuration Metrics

Lists the InnoDB Fulltext configuration metrics and provides a brief description of each.

Table 7.14 InnoDB Fulltext Configuration Metrics

Name	Description
Aux Table	Specifies the qualified name of an InnoDB table containing a FULLTEXT index.
Cache Size	Size of the cache that holds a parsed document in memory while creating an InnoDB FULLTEXT index.
Enable Diag Print	Whether to enable additional full-text search (FTS) diagnostic output.
Enable Stopword	Specifies that a set of stopwords is associated with an InnoDB FULLTEXT index at the time the index is created.
Max Token Size	Maximum length of words that are stored in an InnoDB FULLTEXT index.
Min Token Size	Minimum length of words that are stored in an InnoDB FULLTEXT index.
Num Word Optimize	Number of words to process during each OPTIMIZE TABLE operation on an InnoDB FULLTEXT index.
Optimize Fulltext Only Enabled	Changes the way the OPTIMIZE TABLE statement operates on InnoDB tables. Intended to be enabled temporarily, during maintenance operations for InnoDB tables with FULLTEXT indexes.
Result Cache Limit	The InnoDB FULLTEXT search (FTS) query result cache limit (defined in bytes) per FTS query or per thread.
Server Stopword Table	Name of the table containing a list of words to ignore when creating an InnoDB FULLTEXT index, in the format db_name/table_name.
Sort Pll Degree	Number of threads used in parallel to index and tokenize text in an InnoDB FULLTEXT index, when building a search index for a large table.
Total Cache Size	The total memory allocated, in bytes, for the InnoDB FULLTEXT search index cache for all tables.
User Stopword Table	Name of the table containing a list of words to ignore when creating an InnoDB FULLTEXT index, in the format db_name/table_name.