Prior to MySQL 5.5, MyISAM was the default storage engine. In our experience, most users never
changed the default settings. In MySQL 5.5 and higher,InnoDBis the default storage engine
MySQL continues to work on addressing use
cases that formerly required
MyISAM tables. In MySQL
5.6 and higher:
•InnoDB
can perform full-text search using the
FULLTEXT
index type. See Section 14.2.14.3,
“FULLTEXTIndexes”
for details.
•
InnoDB now performs better with read-only or read-mostly workloads. Automatic optimizations apply
to
InnoDB queries in
autocommit mode, and you can explicitly mark transactions as read-only with
the syntax
START TRANSACTION READ ONLY. See
Section 14.13.14, “Optimizing
InnoDB ReadOnly Transactions”
for details.
• Applications distributed on read-only media can now useInnoDB
tables. See
Section 14.3.1,
“Configuring
InnoDB for Read-Only Operation”
for details
Themysqland
information_schema
databases, that implement some of the MySQL internals, still
use
MyISAM. In particular, you cannot switch the grant tables to useInnoDB.
自MySQL 5.5版本起,默认存储引擎由MyISAM更改为InnoDB。InnoDB在全文搜索、读多写少场景及只读媒体应用方面进行了优化,并支持全文索引类型。此外,即使在5.6及以上版本中,mysql和information_schema数据库仍使用MyISAM。

被折叠的 条评论
为什么被折叠?



