We run a CHECK TABLE nightly on every table (see:
http://www.mysql.com/doc/C/H/CHECK_TABLE.html) and I would HIGHLY
recommend doing so. If the check table fails, we run a REPAIR TABLE. We
also used to do a REPAIR TABLE EXTENDED on weekends to optimize indexes
until our db got too big for that
And here's a script that will do the check/repair for you. It has some
custom logging libs in it that you'll have to remove to make it work
(Admutil and Getpassword), but you'll get the general idea.
Alex Pilson wrote:
Do MySQL server administrators recommend running a cron script daily
to
[EMAIL PROTECTED] wrote:
Do MySQL server administrators recommend running a cron script daily
to isamchk?
Is there any other things that should be run daily to keep MySQL
running top-notch? If so, does anyone have any pointers to a script
that has already been developed?
I actually find
At 10:09 AM -0500 4/4/02, John Klein wrote:
[EMAIL PROTECTED] wrote:
Do MySQL server administrators recommend running a cron script daily
to isamchk?
Is there any other things that should be run daily to keep MySQL
running top-notch? If so, does anyone have any pointers to a script