[wp-hackers] OT: MySQL optimization

[Chris Williams]

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
good thing.

 

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
fine/great.

 

Chris