List:General Discussion« Previous MessageNext Message »
From:Gary Richardson Date:March 11 2006 1:10am
Subject:Re: Care and feeding of MySQL tables (aka Preventative Maintenance via Cron)
View as plain text  
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é Fournier <m5@stripped> wrote:
> 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/mysql?unsub=1
>
>
Thread
Care and feeding of MySQL tables (aka Preventative Maintenance via Cron)RenĂ© Fournier11 Mar
  • Re: Care and feeding of MySQL tables (aka Preventative Maintenance via Cron)Gary Richardson11 Mar
  • Re: Care and feeding of MySQL tables (aka Preventative Maintenance via Cron)Dan Nelson11 Mar