====== 07 INNODB/MyISAM 確認方法 ======

どのテーブルがINNODBで、どのテーブルがMyISAMなのか確認できる。

<code>
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          |
・
・
・
</code>

{{tag>MySQL}}