No flames from me; I stay out of that religious war. However, the general consensus is to move to InnoDB. So, here are the gotchas. Most are non-issues; a few might bite you, but can probably be dealt with:
http://mysql.rjweb.org/doc.php/myisam2innodb > -----Original Message----- > From: Manuel Arostegui [mailto:man...@tuenti.com] > Sent: Wednesday, September 19, 2012 12:51 PM > To: Mark Haney > Cc: mysql mailing list > Subject: Re: InnoDB vs. other storage engines > > 2012/9/19 Mark Haney <ma...@abemblem.com> > > > I hope this doesn't end in some kind of flame war. I'm looking to > > optimize my tables (and performance in general) of the DB my web app > > is using. I'm tweaking things a little at a time, but I'm curious as > > to what the rest of the MySQL list thinks about changing my storage > > engine from InnoDB to something else so I can optimize the tables on > a regular basis. > > > > Is it worth the effort? Any caveats? > > > Hi Mark, > > I would depend on what your workload would be. Mostly writes, mostly > reads, how many writes/reads do you expect etc. > The best approach, from my point of view, would be, firstly, tune your > MySQL server (if you've not done it yet) before getting into > engine/tables optimizations which can be more complicated. > > Manuel. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql