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
https://dev.mysql.com/doc/refman/5.7/en/innodb-storage-engine.html, and
https://dev.mysql.com/doc/refman/5.7/en/storage-engines.html.

URL: https://dev.mysql.com/doc/refman/5.7/en/show-engines.html

