MySQL Forums
Forum List  »  Newbie

/tmp folder getting filled with #sqlXXX.MYI and #sqlXXX.MYD files
Posted by: neelima pulikanti
Date: March 25, 2011 01:59PM

Hello,

Yesterday /tmp folder for one of our mysql server ran out of space, we saw multiple #sqlXXX.MYI and #sqlXXX.MYD files created. seems like everyday we have around 3-4 temp files which are not getting removed by mysql. I'm not sure why mysql did not purge those temp files. We do use joins ,order by /group by in our SQL's.

We also manually deleted the temp files, but it did not release the space back to OS. mysql process was still holding those deleted files. so we had to bounce the db to clear them.

Please let me know if there are any senarios where mysql would not be able to clear the tmp files or any idea how to debug this issue.

Options: ReplyQuote


Subject
Written By
Posted
/tmp folder getting filled with #sqlXXX.MYI and #sqlXXX.MYD files
March 25, 2011 01:59PM


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.