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.
