mysql 锁相关blog梳理

ゝ一纸荒年。 2022-06-04 04:37 139阅读 0赞

目前网上关于***mysql 锁*** 高质量文章，便于学习

*  lanchun  
    [MySQL锁系列（一）之锁的种类和概念][MySQL]  
    [MySQL锁系列（二）之 锁解读][MySQL_]  
    [ySQL锁系列（三）之 redo log][ySQL_ redo log]  
    [MySQL锁系列（四）之 undo log][MySQL_ undo log]  
    [MySQL锁系列（五）之 隔离级别][MySQL_ 1]  
    [MySQL锁系列（六）之 MVCC][MySQL_ MVCC]  
    [MySQL锁系列（七）之 锁算法详解][MySQL_ 2]  
    [MySQL锁系列（八）之 死锁][MySQL_ 3]  
    很详细的，不是每个都能看懂，尴尬
 *  yinfeng  
    [\[MySQL 学习\] Innodb锁系统(1)之如何阅读死锁日志][MySQL _ Innodb_1]  
    [\[MySQL 学习\] Innodb锁系统（2）关键函数路径][MySQL _ Innodb_2]  
    [\[MySQL学习\] Innodb锁系统(3)关键结构体及函数][MySQL_ Innodb_3]  
    [\[MySQL学习\] Innodb锁系统(4) Insert/Delete 锁处理及死锁示例分析][MySQL_ Innodb_4_ Insert_Delete]  
    [一个线上死锁问题分析][Link 1]
 *  hedengcheng  
    [MySQL+InnoDB semi-consitent read原理及实现分析][MySQL_InnoDB semi-consitent read]  
    [MySQL 加锁处理分析][MySQL 1]  
    非常推荐，简单易懂
 *  Sean（不知道真名）  
    [index merge 引起的死锁分析][index merge]
 *  yeshaoting  
    [mysql insert锁机制][mysql insert]
 *  jiangchengyao  
    [MySQL REPLACE死锁问题深入剖析][MySQL REPLACE]

--------------------

如果再发现好的文章，持续更新列表~  
（ps：不清楚文章是否可以算是原创~尴尬）

[MySQL]: http://keithlan.github.io/2017/06/05/innodb_locks_1/
[MySQL_]: http://keithlan.github.io/2017/06/05/innodb_locks_show_engine/
[ySQL_ redo log]: http://keithlan.github.io/2017/06/12/innodb_locks_redo/
[MySQL_ undo log]: http://keithlan.github.io/2017/06/13/innodb_locks_undo/
[MySQL_ 1]: http://keithlan.github.io/2017/06/14/innodb_locks_mvcc_isolation/
[MySQL_ MVCC]: http://keithlan.github.io/2017/06/16/innodb_locks_MVCC/
[MySQL_ 2]: http://keithlan.github.io/2017/06/21/innodb_locks_algorithms/
[MySQL_ 3]: http://keithlan.github.io/2017/08/17/innodb_locks_deadlock/
[MySQL _ Innodb_1]: https://yq.aliyun.com/articles/40993?spm=5176.8091938.0.0.Ekwy0R
[MySQL _ Innodb_2]: https://yq.aliyun.com/articles/40994?spm=5176.8091938.0.0.dQuEH4#
[MySQL_ Innodb_3]: https://yq.aliyun.com/articles/40996?spm=5176.8091938.0.0.eX6Dbi#
[MySQL_ Innodb_4_ Insert_Delete]: https://yq.aliyun.com/articles/40997?spm=5176.8091938.0.0.lYeiG4#
[Link 1]: https://yq.aliyun.com/articles/40998?spm=5176.8091938.0.0.YUfDRB#
[MySQL_InnoDB semi-consitent read]: http://hedengcheng.com/?p=220
[MySQL 1]: http://hedengcheng.com/?p=771#_Toc374698311
[index merge]: http://seanlook.com/2017/03/11/mysql-index_merge-deadlock/
[mysql insert]: http://yeshaoting.cn/article/database/mysql%20insert%E9%94%81%E6%9C%BA%E5%88%B6/
[MySQL REPLACE]: http://www.innomysql.com/26186-2/