본문 바로가기

쓰기

db table 엔진확인 및 변경

haru 2017.11.28 11:18 조회 수 : 82

1. table db engine 확인

 

mysql> show table status like ‘{테이블명}’ \G

 

mysql> show table status like ‘t_faq’ \G
*************************** 1. row ***************************
Name: t_faq
Engine: MyISAM
Version: 10
Row_format: Compact
Rows: 0
Avg_row_length: 0
Data_length: 16384
Max_data_length: 0
Index_length: 0
Data_free: 8388608
Auto_increment: 1
Create_time: 2015-01-22 10:32:25
Update_time: NULL
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options: 
Comment: FAQ
1 row in set (0.00 sec)

 

 

2. table db engine 변경

 

mysql> alter table {테이블명} engine={변경할 엔진명};

 

mysql> alter table t_faq engine=innodb;
Query OK, 0 rows affected (0.14 sec)

Records: 0 Duplicates: 0 Warnings: 0

 

mysql> show table status like ‘t_faq’ \G
*************************** 1. row ***************************
Name: t_faq
Engine: InnoDB
Version: 10
Row_format: Dynamic
Rows: 0
Avg_row_length: 0
Data_length: 0
Max_data_length: 281474976710655
Index_length: 1024
Data_free: 0
Auto_increment: 1
Create_time: 2015-06-09 11:12:01
Update_time: 2015-06-09 11:12:01
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options: 
Comment: FAQ
1 row in set (0.00 sec)