MySQL :: MySQL 8.4 参考手册 :: 28.4.14 INFORMATION_SCHEMA INNODB_FT_BEING

MySQL 8.4 参考手册 · 中文镜像

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

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

MySQL 8.4 参考手册 / 28 个 INFORMATION_SCHEMA 表 / 28.4 INFORMATION_SCHEMA InnoDB 表 / 28.4.14 INFORMATION_SCHEMA INNODB_FT_BEING_DELETED 表

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

28.4.14 INFORMATION_SCHEMA INNODB_FT_BEING_DELETED 表28.4.14 The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table

INNODB_FT_BEING_DELETED 表提供了 INNODB_FT_DELETED 表的快照；它仅在 OPTIMIZE TABLE 维护操作期间使用。当运行 OPTIMIZE TABLE 时，INNODB_FT_BEING_DELETED 表会被清空，并且 DOC_ID 值会从 INNODB_FT_DELETED 表中移除。由于 INNODB_FT_BEING_DELETED 的内容通常存在时间很短，因此该表在监控或调试中的实用性有限。有关在具有 FULLTEXT 索引的表上运行 OPTIMIZE TABLE 的信息，请参见第 14.9.6 节，“微调 MySQL 全文搜索”。The INNODB_FT_BEING_DELETED table provides a snapshot of the INNODB_FT_DELETED table; it is used only during an OPTIMIZE TABLE maintenance operation. When OPTIMIZE TABLE is run, the INNODB_FT_BEING_DELETED table is emptied, and DOC_ID values are removed from the INNODB_FT_DELETED table. Because the contents of INNODB_FT_BEING_DELETED typically have a short lifetime, this table has limited utility for monitoring or debugging. For information about running OPTIMIZE TABLE on tables with FULLTEXT indexes, see Section 14.9.6, “Fine-Tuning MySQL Full-Text Search”.

此表最初为空。在查询它之前，将 innodb_ft_aux_table 系统变量的值设置为包含 FULLTEXT 索引的表的名称（包括数据库名）（例如，test/articles）。输出类似于 INNODB_FT_DELETED 表所提供的示例。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). The output appears similar to the example provided for the INNODB_FT_DELETED table.

有关相关的使用信息和示例，请参见第 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_BEING_DELETED 表包含这些列：The INNODB_FT_BEING_DELETED table has these columns:

DOC_ID
正在删除的行的文档 ID。此值可能反映您为底层表定义的 ID 列的值，或者当表中没有合适的列时，它可以是 InnoDB 生成的序列值。当您执行文本搜索时会使用此值，以便在通过 INNODB_FT_INDEX_TABLE 表跳过这些行，在删除的行数据被 OPTIMIZE TABLE 语句从 FULLTEXT 索引中物理移除之前。更多信息，请参见优化 InnoDB 全文索引。The document ID of the row that is in the process of being deleted. This value might reflect the value of an ID column that you defined for the underlying table, or it can be a sequence value generated by InnoDB when the table contains no suitable column. This value is used when you perform text searches, to skip rows in the INNODB_FT_INDEX_TABLE table before data for deleted rows is physically removed from the FULLTEXT index by an OPTIMIZE TABLE statement. For more information, see Optimizing InnoDB Full-Text Indexes.

备注Notes

使用 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.
你必须拥有 PROCESS 权限才能查询此表。You must have the PROCESS privilege to query this table.
有关 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”.

首页上一级下一节