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. SHOW TABLE
TYPES is a deprecated synonym.

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

