medium10 pts · first answer countsmysqlisolation-levels

MySQL default isolation level

Inside one InnoDB transaction with default settings, you run the same SELECT twice while another session commits an update in between. What do you see?

A.The new value on the second read, because MySQL defaults to READ COMMITTEDB.An error, because the row changedC.The second SELECT waits until your transaction endsD.The same old value both times, because the default REPEATABLE READ uses one snapshot for plain reads

Discussion 0

Join free to post in the discussion.

MySQL default isolation level

Discussion 0

Related questions