-------------- select "Show Engines" --------------
Show Engines
Show Engines
-------------- show engines --------------
EngineSupportCommentTransactionsXASavepoints
InnoDBYESSupports transactions, row-level locking, and foreign keysYESYESYES
MRG_MYISAMYESCollection of identical MyISAM tablesNONONO
BLACKHOLEYES/dev/null storage engine (anything you write to it disappears)NONONO
CSVYESCSV storage engineNONONO
MEMORYYESHash based, stored in memory, useful for temporary tablesNONONO
FEDERATEDNOFederated MySQL storage engineNULLNULLNULL
ARCHIVEYESArchive storage engineNONONO
MyISAMDEFAULTDefault engine as of MySQL 3.23 with great performanceNONONO