MySQL :: MySQL 8.4 参考手册 :: 28.4.15 INFORMATION_SCHEMA INNODB_FT

MySQL 8.4 参考手册 · 中文镜像

正文为中文，英文原文默认隐藏。点击任意中文段落即可展开 / 收起对应英文原文。

译文由机器翻译生成，仅供理解参考；有疑问请以官方英文原文为准。

MySQL 8.4 参考手册 / 28 个 INFORMATION_SCHEMA 表 / 28.4 INFORMATION_SCHEMA InnoDB 表 / 28.4.15 INFORMATION_SCHEMA INNODB_FT_CONFIG 表

中文点击中文段落可显示 / 隐藏英文原文本页译文覆盖 90%

28.4.15 INFORMATION_SCHEMA INNODB_FT_CONFIG 表28.4.15 The INFORMATION_SCHEMA INNODB_FT_CONFIG Table

INNODB_FT_CONFIG 表提供关于 FULLTEXT 索引及其关联处理的元数据，供 InnoDB 表使用。The INNODB_FT_CONFIG table provides metadata about the FULLTEXT index and associated processing for an InnoDB table.

此表最初为空。在查询它之前，将 innodb_ft_aux_table 系统变量的值设置为包含 FULLTEXT 索引的表的名称（包括数据库名称）（例如，test/articles）。This table is empty initially. Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that contains the FULLTEXT index (for example, test/articles).

有关相关的使用信息和示例，请参见第 17.15.4 节，“InnoDB INFORMATION_SCHEMA FULLTEXT 索引表”。For related usage information and examples, see Section 17.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”.

INNODB_FT_CONFIG 表具有以下列：The INNODB_FT_CONFIG table has these columns:

KEY
指定包含 FULLTEXT 索引的 InnoDB 表的元数据项名称。The name designating an item of metadata for an InnoDB table containing a FULLTEXT index.
该列的值可能会发生变化，具体取决于 InnoDB 全文处理的性能调优和调试需求。键名及其含义包括：The values for this column might change, depending on the needs for performance tuning and debugging for InnoDB full-text processing. The key names and their meanings include:
- optimize_checkpoint_limit：OPTIMIZE TABLE 操作停止前的秒数。optimize_checkpoint_limit: The number of seconds after which an OPTIMIZE TABLE run stops.
- synced_doc_id：下一个要分配的 DOC_ID。synced_doc_id: The next DOC_ID to be issued.
- stopword_table_name：用户定义的停用词表的database/table名称。如果没有用户定义的停用词表，则VALUE列为空。stopword_table_name: The database/table name for a user-defined stopword table. The VALUE column is empty if there is no user-defined stopword table.
- use_stopword：指示是否使用停用词表，该项在创建FULLTEXT索引时定义。use_stopword: Indicates whether a stopword table is used, which is defined when the FULLTEXT index is created.
VALUE
与相应 KEY 列相关联的值，反映了 InnoDB 表的 FULLTEXT 索引某一方面的限制或当前值。The value associated with the corresponding KEY column, reflecting some limit or current value for an aspect of a FULLTEXT index for an InnoDB table.

示例Example

mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_CONFIG;
+---------------------------+-------------------+
| KEY                       | VALUE             |
+---------------------------+-------------------+
| optimize_checkpoint_limit | 180               |
| synced_doc_id             | 0                 |
| stopword_table_name       | test/my_stopwords |
| use_stopword              | 1                 |
+---------------------------+-------------------+

注意事项Notes

该表仅用于内部配置。它不用于统计信息目的。This table is intended only for internal configuration. It is not intended for statistical information purposes.
你必须拥有 PROCESS 权限才能查询此表。You must have the PROCESS privilege to query this table.
使用 INFORMATION_SCHEMA COLUMNS 表或 SHOW COLUMNS 语句查看关于此表列的更多信息，包括数据类型和默认值。Use the INFORMATION_SCHEMA COLUMNS table or the SHOW COLUMNS statement to view additional information about the columns of this table, including data types and default values.
有关 InnoDB FULLTEXT 搜索的更多信息，请参见第 17.6.2.4 节，“InnoDB 全文索引”，以及第 14.9 节，“全文搜索函数”。For more information about InnoDB FULLTEXT search, see Section 17.6.2.4, “InnoDB Full-Text Indexes”, and Section 14.9, “Full-Text Search Functions”.

首页上一级下一节