Mysql数据库性能优化是Web开发的重要部分，本文通过参考两篇文章，推荐一些的Mysql性能优化的优秀文章：

优化Mysql查询的10篇好文

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/

优化Mysql查询

• 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

reference: http://hackmysql.com/documents

来自：http://www.fanphp.com/2008/06/20/mysql-database-optimization/

分类： 数据库开发 数据仓库 Web技术