current position:Home>What does MySQL mean by unreal reading, dirty reading and non repeatable reading?

What does MySQL mean by unreal reading, dirty reading and non repeatable reading?

2022-02-04 16:32:19 Alibaba cloud Q & A

MySQL The illusory reading of , Dirty reading , What does non repeatable reading mean ?




Take the answer 1:

Business A、B Alternate execution , Business A To be transacted B It interferes with , Because business A Read to transaction B Uncommitted data , This is dirty reading

Within a transaction scope , Two identical queries , Read the same record , But it returns different data , This is unrepeatable reading .

Business A Query a range of result sets , Another concurrent transaction B Insert... Into this range / Deleted data , And quietly submit , Then transaction A Query the same range again , The result set from the two reads is different , This is unreal reading .


copyright notice
author[Alibaba cloud Q & A],Please bring the original link to reprint, thank you.
https://en.cdmana.com/2022/02/202202041632181790.html

Random recommended