[wp-hackers] OT: MySQL optimization

[Matt Mullenweg]

Chris Williams wrote:
> So, with InnoDB it's all magic and the index reorganization happens as it
> goes along?  All indexes need to get adjusted as changes (especially
> deletes) happen, does InnoDB do this behind the scenes?

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.html

-- 
Matt Mullenweg
  http://photomatt.net | http://wordpress.org
http://automattic.com | http://akismet.com