Hi,
I use all this in the same order and i don't have any problems:
CHECK TABLE
IF (CHECK TABLE!=OK)
{
REPAIR TABLE
}
// i don't use analyze tables
OPTIMIZE TABLE
Before to perform this commands, you must be sure is not any users connected
(show full processlist;)
> Yes you are right
> We lock tables to run this but only when we have problems.
> One more thing I would do is run 'show processlist' and mail it to my self
> to see how thing are going.
> Simon
> PS have you tried mytop?
No, I did not try mytop, but I'll give it a try now :)
Another quest
Would you not be better of just runing myisamchk from crontab?
Simon
./myisamchk Ver 1.52 for unknown-freebsdelf4.1 at i386
By Monty, for your professional use
This software comes with NO WARRANTY: see the PUBLIC for details.
Description, check and repair of ISAM tables.
Used without options
