Show tables by engine in MySQL

Use INFORMATION_SCHEMA.TABLES table:

SELECT table_name FROM INFORMATION_SCHEMA.TABLES
  WHERE engine="InnoDB"