一. 官网资料
MySQL官网文献资料:https://dev.mysql.com/doc/
常用版本参考手册入口:
1.MySQL8.0参考手册:https://dev.mysql.com/doc/refman/8.0/en/
2.MySQL5.7参考手册:https://dev.mysql.com/doc/refman/5.7/en/
具体版本常用连接:
MySQL5.7
1.MySQL优化
优化汇总: https://dev.mysql.com/doc/refman/5.7/en/optimization.html
理解查询计划:https://dev.mysql.com/doc/refman/5.7/en/execution-plan-information.html
索引条件下推:https://dev.mysql.com/doc/refman/5.7/en/index-condition-pushdown-optimization.html
Nested Join算法:https://dev.mysql.com/doc/refman/5.7/en/nested-loop-joins.html
Nested Join优化:https://dev.mysql.com/doc/refman/5.7/en/nested-join-optimization.html
块嵌套循环和批处理密钥访问联接 :https://dev.mysql.com/doc/refman/5.7/en/bnl-bka-optimization.html
2.INNODB存储引擎:https://dev.mysql.com/doc/refman/5.7/en/innodb-storage-engine.html
3.多版本控制(MVCC):https://dev.mysql.com/doc/refman/5.7/en/innodb-multi-versioning.html