Oracle Enterprise Manager for MySQL Database
Lists the InnoDB Fulltext configuration metrics and provides a brief description of each.
Table 7.15 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. |