Re: ERROR 126 (HY000): Incorrect key file for table
Posted by:
Rick James
Date: April 24, 2010 06:18PM
$ df
(Looking for what filesystems you have)
$ ls -ld /tmp
(Looking for whether /tmp is symlinked)
SHOW VARIABLES LIKE 'tmpdir'
(Looking for where MySQL puts tmp tables)
Probably...
* The query needs a big tmp table.
* MySQL is using /tmp
* /tmp is in a filesystem with not much room
Probably...
The solution is to point tmpdir to some directory in a filesystem that is bigger. Or symlink /tmp to such a place.
Subject
Written By
Posted
Re: ERROR 126 (HY000): Incorrect key file for table
April 24, 2010 06:18PM
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.