| CSV |
YES |
Stores tables as CSV files |
NO |
NO |
NO |
| 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 |
| Aria |
YES |
Crash-safe tables with MyISAM heritage. Used for internal temporary tables and privilege tables |
NO |
NO |
NO |
| MyISAM |
YES |
Non-transactional engine with good performance and small data footprint |
NO |
NO |
NO |
| SEQUENCE |
YES |
Generated tables filled with sequential values |
YES |
NO |
YES |
| InnoDB |
DEFAULT |
Supports transactions, row-level locking, foreign keys and encryption for tables |
YES |
YES |
YES |
| PERFORMANCE_SCHEMA |
YES |
Performance Schema |
NO |
NO |
NO |