From: Perrin Harkins Date: February 6 2010 5:40pm Subject: Re: Trying to avoid bulk insert table locking List-Archive: http://lists.mysql.com/mysql/220615 Message-Id: <66887a3d1002060940yd2e9407jadd870dfd58d832e@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable On Sat, Feb 6, 2010 at 12:11 PM, D. Dante Lorenso wrote= : > I have a system that imports about 40 million records every 2 days into a > single table in MySQL. =A0I was having problems with LOAD DATA CONCURRENT > LOCAL INFILE where the table I was importing into would lock until the > import was complete. =A0Locks would prevent SELECTs also. This should not happen with InnoDB tables. Writers should not block readers. Were you using InnoDB? - Perrin