Re: "Incorrect key file for table XXXX" try to repair it
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
Subject
Views
Written By
Posted
80299
March 11, 2005 04:40PM
38312
April 27, 2005 03:52AM
34997
June 21, 2005 04:28PM
30769
June 22, 2005 01:18AM
24444
July 14, 2005 05:42AM
16803
July 18, 2005 07:42AM
15671
September 16, 2005 07:32AM
11577
September 19, 2005 01:25AM
13100
December 04, 2006 01:34AM
11446
December 18, 2006 10:20AM
9658
December 19, 2006 09:26AM
8520
December 20, 2006 02:32AM
Re: "Incorrect key file for table XXXX" try to repair it
21617
March 23, 2007 08:30AM
10901
March 29, 2007 05:49AM
10322
May 19, 2007 03:13AM
7282
June 13, 2008 03:12AM
8445
March 29, 2007 06:19AM
14404
July 18, 2007 05:45PM
6777
July 19, 2007 03:44PM
6261
August 01, 2007 02:45PM
5593
January 06, 2008 05:00PM
5767
August 01, 2007 03:11PM
6016
August 08, 2007 01:08PM
7001
April 30, 2007 11:06AM
5703
July 19, 2007 03:45PM
6562
September 26, 2007 09:07AM
5986
October 04, 2007 06:11AM
9020
October 24, 2007 09:29AM
16725
November 01, 2007 01:12PM
10518
February 12, 2008 08:45AM
9976
September 16, 2008 10:07AM
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.