MyISAM not necessarily faster than InnoDB

Jan 11, 10:49 am

It’s been a long standing belief that MyISAM tables are significantly faster than InnoDB tables when performing mostly read applications as would be the case for the majority of web applications out there. It’s one of those things that everybody just took at face value. Well, the guys over at MySQL Performance Blog have shot down that myth.

In a posting titled InnoDB vs MyISAM vs Falcon benchmarks – part 1, their primary goal was to benchmark the new Falcon storage engine against MyISAM and InnoDB. Of course, the by-product is that we also have benchmarks for MyISAM vs. InnoDB. The results they present should make anybody think twice about which storage engine to use in their next project.




Add your comments

Please keep your comments relevant to this blog entry: inappropriate or purely promotional comments may be removed. To add hyperlink, please follow this example: "your link text":http://your.link.url