高性能MySQL第二版中的一个过时表述

最新推荐文章于 2022-11-27 10:44:45 发布

chuancu0042

最新推荐文章于 2022-11-27 10:44:45 发布

阅读量198

点赞数

文章标签：数据库

原文链接：https://my.oschina.net/u/244278/blog/3097922

版权

在高性能MySQL第二版中文版的1.5.1小节中,在MySQL架构第一章中介绍：

作为MySQL的默认存储引擎，在性能和可用特征之间，MyISAM提供一种良好的平衡，

这些特征包括全文检索，压缩，空间函数。MyISAM不支持事务和行级锁。

这是因为写书是MySQL的版本还没有到5.1

https://dev.mysql.com/doc/refman/5.5/en/innodb-introduction.html

InnoDB is a general-purpose storage engine that balances high reliability and high performance. Starting from MySQL 5.5.5, the default storage engine for new tables is InnoDB rather than MyISAM. Unless you have configured a different default storage engine, issuing a CREATE TABLE statement without an ENGINE= clause creates an InnoDB table. Given this change of default behavior, MySQL 5.5 might be a logical point to evaluate whether tables that use MyISAM could benefit from switching to InnoDB.

在5.5.5之后，InnoDB已经成为了MySQL的默认存储引擎

InnoDB includes all the features that were part of the InnoDB Plugin for MySQL 5.1, plus new features specific to MySQL 5.5 and higher.

转载于:https://my.oschina.net/u/244278/blog/3097922