MySQL Forums
Forum List  »  Performance

mysqlcheck on Unix
Posted by: Trevor White
Date: June 21, 2005 02:31AM

We are having problems with some of our servers whereas certain tables keep on becoming corrupt (don't know why this keeps happening yet).

Luckily mysqlcheck can repair these but it hammers the CPU and locks out all users. Is there any way mysqlcheck can be run at a lower priority so the users not using that particular table can sort of run.

Even a read only mode that didn't lock the table at all would be good to find out if the table is in fact corrupt.

Unfortunately we're running on Sco Unix 5.07 (single threading).

Thanks for your help.

Options: ReplyQuote


Subject
Views
Written By
Posted
mysqlcheck on Unix
2097
June 21, 2005 02:31AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.