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
> t
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 to
MySQLfront (www.mysqlfront.de) displays all the output from show status in
the host tab when you connect.
-Original Message-
From: Alex Pilson [mailto:[EMAIL PROTECTED]]
Sent: 04 April 2002 07:15
To: John Klein
Cc: [EMAIL PROTECTED]
Subject: Re: Keeping MySQL Databases Heathly
At 10:09
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
[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 actuall
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?
Thanks.
--
<-