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. I was having problems with LOAD DATA CONCURRENT
> LOCAL INFILE where the table I was importing into would lock until the
> import was compl
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 table