mysql - How much faster is MyISAM compared to InnoDB?

Question

People say InnoDB is not so fast like MyISAM. But how much slower? Just as a rule of thumb in the wind, of course. I mean... is it usually 0.5x as fast as MyISAM? or even worse? Or does the average visitor not recognize any temporal difference when surfing an MyISAM platform vs. same thing with InnoDB?

Answer 1

I'd be very surprised if you noticed any practical real world difference unless you're running a very large/resource intensive web site.

There are some (albeit quite old) benchmarks out there (here for example), but your experience will obviously differ depending on your specific usage pattern.