List:General Discussion« Previous MessageNext Message »
From:Perrin Harkins Date:February 6 2010 5:40pm
Subject:Re: Trying to avoid bulk insert table locking
View as plain text  
On Sat, Feb 6, 2010 at 12:11 PM, D. Dante Lorenso <dante@stripped> wrote:
> I have a system that imports about 40 million records every 2 days into a
> single table in MySQL.  I was having problems with LOAD DATA CONCURRENT
> LOCAL INFILE where the table I was importing into would lock until the
> import was complete.  Locks would prevent SELECTs also.

This should not happen with InnoDB tables.  Writers should not block
readers.  Were you using InnoDB?

- Perrin
Trying to avoid bulk insert table lockingD. Dante Lorenso6 Feb
  • Re: Trying to avoid bulk insert table lockingPerrin Harkins6 Feb