MySQL Forums
Forum List  »  Newbie

Re: /tmp folder getting filled with #sqlXXX.MYI and #sqlXXX.MYD files
Posted by: Rick James
Date: March 26, 2011 03:22PM

Those temp files are created during several operations, such as OPTIMIZE, ALTER.

If you crash, they can be left around. They can be deleted.

(Since you said "/tmp", not "C:\tmp", I will speak unix, not windoz...)

If the operation is still running, deleting them (rm) will not free the space until mysql lets go. (This is a unix 'feature' -- rm removes the entry from the directory and decrements the use counter.)

If you can identify the process (use SHOW PROCESSLIST) that is stuck waiting for more disk space, "kill" it from the mysql prompt.

Is /tmp mounted on a small filesystem? Consider symlinking (ln -s) to some place on a bigger filesystem. Or change the VARIABLE tmpdir.

Options: ReplyQuote


Subject
Written By
Posted
Re: /tmp folder getting filled with #sqlXXX.MYI and #sqlXXX.MYD files
March 26, 2011 03:22PM


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.