MySql：MyISAM vs. Inno DB！ [英] MySql: MyISAM vs. Inno DB!

问题描述

MySAM和Inno DB类型在MySql中有什么区别？

What are the differences between MyISAM and Inno DB types in MySql?

推荐答案

主要区别是InnoDB支持事务MyISAM不会。

The main difference is that InnoDB supports transactions while MyISAM does not.

还有很多其他的差异，但我知道的是：

There are numerous other differences, however the common one's i am aware of are:

• MyISAM通常被认为搜索速度更快，但最近的InnoDB改进正在消除这种差异并改善高并发工作负载性能。


• InnoDB支持事务， li>
  
• InnoDB处理索引的方式有点不同，将主键存储为每个索引的一部分（使索引在磁盘上占用更多空间，但也更容易创建覆盖索引）


• MyISAM执行表级锁定，而InnoDB可以执行行级锁定


• MySQL配置文件中使用不同的内存/缓冲区/索引设置


• InnoDB通常被称为有更好的崩溃恢复


• 如另一个答案中所提到的，数据存储在磁盘上的方式不同。我相信InnoDB在这个领域是可配置的，如果需要可以有一个文件每个表等

• MyISAM has typically been considered faster at searching, but recent InnoDB improvements are removing this difference and improving high concurrency workload performance
• InnoDB support transactions whilst MyISAM does not
• InnoDB handles indexes a bit differently, storing the primary key as part of every index (making indexes take up more room on the disk, but also making a covering index more likely)
• MyISAM does table level locking while InnoDB can do row level locking
• Different memory/buffer/index settings are used in the MySQL configuration files
• InnoDB is typically said to have better crash recovery
• As mentioned in another answer, the data is store on disk differently. I believe InnoDB is configurable in this area and can have one file per table etc. if required

我确定google搜索或MySQL网站将提出更多细节的许多其他差异。

I'm sure a google search or the MySQL site will bring up numerous other differences in more detail.

这篇关于MySql：MyISAM vs. Inno DB！的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！