Bug #65855 "load data" comnnad failed because of tmpdir
Submitted: 9 Jul 2012 19:58 Modified: 10 Aug 2012 4:17
Reporter: Li Chen Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.6.5-m8 OS:Linux (CentOS release 5.6 (Final))
Assigned to: CPU Architecture:Any

[9 Jul 2012 19:58] Li Chen 
Description:
Recently I installed the new version (mysql  Ver 14.14 Distrib 5.6.5-m8, for Linux (x86_64) using  EditLine wrapper). 

I have a problem to load a huge table using the new version of MYSQL. It says that the tmpdir has no space when created a temporary file. The tmpdir is about 112GB, The table in the current(lower version of MYSQL 5.1) database is about 100GB. I have tried InnoDB and MYISAM with partitioning and both failed to load data.

Why does the version 5.6 use so much space in the tmpdir? Is there any memory leaking? 

How to repeat:
repeatable
[10 Jul 2012 4:17] Valeriy Kravchuk 
How large is the file you are loading? Send exact CREATE TABLE statement for the table, please.
[11 Aug 2012 1:00] Bugs System 
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".