Skip to content
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.

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

Repeatable Read 隔离级别是不允许出现不可重复读的 #6756

Closed
Wismyluckstar opened this issue Jul 29, 2021 · 2 comments
Closed
Assignees
Labels
area/transaction Indicates that the Issue or PR belongs to the area of transaction. type/bugfix This PR fixes a bug.

Comments

@Wismyluckstar
Copy link

File: /optimistic-transaction.md

“MySQL 使用悲观事务模型,在执行 SQL 语句的过程中进行加锁并且其 Repeatable Read 隔离级别允许出现不可重复读,所以提交时一般不会出现异常”

Repeatable Read 隔离级别是不允许出现不可重复读的,因为快照读的存在导致不会出现不可重复读,如果允许的那 Repeatable Read 隔离级别是没有意义的,只能说他在更新时(如:for update,更新后查询,查询并附值)提供了当前读所以避免了大部分异常。

@TomShawn
Copy link
Contributor

@cfzjywxk PTAL, thanks!

@TomShawn
Copy link
Contributor

This issue has been addressed.

@TomShawn TomShawn added area/transaction Indicates that the Issue or PR belongs to the area of transaction. type/bugfix This PR fixes a bug. labels Oct 13, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area/transaction Indicates that the Issue or PR belongs to the area of transaction. type/bugfix This PR fixes a bug.
Projects
None yet
Development

No branches or pull requests

4 participants