News for hackers. Stuff that matters.
Re:The MySQL MyISAM and InnoDB engines and a grocery checkout by idlewords on Tuesday October 13, 2009 @01:04PM (#879503)
The analogy is helpful, but leaves some things out. In one of the grocery stores, you'll find that if the lights flicker off and for just a second, half the products on the shelves may end up unusable. And if your store gets past a certain size, a sinkhole may appear and suck most of your inventory underground with no warning.

The only reason I can think of for using MyISAM tables in a web app is the terrible default InnoDB settings in MySQL. Users unfamiliar with InnoDB may not realize that the awful performance is an artifact of bad configuration, and easily fixed.

Re:The MySQL MyISAM and InnoDB engines and a grocery checkout by towndrunk on Tuesday October 13, 2009 @01:51PM (#879626)
Can you provide some info or a link on this config change.

Thanks!

Re:The MySQL MyISAM and InnoDB engines and a grocery checkout by idlewords on Tuesday October 13, 2009 @01:58PM (#879634)
This is handy: http://www.mysqlperformanceblog.com/2007/11/01/innodb-perfor...

Lots of good InnoDB-related posts on their site.

Re:The MySQL MyISAM and InnoDB engines and a grocery checkout by towndrunk on Tuesday October 13, 2009 @02:33PM (#879737)
Good stuff to know. Thanks.
Re:The MySQL MyISAM and InnoDB engines and a grocery checkout by bhseo on Tuesday October 13, 2009 @01:32PM (#879568)
Even after you've spent days tweaking the performance, you are still left with a fundamentally slower engine.
Re:The MySQL MyISAM and InnoDB engines and a grocery checkout by munctional on Tuesday October 13, 2009 @07:42PM (#880343)
I'd rather have a consistent database than a fast one!