The INFORMATION_SCHEMA INNODB_INDEXES Table on the indexed table with the  innodb_optimize_fulltext_only  system variable enabled. (The example disables that variable again at the end because it is intended to be enabled only temporarily.) mysql>  USE test; mysql>  CREATE TABLE articles ( id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, title VARCHAR(200), body TEXT, FULLTEXT (title,body) ) ENGINE=InnoDB; mysql>  INSERT INTO articles (title,body) VALUES (’MySQL Tutorial’,’DBMS stands for DataBase ...’), (’How To Use MySQL Well’,’After you went through a ...’), (’Optimizing MySQL’,’In this tutorial we show ...’), (’1001 MySQL Tricks’,’1. Never run mysqld as root. 2. ...’), (’MySQL vs. YourSQL’,’In the following database comparison ...’), (’MySQL Security’,’When configured properly, MySQL ...’); mysql>  SET GLOBAL innodb_optimize_fulltext_only=ON; mysql>  OPTIMIZE TABLE articles; +---------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------+----------+----------+----------+ | test.articles | optimize | status | OK | +---------------+----------+----------+----------+ mysql>  SET GLOBAL innodb_ft_aux_table = ’test/articles’; mysql>  SELECT WORD, DOC_COUNT, DOC_ID, POSITION FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE LIMIT 5; +------------+-----------+--------+----------+ | WORD | DOC_COUNT | DOC_ID | POSITION | +------------+-----------+--------+----------+ | 1001 | 1 | 4 | 0 | | after | 1 | 2 | 22 | | comparison | 1 | 5 | 44 | | configured | 1 | 6 | 20 | | database | 2 | 1 | 31 | +------------+-----------+--------+----------+ mysql>  SET GLOBAL innodb_optimize_fulltext_only=OFF; •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” . • INDEX_ID 26.4.20 The INFORMATION_SCHEMA INNODB_INDEXES Table The  INNODB_INDEXES  table provides metadata about  InnoDB  indexes. For related usage information and examples, see Section 15.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables” . The  INNODB_INDEXES  table has these columns: 4868