精华推荐
打造专业硬件工程师
Golang与微服务框架
Pytest全栈自动化测
千亿大厂大数据据架
深度挖掘大数据+技
650集数据结构超强
|
5375| 84
|
分享一个很经典的Mysql 性能优化教程 Mysql优化精华文档 17页Mysql技术文档
[复制链接]
|
|
分享一个很经典的Mysql 性能优化教程 Mysql优化精华文档
目录.................................................................................................................................................... 1 背景及目标........................................................................................................................................2 Mysql 执行优化................................................................................................................................2 认识数据索引.............................................................................................................................2 为什么使用数据索引能提高效率.................................................................................... 2 如何理解数据索引的结构................................................................................................ 2 如何理解影响结果集.........................................................................................................3 理解执行状态.............................................................................................................................4 常见分析手段.....................................................................................................................4 分析流程.............................................................................................................................6 总结....................................................................................................................................7 Mysql 运维优化................................................................................................................................9 存储引擎类型.............................................................................................................................9 内存使用考量.............................................................................................................................9 性能与安全性考量.....................................................................................................................9 存储压力优化...........................................................................................................................10 运维监控体系...........................................................................................................................10 Mysql 架构优化...............................................................................................................................11 架构优化目标...........................................................................................................................11 防止单点隐患...................................................................................................................11 方便系统扩容...................................................................................................................11 安全可控，成本可控.......................................................................................................11 分布式方案...............................................................................................................................12 分库&拆表方案............................................................................................................... 12 主从架构...........................................................................................................................14 故障转移处理...................................................................................................................15 缓存方案..................................................................................................................................15 缓存结合数据库的读取.................................................................................................. 15 缓存结合数据库的写入.................................................................................................. 15
购买主题
已有 3 人购买
本主题需向作者支付 1 金币 才能浏览
| |
发表于 2014-12-16 18:54:55
| ||
发表于 2014-12-24 22:08:37
| ||
| ||
| ||
| ||
| ||
| ||
