MySQL Forums
Forum List  »  MyISAM

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


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).

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

Written By
Incorrect key file for table 'XXX.MYI'; try to repair it
April 13, 2010 09:43AM

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.