Phantom read occurs with 'SERIALIZABLE' isolation level (MySQL)

"Non-repeatable read" and "phantom read" occur with 'SERIALIZABLE' isolation level (MySQL)

Sep 20 '22 Comments: 1 Answers: 2

1

I experimented if non-repeatable read and phantom read occur or not with SERIALIZABLE on MySQL but against my expectation, both non-repeatable read and phantom read actually occurred with SERIALIZABLE.

These below are the definitions of non-repeatable read and phantom read:

• Non-repeatable read(fuzzy read) is the read of committed…

Open Full Question