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 you using? I am thinking of running the
> following cron jobs:
> mysqlcheck --all-databases --auto-repair (daily)
If a daily repair is required, you have serious problems. If you ever
get corrupt tables at all (barring things like unexpected power
outages), you have problems, and should try and narrow down the cause
rather than look the other way and repair the damage :)
> mysqlcheck --all-databases --analyse (weekly)
> mysqlcheck --all-databases --optimize (weekly)
optimize does an analyze while it rebuilds the index file.