www.163.com
网易技术部
3
11.3.1 定期分析表:.......................................................................................................50
11.3.2 使用 optimize table :...........................................................................................50
11.4 常用 SQL 的优化............................................................................................................ 51
11.4.1 大批量插入数据:...............................................................................................51
11.4.2 优化 insert 语句:................................................................................................52
11.4.3 优化 group by 语句:.......................................................................................... 52
11.4.4 优化 order by 语句:........................................................................................... 52
11.4.5 优化 join 语句:...................................................................................................53
11.4.6 mysql 如何优化 or 条件:................................................................................... 54
11.4.7 查询优先还是更新(insert、update、delete)优先:..................................... 54
11.4.8 使用 SQL 提示:................................................................................................. 55
11.5 其他优化措施..................................................................................................................56
第 12 章 优化数据库对象...............................................................................................................56
12.1 优化表的数据类型..........................................................................................................56
12.2 通过拆分,提高表的访问效率..................................................................................... 57
12.3 逆规范化..........................................................................................................................57
12.4 使用冗余统计表..............................................................................................................57
12.5 选择更合适的表类型......................................................................................................58
第 13 章 锁问题...............................................................................................................................58
13.1 获取锁等待情况..............................................................................................................58
13.2 什么情况下使用表锁......................................................................................................59
13.3 什么情况下使用行锁......................................................................................................59
13.4 insert …select …带来的问题..........................................................................................60
13.5 next-key 锁对并发插入的影响....................................................................................... 61
13.6 隔离级别对并发插入的影响..........................................................................................61
13.7 如何减少锁冲突..............................................................................................................62
第 14 章 优化 Mysql Server............................................................................................................63
14.1 查看 Mysql server 当前参数...........................................................................................63
14.2 影响 Mysql 性能的重要参数......................................................................................... 63
14.2.1 key_buffer_size 的设置......................................................................................... 63