MySQL 스토리지 엔진, SHOW ENGINES

MySQL storage engines

MySQL 스토리지 엔진

SHOW ENGINES

1 주요 스토리지 엔진

스토리지 엔진	설명
InnoDB	기본 엔진, 트랜잭션, 외래키 지원 ★
MyISAM	비트랜잭션
MEMORY (HEAP)	해시 기반, 메모리 DB, 비트래잭션, 임시 테이블에 적절함
CSV
ARCHIVE
MERGE (MRG_MYISAM)

2 SHOW ENGINES

mysql> SHOW ENGINES;
+--------------------+---------+----------------------------------------------------------------+--------------+------+-------
| Engine             | Support | Comment                                                        | Transactions | XA   | Savepo
+--------------------+---------+----------------------------------------------------------------+--------------+------+-------
| FEDERATED          | NO      | Federated MySQL storage engine                                 | NULL         | NULL | NULL  
| MRG_MYISAM         | YES     | Collection of identical MyISAM tables                          | NO           | NO   | NO    
| MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables      | NO           | NO   | NO    
| BLACKHOLE          | YES     | /dev/null storage engine (anything you write to it disappears) | NO           | NO   | NO    
| MyISAM             | YES     | MyISAM storage engine                                          | NO           | NO   | NO    
| CSV                | YES     | CSV storage engine                                             | NO           | NO   | NO    
| ARCHIVE            | YES     | Archive storage engine                                         | NO           | NO   | NO    
| PERFORMANCE_SCHEMA | YES     | Performance Schema                                             | NO           | NO   | NO    
| InnoDB             | DEFAULT | Supports transactions, row-level locking, and foreign keys     | YES          | YES  | YES   
+--------------------+---------+----------------------------------------------------------------+--------------+------+-------
9 rows in set (0.02 sec)

3 같이 보기

• MySQL

4 참고 자료

• http://dev.mysql.com/doc/refman/5.0/en/storage-engines.html