## Notes 

+-------+ | value | +-------+ | a | | about | | an | | are | | as | | at | | be | | by | | com | | de | | en | | for | | from | | how | | i | | in | | is | | it | | la | | of | | on | | or | | that | | the | | this | | to | | was | | what | | when | | where | | who | | will | | with | | und | | the | | www | +-------+ 36 rows in set (0.00 sec) 

•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” . 

## 26.4.17 The INFORMATION_SCHEMA INNODB_FT_DELETED Table 

The INNODB_FT_DELETED  table stores rows that are deleted from the FULLTEXT  index for an InnoDB table. To avoid expensive index reorganization during DML operations for an InnoDB FULLTEXT  index, the information about newly deleted words is stored separately, filtered out of search results when you do a text search, and removed from the main search index only when you issue an OPTIMIZE TABLE statement for the InnoDB  table. For more information, see Optimizing InnoDB Full-Text Indexes. 

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 ). 

