Mysql 性能优化教程
目录
目录.....................................................................................................................................................1
背景及目标.........................................................................................................................................2
Mysql 执行优化..................................................................................................................................2
认识数据索引.............................................................................................................................2
为什么使用数据索引能提高效率.....................................................................................2
如何理解数据索引的结构.................................................................................................3
优化实战范例.....................................................................................................................3
认识影响结果集.........................................................................................................................4
影响结果集的获取.............................................................................................................4
影响结果集的解读.............................................................................................................4
常见案例及优化思路.........................................................................................................5
理解执行状态.............................................................................................................................8
常见关注重点.....................................................................................................................8
执行状态分析.....................................................................................................................8
分析流程...........................................................................................................................10
常见案例解析...................................................................................................................11
总结...................................................................................................................................13
Mysql 运维优化................................................................................................................................15
存储引擎类型...........................................................................................................................15
内存使用考量...........................................................................................................................15
性能与安全性考量...................................................................................................................16
存储/写入压力优化..................................................................................................................16
运维监控体系...........................................................................................................................17
Mysql 架构优化................................................................................................................................18
架构优化目标...........................................................................................................................18
防止单点隐患...................................................................................................................18
方便系统扩容...................................................................................................................18
安全可控，成本可控.......................................................................................................18
分布式方案...............................................................................................................................19
分库&拆表方案................................................................................................................19
反范式设计（冗余结构设计）.......................................................................................21
主从架构...........................................................................................................................23
故障转移处理...................................................................................................................23
缓存方案...................................................................................................................................24
缓存结合数据库的读取...................................................................................................24
剩余25页未读，继续阅读
资源评论
