-------------- show engines --------------
EngineSupportCommentTransactionsXASavepoints
FEDERATEDNOFederated MySQL storage engineNULLNULLNULL
MRG_MYISAMYESCollection of identical MyISAM tablesNONONO
MyISAMYESMyISAM storage engineNONONO
BLACKHOLEYES/dev/null storage engine (anything you write to it disappears)NONONO
CSVYESCSV storage engineNONONO
MEMORYYESHash based, stored in memory, useful for temporary tablesNONONO
ARCHIVEYESArchive storage engineNONONO
InnoDBDEFAULTSupports transactions, row-level locking, and foreign keysYESYESYES
PERFORMANCE_SCHEMAYESPerformance SchemaNONONO