New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[DB] InnoDB 스토리지 엔진에서 REPEATABLE READ 격리 수준일 때 PHANTOM READ가 발생하지 않는 이유 #9

Open

jjiwoning opened this issue Oct 9, 2023 · 2 comments

Labels

DB

Contributor

jjiwoning commented Oct 9, 2023

Real MySQL p183을 보면
"InnoDB 스토리지 엔진에서는 갭 락과 넥스트 키 락 덕분에 REPEATABLE READ 격리 수준에서도 이미 "PHANTOM READ"가 발생하지 않기 때문에"
라고 되어 있는데 명확하게 왜 발생하지 않는지 궁금하네요

jjiwoning added the DB label

Contributor Author

jjiwoning commented Oct 9, 2023 •

edited

Loading

https://suhwan.dev/2019/06/09/transaction-isolation-level-and-lock/

https://dev.mysql.com/doc/refman/8.0/en/innodb-next-key-locking.html

Member

worldii commented Oct 11, 2023

굿

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment