| 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
| Thread | ||
|---|---|---|
| • Trying to avoid bulk insert table locking | D. Dante Lorenso | 6 Feb |
| • Re: Trying to avoid bulk insert table locking | Perrin Harkins | 6 Feb |