MySQL Forums
Forum List  »  MyISAM

Re: "Incorrect key file for table XXXX" try to repair it
Posted by: Martin Bachmann
Date: March 23, 2007 08:30AM

We do have the same problem on our production system online. It happens more and more, now today multiple times. A REPAIR TABLE on the specific table takes the whole site down for 10-15mins.

070323 12:39:53 [ERROR] /usr/local/libexec/mysqld: Incorrect key file for table './piazza/piazza_ads.MYI'; try to repair it

070323 13:26:04 [ERROR] /usr/local/libexec/mysqld: Incorrect key file for table './piazza/piazza_ads.MYI'; try to repair it

mysql-server-5.0.37 on a FreeBSD platform.

The platform is under quite some load, still this should not happen and we try to find the problem. Is it likely to be related to one single query? We tried to log failed queries, but haven't found any, still the index went corrupt again.

How can we identify that query or the problem.

It happens to the same table that is quite big - and it has about 50 indexes, some Fulltext. The index data is larger than the data itself. But - we can't change tha t quickly and need the system to be stable again. How can we proceed?

some table stats:

Format dynamisch
Kollation utf8_general_ci
Zeilen 251.063
Zeilenlänge ø 793
Zeilengröße ø 2.656 Bytes


Any help appreciated!
Martin

Options: ReplyQuote


Subject
Views
Written By
Posted
15671
September 16, 2005 07:32AM
11577
September 19, 2005 01:25AM
Re: "Incorrect key file for table XXXX" try to repair it
21617
March 23, 2007 08:30AM
16725
November 01, 2007 01:12PM


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.