14.1.5 Turning Off InnoDB

Oracle recommends InnoDB as the preferred
storage engine for typical database applications, from single-user
wikis and blogs running on a local system, to high-end
applications pushing the limits of performance. In MySQL
5.6, InnoDB is the default storage
engine for new tables.

As of MySQL 5.6.21, the
--skip-innodb
option still works but it is deprecated and will return a
warning when used. It will be removed in a future MySQL
release. This also applies to its synonyms
(--innodb=OFF,
--disable-innodb, and so forth).

To prevent the server from crashing when the
InnoDB-related
information_schema tables are
queried, also disable the plugins associated with those
tables. Specify in the [mysqld] section of
the MySQL configuration file: