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.
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
