Just curious, what cron jobs do you schedule for automatically
checking/repairing/analyzing/optimizing MyISAM tables?
I have been doing this periodically, manually for a while, but I
figured cron is the way to go.
Also, what parameters are you using? I am thinking of running the
If you use the 5.1 tree, you should be able to use the new EVENT stuff
to accomplish this:
http://dev.mysql.com/doc/refman/5.1/en/events.html
CREATE EVENT check_table ON SCHEDULE AT '2006-03-10 19:00:00' EVERY
WEEK DO your_check_table_procedure_here();
Or something like that..
On 3/10/06, René
In the last episode (Mar 10), Ren Fournier said:
Just curious, what cron jobs do you schedule for automatically
checking/repairing/analyzing/optimizing MyISAM tables?
I have been doing this periodically, manually for a while, but I
figured cron is the way to go.
Also, what parameters are