Not everyone needs a innodb engine, although it makes up for MySQL's lack of transactional support, but its disk performance has always been a concern.
In addition to the older PHP system, mostly using the MyISAM engine in MySQL to build a table, it seems that InnoDB simply do not play, this time can consider the innodb ban off.
In MySQL 5.6, directly skip-innodb the previous comment, set it in My.ini:
Default-storage-engine=myisam
Default-tmp-storage-engine=myisam
The orange word above is a line that must be added, or MySQL will not start! The boot will automatically shut down.
In addition MySQL 5.6:5.5 occupies more physical memory, virtual memory and 5.5 use almost (5.5 is also a large virtual memory consumption). Performance increased by about 30% over 5.5 (according to official documentation, no specific tests were made).
Add: Not only that, the following configuration must also be added in [mysqld]. Otherwise, if you query to one of these states, a #2006 error occurs, causing MySQL to exit directly!!!
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
Loose-innodb-metrics=0
Loose-innodb-ft-default-stopword=0
Loose-innodb-ft-inserted=0
Loose-innodb-ft-deleted=0
Loose-innodb-ft-being-deleted=0
Loose-innodb-ft-config=0
Loose-innodb-ft-index-cache=0
Loose-innodb-ft-index-table=0
Loose-innodb-sys-tables=0
Loose-innodb-sys-tablestats=0
Loose-innodb-sys-indexes=0
Loose-innodb-sys-columns=0
Loose-innodb-sys-fields=0
Loose-innodb-sys-foreign=0
Loose-innodb-sys-foreign-cols=0
Disable InnoDB engine in MYSQL 5.6