• FILES 

• INNODB_COLUMNS 

• INNODB_DATAFILES 

• INNODB_FIELDS 

• INNODB_FOREIGN 

• INNODB_FOREIGN_COLS 

• INNODB_INDEXES 

• INNODB_TABLES 

• INNODB_TABLESPACES 

• INNODB_TABLESPACES_BRIEF 

• INNODB_TABLESTATS 

• KEY_COLUMN_USAGE 

• KEYWORDS 

• PARAMETERS 

• PARTITIONS 

• REFERENTIAL_CONSTRAINTS 

• RESOURCE_GROUPS 

• ROUTINES 

• SCHEMATA 

• STATISTICS 

• ST_GEOMETRY_COLUMNS 

• ST_SPATIAL_REFERENCE_SYSTEMS 

• TABLES 

• TABLE_CONSTRAINTS 

• TRIGGERS 

• VIEWS 

• VIEW_ROUTINE_USAGE 

• VIEW_TABLE_USAGE 

Queries on those tables are now more efficient because they obtain information from data dictionary tables rather than by other, slower means. In particular, for each INFORMATION_SCHEMA  table that is a view on data dictionary tables: 

