Trying to avoid bulk insert table locking

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. I converted the

Re: Trying to avoid bulk insert table locking

On Sat, Feb 6, 2010 at 12:11 PM, D. Dante Lorenso da...@lorenso.com 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