Care and feeding of MySQL tables (aka Preventative Maintenance via Cron)

[René Fournier]

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