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)

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

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. > &g

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 INF

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 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) ti