[wp-hackers] OT: MySQL optimization

[Chris Williams]

The one table I'm concerned about isn't on a blog, but it is 6.5gb with
~1M records, so this is good info.  Off to InnoDB I go...

Thanks.

-----Original Message-----
From: Matt Mullenweg
Subject: Re: [wp-hackers] OT: MySQL optimization

I don't know what it's doing behind the scenes, but I run InnoDB tables 
with 10s of GBs of data that have never had OPTIMIZE TABLE run on them 
and they perform great.

You may want to explore the .cnf settings here:

http://comox.textdrive.com/pipermail/wp-hackers/2006-December/009809.htm
l