Spec-Zone .ru
спецификации, руководства, описания, API
|
|
Spec-Zone .ru
спецификации, руководства, описания, API
|
The INNODB_FT_CONFIG table displays metadata about the FULLTEXT
index and associated processing for an InnoDB table.
This table is only accessible to users with the SUPER privilege. Before you query
this table, set the configuration variable innodb_ft_aux_table to the name (including the database name) of the table
that contains the FULLTEXT index, for example test/articles.
Table 19.19. INNODB_FT_CONFIG Columns
| Column name | Description |
|---|---|
KEY |
The name designating an item of metadata for an InnoDB table
containing a FULLTEXT index.
|
VALUE |
The value associated with the corresponding KEY column, reflecting
some limit or current value for an aspect of a FULLTEXT index for
anInnoDB table.
|
Notes:
This table is only intended for internal configuration. It is not intended for statistical information purposes.
You must have the PROCESS privilege to query this
table.
The values for the KEY column might evolve depending
on the needs for performance tuning and debugging for InnoDB full-text
processing. Currently, the key values include optimize_checkpoint_limit,
synced_doc_id, deleted_doc_count, stopword_table_name, and use_stopword.
For more information, see Section 12.9, "Full-Text Search Functions".