Syntax:
SHOW [STORAGE] ENGINES

SHOW ENGINES displays status information about the server's storage
engines. This is particularly useful for checking whether a storage
engine is supported, or to see what the default engine is.

For information about MySQL storage engines, see
http://dev.mysql.com/doc/refman/5.5/en/innodb-storage-engine.html, and
http://dev.mysql.com/doc/refman/5.5/en/storage-engines.html.

URL: http://dev.mysql.com/doc/refman/5.5/en/show-engines.html

