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!