文档介绍:Mysql性能优化教程目录目录....................................................................................................................................................1背景及目标........................................................................................................................................2Mysql执行优化...............................................................................................................................2认识数据索引............................................................................................................................2为什么使用数据索引能提高效率....................................................................................2如何理解数据索引的结构................................................................................................2优化实战范例....................................................................................................................3认识影响结果集........................................................................................................................4影响结果集的获取............................................................................................................4影响结果集的解读............................................................................................................4常见案例及优化思路........................................................................................................5理解执行状态............................................................................................................................7常见关注重点....................................................................................................................7执行状态分析....................................................................................................................8分析流程............................................................................................................................9常见案例解析............................................................................................................