Written by:David Aldridge5/13/2011 1:56 PM
If you see errors like the following in your mysqld log:110512 9:28:02 [ERROR] /usr/libexec/mysqld: Incorrect key file for table '/tmp/#sql_6fef_315.MYI'; try to repair it 110512 9:28:02 [ERROR] /usr/libexec/mysqld: Incorrect key file for table '/tmp/#sql_6fef_131.MYI'; try to repair it Then you need to change where your temp tables are being created. It means that the temp tables are overflowing the assigned filesystem space. Edit your /etc/my.cnf file with the following to change the location of the temp area:tmpdir = /var/tmp
110512 9:28:02 [ERROR] /usr/libexec/mysqld: Incorrect key file for table '/tmp/#sql_6fef_315.MYI'; try to repair it 110512 9:28:02 [ERROR] /usr/libexec/mysqld: Incorrect key file for table '/tmp/#sql_6fef_131.MYI'; try to repair it
tmpdir = /var/tmp
1 comment(s) so far...
Re: Incorrect key file for table '/tmp/#sql_6fef_315.MYI'; try to repair itThanks a lot for this great hint. I've had the same issue I didn't changed the tmpdir as you suggested but umounted the mounted 1 mb partition /tmp umount -l /tmp/and it works after that.
Re: Incorrect key file for table '/tmp/#sql_6fef_315.MYI'; try to repair it
Thanks a lot for this great hint. I've had the same issue I didn't changed the tmpdir as you suggested but umounted the mounted 1 mb partition /tmp umount -l /tmp/and it works after that.