Nov 11, 2017

Show tables by engine in MySQL


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