Re: LOAD DATA INFILE performance testing

2001-08-08 Thread Michael Widenius
Hi! Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes: Sinisa Jeff Tanner writes: I running a test on mysql to test its performance of doing a bulk insert into a table using LOAD DATA INFILE. The table is simple: CREAT TABLE test ( valueCHAR(32) NOT NULL PRIMARY KEY )

LOAD DATA INFILE performance testing

2001-08-06 Thread Jeff Tanner
I running a test on mysql to test its performance of doing a bulk insert into a table using LOAD DATA INFILE. The table is simple: CREAT TABLE test ( value CHAR(32) NOT NULL PRIMARY KEY ) The test is simple: a) clear table b) time performance of inserting X unique

Re: LOAD DATA INFILE performance testing

2001-08-06 Thread Sinisa Milivojevic
Jeff Tanner writes: I running a test on mysql to test its performance of doing a bulk insert into a table using LOAD DATA INFILE. The table is simple: CREAT TABLE test ( valueCHAR(32) NOT NULL PRIMARY KEY ) The test is simple: a) clear table b) time

Re: LOAD DATA INFILE performance testing

2001-08-06 Thread Tim Bunce
DELAY_KEY_WRITE=1 Tim. On Mon, Aug 06, 2001 at 07:36:17AM -0700, Jeff Tanner wrote: I running a test on mysql to test its performance of doing a bulk insert into a table using LOAD DATA INFILE. The table is simple: CREAT TABLE test ( valueCHAR(32) NOT NULL PRIMARY KEY )

RE: LOAD DATA INFILE performance testing

2001-08-06 Thread Jeff Tanner
Tanner Cc: '[EMAIL PROTECTED]' Subject: Re: LOAD DATA INFILE performance testing DELAY_KEY_WRITE=1 Tim. On Mon, Aug 06, 2001 at 07:36:17AM -0700, Jeff Tanner wrote: I running a test on mysql to test its performance of doing a bulk insert into a table using LOAD DATA INFILE. The table

RE: LOAD DATA INFILE performance testing

2001-08-06 Thread Jeff Tanner
PROTECTED]] Sent: Monday, August 06, 2001 8:33 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: LOAD DATA INFILE performance testing Jeff Tanner writes: I running a test on mysql to test its performance of doing a bulk insert into a table using LOAD DATA INFILE. The table

RE: LOAD DATA INFILE performance testing

2001-08-06 Thread Jeff Tanner
DELAY_KEY_WRITE=ON by default Jeff -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED]] Sent: Monday, August 06, 2001 9:00 AM To: Jeff Tanner Cc: '[EMAIL PROTECTED]' Subject: Re: LOAD DATA INFILE performance testing DELAY_KEY_WRITE=1 Tim. On Mon, Aug 06, 2001 at 07:36:17AM