从MyISAM迁移到InnoDB [英] Migrating from MyISAM to InnoDB

问题描述

我已经对该主题进行了一些搜索，并找到了一些结果.但是，我正在寻找是否有人知道或可以将我引向一些真实的或著名的案例研究，这些案例研究详细说明了从MyISAM迁移到InnoDB的好处(尤其是性能).

很好，如果您可以指向与MySQL 5.5及更高版本有关的任何内容，该版本将InnoDb作为默认存储引擎.

解决方案

正如您毫无疑问地从搜索中了解到的那样，对于大容量的插入(不算在内键或全文之类的不可比功能方面，InnoDB主要优于MyISAM)搜索，这分别是InnoDB和MyISAM独有的)，而MyISAM主要用于读取频率比写入频率高的表.

也就是说， MySQL Performance Blog 中的一篇文章可能与您的特定兴趣:

以高速率插入MySQL和Innodb

在较小程度上，该SO问题也是如此: MyISAM与InnoDB .

还有有关从MyISAM迁移到InnoDB ，尽管我没有看过.该描述似乎与将InnoDB设置为默认值的MySQL 5.5相对应，因此，再次说明，它可能会很有用.您可以直接在http://blip.tv/file/4905943 上访问. >

I've searched a bit on this topic and found a few results. However, I'm looking for if anyone knows about or could point me to to some authentic or reputable case studies that detail the benefits(particularly performance) of migrating from MyISAM to InnoDB.

Nice if you could point to any that is about MySQL version 5.5 and above which has InnoDb as default storage engine.

解决方案

As you are no doubt aware from your searches, InnoDB is primarily better than MyISAM for high volume inserts (not counting non-comparable features like Foreign Keys or Full Text searches, which are exclusive to InnoDB and MyISAM, respectively), while MyISAM is primarily useful for tables which are read more often than they are written to.

That said, an article from the MySQL Performance Blog is perhaps relevant to your particular interests:

High Rate insertion with MySQL and Innodb

To a lesser extent, this SO question as well: MyISAM vs InnoDB.

EDIT:

There is also a webinar about migrating from MyISAM to InnoDB, although I have not watched it. The description seems to deal with MySQL 5.5 having made InnoDB the default, though, so again, perhaps it will be useful. You can access the webinar directly at http://blip.tv/file/4905943.

这篇关于从MyISAM迁移到InnoDB的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！