MyISAM not necessarily faster than InnoDB

491 days ago

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.