MySQL Bugs: #56130: "load data infile local" stores file to /tmp/ on the db server,

Bug #56130	"load data infile local" stores file to /tmp/ on the db server,
Submitted:	20 Aug 2010 0:10	Modified:	29 Dec 2010 12:51
Reporter:	Xiaoyu Wang	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: Options	Severity:	S4 (Feature request)
Version:	Ver 14.12 Distrib 5.0.45	OS:	Linux (redhat-linux-gnu (x86_64) using readline 5.0)
Assigned to:		CPU Architecture:	Any

Description:
When executing "load data infile local...", it appears that mysql server copies the data over to its /tmp/ directory and load from there. This is a problem when the data file is large compared to the /tmp directory. We are not able to use other available space for this purpose. 

Note that on the mysql server, neither "tmpdir" nor "slave_load_tmpdir" points to /tmp. 

How to repeat:
execute 

mysql -h<mysql_server> -uroot -p -e "load data local infile '/home/xxx/a.dat' into table test.test_load";

check /tmp/ directory on <mysql_server>, there is a file "SQL_LOAD_MB-10-0"

Suggested fix:
make configurable by adding a new variable e.g. "local_infile_tmpdir".

Please paste out from:

SHOW VARIABLES LIKE '%tmp%';

Additionally, we need to know if you use our packages or packages from Redhat and how you installed it.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".