You should increase parameter named max_bulk_insert_buffer_size and max_allowed_packet.
On 8/21/08, Ananda Kumar <[EMAIL PROTECTED]> wrote: > > Mysql use tmpdir, > when ever there is any index creation. > > regards > anandkl > > > On 8/21/08, jthorpe <[EMAIL PROTECTED]> wrote: > > > > Hi, > > > > I've been trying to import a 10G dump file using mysqlimport > > and it is eventually failing because it runs out of tmpdir > > space -- I get Errcode: 28. > > > > I was surprised that it was using a temp file at all. I've > > looked in the documentation and other sources but have not been > > able to find anything about this file. > > > > This is on v5.0.51. The table is innodb and has 75 columns with > > 65% of them tinyint, 20% float, and the rest char,datetime,int. > > The primary key is composite on two columns (int,char). > > The data file that is being imported is on the database server. > > > > I'll try this again and monitor the status parameters to see what > > it is doing, but I was wondering if anyone already knows? > > > > Thanks, > > John > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
