The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table For related usage information and examples, see Section 15.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables” . The  INNODB_FT_DELETED  table has these columns: The document ID of the newly deleted row. 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. The  INNODB_FT_INDEX_CACHE  table provides token information about newly inserted rows in a FULLTEXT  index. To avoid expensive index reorganization during DML operations, the information about newly indexed words is stored separately, and combined with the main search index only when  OPTIMIZE TABLE  is run, when the server is shut down, or when the cache size exceeds a limit defined by the innodb_ft_cache_size  or  innodb_ft_total_cache_size  system variable. 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 ). For related usage information and examples, see Section 15.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables” . The  INNODB_FT_INDEX_CACHE  table has these columns: A word extracted from the text of a newly inserted row. 4865 • DOC_ID •You must have the  PROCESS  privilege to query this table. •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. •For more information about  InnoDB FULLTEXT  search, see Section 15.6.2.4, “InnoDB Full-Text Indexes” , and Section 12.10, “Full-Text Search Functions” . • WORD • FIRST_DOC_ID 26.4.18 The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table Notes Example mysql>  SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_DELETED; +--------+ | DOC_ID | +--------+ | 6 | | 7 | | 8 | +--------+