I fail to see why setting the transaction isolation level to read uncommitted wo... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

Gonsalu on June 5, 2012 | parent | context | favorite | on: Loading half a billion rows into MySQL

I fail to see why setting the transaction isolation level to read uncommitted would make any difference to the data load process.

stonemetal on June 5, 2012 [–]

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.

Gonsalu on June 5, 2012 | [–]

Writes still take locks. The isolation level is called Read-uncommitted for a reason.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact