MySQL 테이블 스토리지 엔진 확인

How to find out MySQL engine type for a specific table
MySQL 테이블 스토리지 엔진 확인

1 방법1: SHOW TABLES STATUS

SHOW TABLE STATUS WHERE name='테이블명';

mysql> SHOW TABLE STATUS WHERE name='user';
+------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------+----------+----------------+---------+
| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time         | Update_time | Check_time | Collation | Checksum | Create_options | Comment |
+------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------+----------+----------------+---------+
| user | InnoDB |      10 | Compact    |   37 |            442 |       16384 |               0 |        49152 |   7340032 |             41 | 2014-12-13 03:51:25 | NULL        | NULL       | binary    |     NULL |                |         |
+------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------+----------+----------------+---------+
1 row in set (0.00 sec)

2 같이 보기

3 참고 자료

http://stackoverflow.com/questions/213543/how-can-i-check-mysql-engine-type-for-a-specific-table