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)
mysqlcheck --all-databases --analyse (weekly)
mysqlcheck --all-databases --optimize (weekly)

Good idea? Bad? Or just plain ugly?

...Rene

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to