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. This
information can also be obtained from the INFORMATION_SCHEMA ENGINES
table. See http://dev.mysql.com/doc/refman/5.5/en/engines-table.html.

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

