https://blog.youkuaiyun.com/red_hotzh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/red_hot/article/details/6063126https://blog.youkuaiyun.com/red_hot/article/details/6063126red_hotWed, 08 Dec 2010 15:11:00 +0800锁的概述
一. 为什么要引入锁
多个用户同时对数据库的并发操作时会带来以下数据不一致的问题:
丢失更新
A,B两个用户读同一数据并进行修改,其中一个用户的修改结果破坏了另一个修改的结果,比如订票系统
脏读
A用户修改了数据,随后B用户又读出该数据,但A用户因为某些原因取消了对数据的修改,数据恢复原值,此时B得到的数据就与数据库内的数据产生了不一致
不可重复读
A用户读取数据,随后B用户读出该数据并修改,此时]]>https://blog.youkuaiyun.com/red_hot/article/details/5265819https://blog.youkuaiyun.com/red_hot/article/details/5265819red_hotThu, 28 Jan 2010 16:20:00 +0800https://blog.youkuaiyun.com/red_hot/article/details/5265283https://blog.youkuaiyun.com/red_hot/article/details/5265283red_hotThu, 28 Jan 2010 14:33:00 +0800https://blog.youkuaiyun.com/red_hot/article/details/5265254https://blog.youkuaiyun.com/red_hot/article/details/5265254red_hotThu, 28 Jan 2010 14:22:00 +0800https://blog.youkuaiyun.com/red_hot/article/details/5213105https://blog.youkuaiyun.com/red_hot/article/details/5213105red_hotTue, 19 Jan 2010 14:36:00 +0800https://blog.youkuaiyun.com/red_hot/article/details/5206127https://blog.youkuaiyun.com/red_hot/article/details/5206127red_hotMon, 18 Jan 2010 10:32:00 +0800https://blog.youkuaiyun.com/red_hot/article/details/5190462https://blog.youkuaiyun.com/red_hot/article/details/5190462red_hotThu, 14 Jan 2010 16:27:00 +0800https://blog.youkuaiyun.com/red_hot/article/details/5190279https://blog.youkuaiyun.com/red_hot/article/details/5190279red_hotThu, 14 Jan 2010 15:47:00 +0800https://blog.youkuaiyun.com/red_hot/article/details/5185745https://blog.youkuaiyun.com/red_hot/article/details/5185745red_hotWed, 13 Jan 2010 15:32:00 +0800https://blog.youkuaiyun.com/red_hot/article/details/5180806https://blog.youkuaiyun.com/red_hot/article/details/5180806red_hotTue, 12 Jan 2010 11:32:00 +0800https://blog.youkuaiyun.com/red_hot/article/details/5136011https://blog.youkuaiyun.com/red_hot/article/details/5136011red_hotTue, 05 Jan 2010 15:19:00 +0800https://blog.youkuaiyun.com/red_hot/article/details/5135242https://blog.youkuaiyun.com/red_hot/article/details/5135242red_hotTue, 05 Jan 2010 14:07:00 +0800https://blog.youkuaiyun.com/red_hot/article/details/5129829https://blog.youkuaiyun.com/red_hot/article/details/5129829red_hotMon, 04 Jan 2010 15:39:00 +0800https://blog.youkuaiyun.com/red_hot/article/details/5092011https://blog.youkuaiyun.com/red_hot/article/details/5092011red_hotMon, 28 Dec 2009 16:22:00 +0800https://blog.youkuaiyun.com/red_hot/article/details/5091733https://blog.youkuaiyun.com/red_hot/article/details/5091733red_hotMon, 28 Dec 2009 15:48:00 +0800https://blog.youkuaiyun.com/red_hot/article/details/5091672https://blog.youkuaiyun.com/red_hot/article/details/5091672red_hotMon, 28 Dec 2009 15:40:00 +0800https://blog.youkuaiyun.com/red_hot/article/details/5074857https://blog.youkuaiyun.com/red_hot/article/details/5074857red_hotFri, 25 Dec 2009 13:42:00 +0800https://blog.youkuaiyun.com/red_hot/article/details/5074262https://blog.youkuaiyun.com/red_hot/article/details/5074262red_hotFri, 25 Dec 2009 12:03:00 +0800