Lists the InnoDB Fulltext configuration metrics and provides a brief description of each.
Table 5.10 InnoDB Fulltext Configuration Metrics
Name | Description |
---|---|
Aux Table (Total) | Specifies the qualified name of an InnoDB table containing a FULLTEXT index. |
Cache Size (Total) | Size of the cache that holds a parsed document in memory while creating an InnoDB FULLTEXT index. |
Enable Stopword (Total) | Specifies that a set of stopwords is associated with an InnoDB FULLTEXT index at the time the index is created. |
Max Token Size (Total) | Maximum length of words that are stored in an InnoDB FULLTEXT index. |
Min Token Size (Total) | Minimum length of words that are stored in an InnoDB FULLTEXT index. |
Num Word Optimize (Total) | Number of words to process during each OPTIMIZE TABLE operation on an InnoDB FULLTEXT index. |
Optimize Fulltext Only Enabled (Total) | 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. |
Server Stopword Table (Total) | 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 (Total) | 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. |
User Stopword Table (Total) | Name of the table containing a list of words to ignore when creating an InnoDB FULLTEXT index, in the format db_name/table_name. |