InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables • INFORMATION_SCHEMA.INNODB_TABLES : a • INFORMATION_SCHEMA.INNODB_TABLESPACES : b • INFORMATION_SCHEMA.INNODB_TABLESTATS : c • INNODB_FT_CONFIG : Provides metadata about the  FULLTEXT  index and associated processing for an InnoDB  table. • INNODB_FT_BEING_DELETED : 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 3313 Table Overview 15.15.4 InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables An  IF()  control flow function is used to account for compressed tables. If a table is compressed, the index size is calculated using  ZIP_PAGE_SIZE  rather than  PAGE_SIZE .  CLUST_INDEX_SIZE  and OTHER_INDEX_SIZE , which are reported in bytes, are divided by  1024*1024  to provide index sizes in megabytes (MBs). MB values are rounded to zero decimal spaces using the  ROUND()  function. The following tables provide metadata for  FULLTEXT  indexes: mysql>  SHOW TABLES FROM INFORMATION_SCHEMA LIKE ’INNODB_FT%’; +-------------------------------------------+ | Tables_in_INFORMATION_SCHEMA (INNODB_FT%) | +-------------------------------------------+ | INNODB_FT_CONFIG | | INNODB_FT_BEING_DELETED | | INNODB_FT_DELETED | | INNODB_FT_DEFAULT_STOPWORD | | INNODB_FT_INDEX_TABLE | | INNODB_FT_INDEX_CACHE | +-------------------------------------------+ mysql>  SELECT a.NAME, a.ROW_FORMAT, @page_size := IF(a.ROW_FORMAT=’Compressed’, b.ZIP_PAGE_SIZE, b.PAGE_SIZE) AS page_size, ROUND((@page_size * c.CLUST_INDEX_SIZE) /(1024*1024)) AS pk_mb, ROUND((@page_size * c.OTHER_INDEX_SIZE) /(1024*1024)) AS secidx_mb FROM INFORMATION_SCHEMA.INNODB_TABLES a INNER JOIN INFORMATION_SCHEMA.INNODB_TABLESPACES b on a.NAME = b.NAME INNER JOIN INFORMATION_SCHEMA.INNODB_TABLESTATS c on b.NAME = c.NAME WHERE a.NAME LIKE ’employees/%’ ORDER BY a.NAME DESC; +------------------------+------------+-----------+-------+-----------+ | NAME | ROW_FORMAT | page_size | pk_mb | secidx_mb | +------------------------+------------+-----------+-------+-----------+ | employees/titles | Dynamic | 16384 | 20 | 11 | | employees/salaries | Dynamic | 16384 | 93 | 34 | | employees/employees | Dynamic | 16384 | 15 | 0 | | employees/dept_manager | Dynamic | 16384 | 0 | 0 | | employees/dept_emp | Dynamic | 16384 | 12 | 10 | | employees/departments | Dynamic | 16384 | 0 | 0 | +------------------------+------------+-----------+-------+-----------+