Determine engine type

mysql> SELECT TABLE_NAME, ENGINE FROM information_schema.TABLES;