====== Determine engine type ======

  mysql> SELECT TABLE_NAME, ENGINE FROM information_schema.TABLES;