How would I show all tables in MySQL with a given engine, e.g. InnoDB, MyISAM, FEDERATED?
Use INFORMATION_SCHEMA.TABLES table:
INFORMATION_SCHEMA.TABLES
SELECT table_name FROM INFORMATION_SCHEMA.TABLES WHERE engine = 'InnoDB'