From: Manuel Arostegui
Date: September 19 2012 7:51pm
Subject: Re: InnoDB vs. other storage engines
List-Archive: http://lists.mysql.com/mysql/228200
Message-Id: <CAA8xrZfsgPQU9S0px=At4Q5Kg=f4VsO=m9B=Y4XHZBigGptmHQ@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=0015175cac4a050f1b04ca1357fd

--0015175cac4a050f1b04ca1357fd
Content-Type: text/plain; charset=ISO-8859-1

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?


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.

--0015175cac4a050f1b04ca1357fd--