MyISAM index file error
Posted by: Devrishi Shandilya
Date: December 28, 2014 11:44PM

Hi Friends,

There is an error in my server's error logs :

141109 3:38:54 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_52dd_0.MYI'; try to repair it
141109 3:38:54 [ERROR] Got an error from unknown thread, /build/buildd/mysql-5.5-5.5.38/storage/myisam/mi_write.c:226

What could be the reason and resolution steps?

I checked tmp fS size at that time and it was absolutely fine.

My tmp table size and max table heap size is set to 16 MB.


Options: ReplyQuote

Written By
MyISAM index file error
December 28, 2014 11:44PM
December 30, 2014 04:38PM

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.