MySQL Forums :: Newbie :: /tmp folder getting filled with #sqlXXX.MYI and #sqlXXX.MYD files

Advanced Search

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


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 neelima pulikanti 03/25/2011 01:59PM
Re: /tmp folder getting filled with #sqlXXX.MYI and #sqlXXX.MYD files Rick James 03/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.