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 > 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org