MySQL database optimization is one of the major part of web development. Basically those developers who deals with heavy traffic based web development, will need such optimization. There are very few web tutorial regarding this. I was searching for such tutorial for some purpose with my work. i share those sites contents with you through their full reference.

10 great articles for optimizing MySQL queries

This site includes some wonderful tutorial regarding optimization.  The following key features are discuss in the tutorial

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

This is another site which focus on query optimization with several techniques. The discussion includes following topics

• 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

hope that this links will help you most like me.  thanks to all.