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

reference: http://hackmysql.com/documents

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