Documentation Home
Oracle Enterprise Manager for MySQL Database User's Guide
Download this Manual
PDF (US Ltr) - 0.7Mb
PDF (A4) - 0.7Mb
HTML Download (TGZ) - 223.8Kb
HTML Download (Zip) - 231.3Kb


Oracle Enterprise Manager for MySQL Database User's Guide  /  Configuration Metrics  /  InnoDB Fulltext Configuration Metrics

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

NameDescription
Aux TableSpecifies the qualified name of an InnoDB table containing a FULLTEXT index.
Cache SizeSize of the cache that holds a parsed document in memory while creating an InnoDB FULLTEXT index.
Enable Diag PrintWhether to enable additional full-text search (FTS) diagnostic output.
Enable StopwordSpecifies that a set of stopwords is associated with an InnoDB FULLTEXT index at the time the index is created.
Max Token SizeMaximum length of words that are stored in an InnoDB FULLTEXT index.
Min Token SizeMinimum length of words that are stored in an InnoDB FULLTEXT index.
Num Word OptimizeNumber of words to process during each OPTIMIZE TABLE operation on an InnoDB FULLTEXT index.
Optimize Fulltext Only EnabledChanges 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 LimitThe InnoDB FULLTEXT search (FTS) query result cache limit (defined in bytes) per FTS query or per thread.
Server Stopword TableName 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 DegreeNumber 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 SizeThe total memory allocated, in bytes, for the InnoDB FULLTEXT search index cache for all tables.
User Stopword TableName of the table containing a list of words to ignore when creating an InnoDB FULLTEXT index, in the format db_name/table_name.