どのテーブルがINNODBで、どのテーブルがMyISAMなのか確認できる。
mysql> SELECT table_name, engine, table_schema FROM information_schema.tables; +------------------------------------------------+--------+--------------------+ | table_name | engine | table_schema | +------------------------------------------------+--------+--------------------+ | dtb_baseinfo | InnoDB | eccube_db | | dtb_best_products | InnoDB | eccube_db | | dtb_best_products_best_id_seq | MyISAM | eccube_db | | dtb_bkup | InnoDB | eccube_db | | dtb_bloc | InnoDB | eccube_db | | dtb_bloc_bloc_id_seq | MyISAM | eccube_db | | dtb_blocposition | InnoDB | eccube_db | | dtb_category | InnoDB | eccube_db | | dtb_category_category_id_seq | MyISAM | eccube_db | | dtb_category_count | InnoDB | eccube_db | | dtb_category_total_count | InnoDB | eccube_db | ・ ・ ・