db table 엔진확인 및 변경
페이지 정보

본문
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)
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)
- 이전글ERROR 1044 (42000): Access denied for user 20.11.24
- 다음글mysql 프로세스에서 unauthenticated user 확인시 20.11.24
댓글목록
등록된 댓글이 없습니다.