存储引擎 | 说明 |
---|---|
Aria | Crash-safe tables with MyISAM heritage. Used for internal temporary tables and privilege tables |
MRG_MyISAM | Collection of identical MyISAM tables |
MEMORY | Hash based, stored in memory, useful for temporary tables |
BLACKHOLE | /dev/null storage engine (anything you write to it disappears) |
MyISAM | Non-transactional engine with good performance and small data footprint |
CSV | Stores tables as CSV files |
ARCHIVE | gzip-compresses tables for a low storage footprint |
InnoDB | Supports transactions, row-level locking, foreign keys and encryption for tables |
PERFORMANCE_SCHEMA | Performance Schema |
SEQUENCE | Generated tables filled with sequential values |