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. |