MySQL Forums
Forum List  »  Knowledge Base

MySQL storing SQL_LOAD_MB files in /var/tmp instead of specified tmpdir
Posted by: Adam Bodnar
Date: January 29, 2009 04:29PM

I recently noticed that my main hard drive on my server was filling up. When I found the culprit, I noticed that in /var/tmp there were a ton of SQL_LOAD_MB files. These appear to be data that is being loaded in thru mysqlimport or load data infile.

However, I have speicifed a tmpdir.

Why is MySQL not using this directory for it's storage? and how can I specify where it can store these files?

Running 5.0.50sp1a-enterprise on 10.5 Mac OS X Server.

Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL storing SQL_LOAD_MB files in /var/tmp instead of specified tmpdir
5366
January 29, 2009 04:29PM


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.