MySql数据库性能调优

Masud   说道：MySql数据库性能调优是web开发的重要内容，当流量暴增的时候，数据库就撑不住了，如何调优呢？下面推荐一些优秀的文章：

 

10 great articles for optimizing MySQL queries

 

1. Identifying slow MySQL queries
2. MySQL & PHP Performance Optimization Tips
3. MySQL Presentations: Optimizing MySQL
4. MySQL 5 Optimization and Tuning Guide
5. Survive heavy traffic with your Web server
6. Tools to use for MySQL Performance - Peter Zaitsev
7. MySQL Queries Optimization (video) - Peter Zaitsev
8. Table Design and MySQL Index Details
9. MySQL Reference Manual: Optimization Overview
10. MySQL Reference Manual: The MySQL Query Cache

Reference site: http://phpimpact.wordpress.com/

 

Optimizing MySQL Queries

 

• Indexing Basic MySQL Queries
• Table Design and MySQL Index Details
• MySQL ORDER BY With LIMIT and ANALYZE
• How To Index For MySQL Joins
• How To Look At MySQL Joins and More ORDER BY With LIMIT