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. As of MySQL 5.5, InnoDB is the default storage engine for new tables.
If you do not want to use InnoDB tables:
Because the default storage engine is
InnoDB, the server will not start unless
you also use
--default-storage-engine to set
the default to some other engine.
To prevent the server from crashing when the
information_schema tables are
queried, also disable the plugins associated with those
tables. Specify in the
[mysqld] section of
the MySQL configuration file:
loose-innodb-trx=0 loose-innodb-locks=0 loose-innodb-lock-waits=0 loose-innodb-cmp=0 loose-innodb-cmp-per-index=0 loose-innodb-cmp-per-index-reset=0 loose-innodb-cmp-reset=0 loose-innodb-cmpmem=0 loose-innodb-cmpmem-reset=0 loose-innodb-buffer-page=0 loose-innodb-buffer-page-lru=0 loose-innodb-buffer-pool-stats=0
Copyright © 1997, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices