"MySQL 테이블 스토리지 엔진 확인"의 두 판 사이의 차이

2015년 7월 1일 (수) 17:11 판

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

1 방법1: SHOW TABLES STATUS

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

@@ 3번째 줄: / 3번째 줄: @@
 ==방법1: SHOW TABLES STATUS==
-<source lang='mysql'>
+<source lang='cli'>
 mysql> SHOW TABLE STATUS WHERE name='user';
 +------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------+----------+----------------+---------+