一些值得收藏的数据库知识链接
postgresql 技术内幕 https://www.jiangguo.net/c/42e/dn.html
Postgresql Buffer pool设置:
PostgreSQL 自己的 DB buffer & 与别的人的OS cache 之 回答问题:https://cloud.tencent.com/developer/article/1536270
Postgresql 理解cache 在 postgres中的意义 与 share buffer 到底设置多大性能最好:https://mp.weixin.qq.com/s/OPTFVWg2Y7fZoBSX2A1ddg
Redis阻塞操作实现原理 https://www.jianshu.com/p/xsMzfn
连接池&长连接&短连接 https://www.cnblogs.com/YangJiaXin/p/10245000.html
Focus on MySQL,Focus on Life的博客http://keithlan.github.io/
MySQL学习:http://blog.itpub.net/22664653/cid-84487-abstract-1/
MySQL FQA:https://www.kancloud.cn/thinkphp/mysql-faq/47445
MySQL原理知识提问式总结 http://blog.csdn.net/mchdba/article/details/13505701
爱可生的技术文章质量都比较好https://opensource.actionsky.com/blog/
https://cloud.tencent.com/developer/user/6193404/articles
*******************************MySQL sql rewrite 和 ddl rewrite插件*****************************************
https://mp.weixin.qq.com/s/7cJ9Mv6GNZ3uTF5oxaYr3Q
*******************************MySQL buffer pool instance 测试*****************************************
很早就想知道的一个参数调整方法,一直没有找到合适的测试方法和条件
innodb_buffer_pool_instances 是如何影响性能的-爱可生 https://www.sohu.com/a/395919307_120426623
https://mp.weixin.qq.com/s?__biz=MzU2NzgwMTg0MA==&mid=2247489115&idx=1&sn=33e88824346ce39fc95354b994ce889a&chksm=fc96f4c4cbe17dd2e5aa25a9f3e4f6cc1a27ace44b05b618a12f4d4e5d88a0417f0c49e241bb&scene=21#wechat_redirect
https://mp.weixin.qq.com/s/MNwh_oZVPIkYxJZvnBGTUQ
*******************************MySQL MGR原理*****************************************
MySQL MGR原理以及问题:http://kuaibao.qq.com/s/20181217G0H3YZ00?refer=spider
MGR源码级解读:https://zhuanlan.zhihu.com/p/55323854
MySQL Group Replication 入坑指北:https://mp.weixin.qq.com/s/ZabTfDS6oi3Qg2c5de0lkg
*******************************MySQL 复制*****************************************
速度提升5~10倍,基于WRITESET的MySQL并行复制:https://mp.weixin.qq.com/s/oj-DzpR-hZRMMziq2_0rYg
P8级面试难题,after_sync vs after_commit,哪个性能更好?:https://mp.weixin.qq.com/s?__biz=MjM5MjIxNDA4NA==&mid=2649738652&idx=1&sn=7a8b3d415732ed1a64d1c8dd87353c74&chksm=beb2d0b789c559a14592421b74e9ddd1f22a45cf93a21664373d8c77332c76256ed9362d2870&scene=0&xtrack=1#rd
MySQL 复制filter相关:https://keithlan.github.io/2015/11/02/mysql_replicate_rule/
深入浅出讲解MySQL的并行复制:https://www.jb51.net/article/144920.htm
浅析MySQL并行复制 https://www.jb51.net/article/199142.htm
*******************************MySQL optimize*****************************************
阿里云慢SQL优化挑战大赛分析:https://yq.aliyun.com/articles/183749
Oracle迁移到MySQL性能下降的注意点:https://yq.aliyun.com/articles/72487?spm=5176.8091938.0.0.101639eeIBEiFY
MySQL大神的性能优化,故障排查,最佳实践秘籍 https://yq.aliyun.com/users/1368306804063034/article
MySQL中跟IO相关的场景 http://www.tocker.ca/2013/05/06/when-does-mysql-perform-io.html
*******************************MySQL Online DDL*****************************************
https://opensource.actionsky.com/20190620-mysql-add-column/ MySQL 为表添加列 是怎么”立刻”完成的
https://dbaplus.cn/news-11-2552-1.html 大型表的DDL操作
*******************************MySQL backup*****************************************
mysqldump和xtrabackup备份原理实现说明 http://www.cnblogs.com/zhoujinyi/p/5789465.html
*******************************MySQL 锁相关*****************************************
解决死锁之路 - 常见 SQL 语句的加锁分析:https://www.aneasystone.com/archives/2017/12/solving-dead-locks-three.html
读 MySQL 源码再看 INSERT 加锁流程:https://www.aneasystone.com/archives/2018/06/insert-locks-via-mysql-source-code.html
https://yq.aliyun.com/articles/5533(死锁分析的很好的一篇文章)
http://hedengcheng.com/?spm=5176.100239.blogcont5533.8.vaztis&p=771#_Toc374698322
https://opensource.actionsky.com/20200421-mysql/ 有效解决 MySQL 行锁等待超时问题
https://juejin.im/entry/6844903603618971656 理解 MySQL 一致性非锁定读原理
https://juejin.cn/post/6844903923459817479 Mysql死锁如何排查:insert on duplicate死锁一次排查分析过程
*******************************Redis*****************************************
白话解析:一致性哈希算法 consistent hashing:http://www.zsythink.net/archives/1182 总算把一致性hash算法说明白了
*******************************MSSQL*****************************************
数据库内核月报 http://mysql.taobao.org/monthly/
COLUMNS_UPDATED获取数据变更(没找到什么应用场景) http://mysql.taobao.org/monthly/2016/11/08/
SQL Server统计信息,来自数据库内核月报 http://mysql.taobao.org/monthly/2016/12/03/
扩展事件的对Performance的影响 http://mysql.taobao.org/monthly/2017/07/06/
扩展事件的三种解析方式 http://mysql.taobao.org/monthly/2017/08/08/
查询提示汇总 https://www.red-gate.com/simple-talk/sql/performance/controlling-execution-plans-with-hints/
SQLServer 中一种经典的死锁:https://blog.sqlxdetails.com/single-row-deadlock/
SQLServer 复制专家:https://repltalk.com/
SQLServer 官方博客 https://techcommunity.microsoft.com/t5/sql-server-blog/bg-p/SQLServer
SQLServer官方故障排查参考 https://learn.microsoft.com/zh-cn/troubleshoot/sql/welcome-sql-server
docker+keepalived
https://blog.csdn.net/LeoHan163/article/details/109069005
https://blog.csdn.net/hamster204/article/details/115555423