Random Linux

Linux, video games and web hosting

If you need to find out the available storage engines for MySQL, such as InnoDB, you can run the following command.

mysql -Bse 'show engines'

That will output the engines and their availability, and will look something like this.

[email protected] [~]# mysql -Bse ‘show engines’
MyISAM  DEFAULT Default engine as of MySQL 3.23 with great performance
MEMORY  YES     Hash based, stored in memory, useful for temporary tables
InnoDB  YES     Supports transactions, row-level locking, and foreign keys
BerkeleyDB      YES     Supports transactions and page-level locking
BLACKHOLE       NO      /dev/null storage engine (anything you write to it disappears)
EXAMPLE NO      Example storage engine
ARCHIVE NO      Archive storage engine
CSV     NO      CSV storage engine
ndbcluster      NO      Clustered, fault-tolerant, memory-based tables
FEDERATED       NO      Federated MySQL storage engine
MRG_MYISAM      YES     Collection of identical MyISAM tables
ISAM    NO      Obsolete storage engine

January 28th, 2011

Posted In: How To, MySQL


Leave a Reply

Your email address will not be published. Required fields are marked *