INNODB_FT_DELETED 详解

Posted by 道行尚浅 on January 21, 2021

系统表介绍

INNODB_FT_DELETED 存储了全文索引中删除的行

列名 含义
DOC_ID 文档ID

实例


mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_DELETED;
+--------+
| DOC_ID |
+--------+
|      6 |
|      7 |
|      8 |
+--------+