Hi,

I am writing a maintenance-deamon which is executing
CHECK TABLE, ANALYZE TABLE and OPTIMIZE TABLE once at
night.
If CHECK TABLE fails for at least one table, then the
rest will be skipped.
The question is if the order of the statements is ok
this way. A second question would be, if I should run
a REPAIR statement automatically if CHECK fails.
Are there any more tasks that I should perform nightly
in order to keep my database healthy and in a "high 
performance shape"?
And another general question: Do I have to take down
my Application that is using the MySQL-DB in order to
perform the CHECK, ANALYZE and OPTIMZE commands?

thanks in advance,
Peter

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to