Storage Engine | Description |
---|---|
FEDERATED | Federated MySQL storage engine |
MRG_MYISAM | Collection of identical MyISAM tables |
MyISAM | MyISAM storage engine |
BLACKHOLE | /dev/null storage engine (anything you write to it disappears) |
CSV | CSV storage engine |
MEMORY | Hash based, stored in memory, useful for temporary tables |
ARCHIVE | Archive storage engine |
InnoDB | Supports transactions, row-level locking, and foreign keys |
PERFORMANCE_SCHEMA | Performance Schema |