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 synonym, but is deprecated and is removed in MySQL 5.5.

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

