[wp-hackers] OT: MySQL optimization

[Aubrey Kilian]

On 5/8/07, Chris Williams <chris at clwill.com> wrote:
> Did it yesterday, took only about 15 minutes to do the conversion.
>
> Read performance seems comparable or slightly better.  Interestingly, write
> performance is much improved.
>
> The one "gotcha" is that the database is now 9gb...  a 50% increase in size.
> Ouch.
>

That could talk to column types etc. though.  With some clever
normalization, you could decrease that size a bit.  CHAR vs VARCHAR
for fixed width rows etc.
I'm impressed that it took only 15 minutes.
So are you going to stick with innodb then?

-Aubrey