[wp-hackers] OT: MySQL optimization
m at mullenweg.com
Tue May 8 00:03:02 GMT 2007
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://photomatt.net | http://wordpress.org
http://automattic.com | http://akismet.com
More information about the wp-hackers