[wp-hackers] OT: MySQL optimization
chris at clwill.com
Mon May 7 20:41:19 GMT 2007
This could well be considered completely OT, but I'm looking for some
guidance from some serious MySQL folks... so here I am.
I've used MS SQL for more than a decade. I understand the regular
required maintenance it requires (at least weekly checks and
optimizations). There is a job scheduler to make this easy.
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
Thanks for your tolerance for this OT question, if you want to point me
to a more appropriate forum or to reply off-list that would be
More information about the wp-hackers