[wp-hackers] OT: MySQL optimization
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.
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