Show which storage engines are available in MySQL

Show which storage engines are available in MySQL

Answer:

To see which storage engines are available in MySQL server, use the following method:

# mysql -e 'show engines' | grep YES
MEMORY  YES     Hash based, stored in memory, useful for temporary tables
BLACKHOLE       YES     /dev/null storage engine (anything you write to it disappears)
ARCHIVE YES     Archive storage engine
CSV     YES     CSV storage engine
MRG_MYISAM      YES     Collection of identical MyISAM tables

MyISAM is not showed as it is the default engine.