为什么Myisam存储引擎比Innodb存储引擎快 [英] Why is myisam storage engine is faster than Innodb storage engine
问题描述
为什么myisam存储引擎比Innodb存储引擎快
Why is myisam storage engine is faster than Innodb storage engine
是什么使它变得更快而innodb却变得很慢?
what makes it to be faster and innodb to be slow?
推荐答案
MyISAM比innodb更快,因为它具有更简单的设计.此外,它已经存在了很长的时间,并且有更多的时间根据实际使用情况的数据来积累增量改进和优化.
MyISAM can be faster than innodb because it has a simpler design. Also it has been around a much longer time, and has more time to accumulate incremental improvements and optimizations based on data on real usage.
MyISAM的设计基于ISAM: http://en.m.wikipedia.org/Wiki/ISAM
Design of MyISAM is based on ISAM: http://en.m.wikipedia.org/wiki/ISAM
速度是有代价的:MyISAM不支持事务或外键.这意味着它最适合用于保存和分析日志数据,以及作为数据挖掘和数据仓库技术的后端,而innodb则更适合事务处理和一般用作信息系统的存储层.
The speed comes with a price though: MyISAM does not support transactions or foreign keys. This means it is optimal for example for saving and analyzing log data, and as a backend for data mining and data warehouse technologies, while innodb is better for transaction processing and as the storage layer of information systems in general.
Wikipedia在此处对MySQL存储引擎进行了很好的比较: http://en.m.wikipedia .org/wiki/Comparison_of_MySQL_database_engines
Wikipedia has a nice comparison of MySQL storage engines here: http://en.m.wikipedia.org/wiki/Comparison_of_MySQL_database_engines
这篇关于为什么Myisam存储引擎比Innodb存储引擎快的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!