mysql-refManual-5.7(第三天)

最新推荐文章于 2024-11-26 09:41:13 发布

原创最新推荐文章于 2024-11-26 09:41:13 发布 · 491 阅读

0 ·

CC 4.0 BY-SA版权

mysql 专栏收录该内容

21 篇文章

订阅专栏

自MySQL 5.5版本起，默认存储引擎由MyISAM更改为InnoDB。InnoDB在全文搜索、读多写少场景及只读媒体应用方面进行了优化，并支持全文索引类型。此外，即使在5.6及以上版本中，mysql和information_schema数据库仍使用MyISAM。

MySQL has a well-earned reputation for being easy-to-use and delivering performance and scalability.
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.