[wp-hackers] OT: MySQL optimization

[Matt Mullenweg]

Chris Williams wrote:
> Now that I'm using MySQL for more stuff, I see and have used the
> "optimize table" command, but is there an equivalent of the job
> scheduler so that I can tell it to just do this every so often?  I have
> one db that has a table with about a million records, and it gets adds
> and deletes constantly.  Clearly some kind of regular maintenance is a
> good thing.

OPTIMIZE isn't that important, you'd get more mileage out of just 
switching to InnoDB.

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