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