[wp-hackers] OT: MySQL optimization

Aubrey Kilian aubreykilian at gmail.com
Wed May 9 05:56:58 GMT 2007

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?


More information about the wp-hackers mailing list