News for hackers. Stuff that matters.
Re:Loading half a billion rows into MySQL by Gonsalu on Tuesday June 05, 2012 @05:15PM (#4070931)
I fail to see why setting the transaction isolation level to read uncommitted would make any difference to the data load process.
Re:Loading half a billion rows into MySQL by stonemetal on Tuesday June 05, 2012 @06:30PM (#4071334)
Without thinking about it to hard my guess is there is some overhead in tracking what is readable and what is not readable at the higher read levels. Read uncommitted means it doesn't have to track anything.
Re:Loading half a billion rows into MySQL by Gonsalu on Tuesday June 05, 2012 @07:51PM (#4071612)
Writes still take locks. The isolation level is called Read-uncommitted for a reason.