CODEWITHSUNDEEP
mysqlisolation-levellocks
Blue Ross
Blue Ross

Reputation: 79

MySQL - Does the READ UNCOMMITTED isolation level use locks?

So I am trying to understand more about the isolation levels and I read that the READ UNCOMMITTED isolation level allows dirty readings which may lead to non-consistent readings. I also read that the

SELECT statements are performed in a nonlocking fashion

So my question is, does this type of isolation uses locks for other statements? For example, if I use the INSERT INTO statement does it acquire locks?

Upvotes: 2

Views: 157

Answers (1)

danblack
danblack

Reputation: 14666

Yes. Locks are still needed to ensure data transactions are atomic.

Also locks ensure that elements like auto_increments values only exist once.

Upvotes: 2

Related Questions