Linux Ask!

Linux Ask! is a Q & A web site specific for Linux related questions. Questions are collected, answered and audited by experienced Linux users.

Jul 022010

Show which storage engines are available in MySQL


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.

 Leave a Reply



You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>