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

数据库基础可以加一个面试问题 #28

Open
stevezkw1998 opened this issue Feb 27, 2021 · 3 comments
Open

数据库基础可以加一个面试问题 #28

stevezkw1998 opened this issue Feb 27, 2021 · 3 comments

Comments

@stevezkw1998
Copy link
Contributor

这个问题是我自己根据笔记提出的,整理得出:

问题:说一下四种隔离级别的实现原理?
未提交读(Read Uncommited):啥都不做
(一级封锁协议 ----> 解决丢失修改)
提交读(Read Commited):二级封锁协议 ----> 解决脏读
可重复读(Repeatable Read): 三级封锁协议 ----> 解决不可重复读
可串行化(Serializable):强制事务串行执行 ----> 解决幻读问题

@wolverinn
Copy link
Owner

👍,这几个可以按照问题加答案的形式,提个pull request

@stevezkw1998
Copy link
Contributor Author

👍,这几个可以按照问题加答案的形式,提个pull request

ok,等我有空提pr, 我最近有点忙

@stevezkw1998
Copy link
Contributor Author

👍,这几个可以按照问题加答案的形式,提个pull request

刚刚尝试下提了pr,但由于我本地编译器格式问题,导致一下子改变了整个文本的格式, 所以我还是不提pr了

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants