Skip navigation links

MySQL Forums :: MyISAM :: Incorrect key file for table 'XXX.MYI'; try to repair it


Advanced Search

Incorrect key file for table 'XXX.MYI'; try to repair it
Posted by: Hava Ba ()
Date: April 13, 2010 09:43AM

Hi,

I need the help of the forum to solve a repeating problem I'm facing with MySQL installation.
On this specific installation, every one or two days one of the DB table crash. The error messages received on DB error log are:

100410 11:28:04 [ERROR] \mysqld-nt.exe: Incorrect key file for table '.\XXX.MYI'; try to repair it
100410 11:28:05 [ERROR] Got error 134 when reading table './XXX'

On the previous crash only one table crash, and on the current crash an additional table was crash..

I made a research on the internet about this issue, and checked the following thing:
1. There is enough disk space on both MySQL drive and temp folder drive
2. There was no server crash before the DB crash.
3. I found a forum discussion that indicate a bug - this error message was cause when deleting from large index file. I don't find this bug related to the issue, since those table are small (records and added and deleted in high frequency). http://bugs.mysql.com/bug.php?id=22384

I repair the table, and it crash again in a day or two.

My sql version: 5.0.21

Please advice - are there other actions\ checks that can be performed?
How can I raise the log level of my sql to get more specific error messages?

Thanks in advance!

Options: ReplyQuote


Subject Views Written By Posted
Incorrect key file for table 'XXX.MYI'; try to repair it 86408 Hava Ba 04/13/2010 09:43AM
Re: Incorrect key file for table 'XXX.MYI'; try to repair it 49958 Rick James 04/14/2010 11:06PM
Re: Incorrect key file for table 'XXX.MYI'; try to repair it 33219 Shane Bester 04/19/2010 06:39AM
Re: Incorrect key file for table 'XXX.MYI'; try to repair it 26692 Hava Ba 04/21/2010 04:57AM
Re: Incorrect key file for table 'XXX.MYI'; try to repair it 21684 Rick James 04/24/2010 08:37PM
Re: Incorrect key file for table 'XXX.MYI'; try to repair it 18495 Hava Ba 04/25/2010 04:40AM


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.