hopperhuang / tech-story

一些技术和一些故事
4 stars 0 forks source link

mysql 事务 与 锁 #39

Open hopperhuang opened 4 years ago

hopperhuang commented 4 years ago

锁与事务的关系 https://www.cnblogs.com/leijiangtao/p/11911644.html

hopperhuang commented 4 years ago

锁、事务与并发控制 https://www.ibm.com/developerworks/cn/opensource/os-mysql-transaction-isolation-levels-and-locks/index.html https://cloud.tencent.com/developer/article/1178044

hopperhuang commented 4 years ago

详解: https://liuyueyi.github.io/hexblog/2018/03/23/mysql%E4%B9%8B%E9%94%81%E4%B8%8E%E4%BA%8B%E5%8A%A1%E8%AF%A6%E8%A7%A3/

hopperhuang commented 4 years ago

不可重复读与幻读: https://segmentfault.com/a/1190000012669504

hopperhuang commented 4 years ago

share lock and exclude lock: https://blog.csdn.net/She_lock/article/details/82022431

hopperhuang commented 4 years ago

排他锁分析: https://blog.csdn.net/claram/article/details/54023216

hopperhuang commented 4 years ago

理解:  什么是锁 什么是事务 什么语句会加锁 锁的种类 加锁后对改行操作会怎样 加锁时,哪些行加了锁,哪些行没有加锁 加锁对操作的性能影响 什么业务,应该用哪种锁

hopperhuang commented 4 years ago

行锁 vs 表锁: https://www.cnblogs.com/frankltf/p/9127440.html

hopperhuang commented 4 years ago

死锁: https://github.com/aneasystone/mysql-deadlocks