2012/9/19 Mark Haney <markh@stripped>
> 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?
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.