MySQL Forums
Forum List  »  MyISAM

How to avoid 'Repair with keycache'
Posted by: Martin Feng
Date: September 07, 2006 10:16PM

Hi

I set

myisam-recover=BACKUP,FORCE

in my.cnf.

MySQL server restarts by itself after 1 months continuous heavy usage, then it takes more than 40 hrs to check a table having 40 million records, each record contains an unsigned int column and a char(32) column. The unsigned int column is primary key and there is an unique key on the char(32) column. 'show processlist' says 'Repair with keycache'.

40 hrs is too long, it would be much faster to rebuild the index with alter table, maybe that's what 'repair by sort' does.

How to avoid 'Repair with keycache' from happening? I set the DELAY_KEY_WRITE to 1 for this table, now I turn it off for this table. What else do I need to do?

My enviromnent:

OS: CentOS 4.3
DB: CHARACTER SET utf8 COLLATE utf8_general_ci

MySQL 5.0.22, installed from MySQL-server-standard-5.0.22-0.rhel4.i386.rpm and MySQL-Max-5.0.22-0.i386.rpm


Thanks.



Edited 1 time(s). Last edit at 09/08/2006 07:44AM by Martin Feng.

Options: ReplyQuote


Subject
Views
Written By
Posted
How to avoid 'Repair with keycache'
7858
September 07, 2006 10:16PM


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.