10 great articles for optimizing MySQL queries

Optimization is a complex task because ultimately it requires understanding of the entire system to be optimized. Although it may be possible to perform some local optimizations with little knowledge of your system or application, the more optimal you want your system to become, the more you must know about it.

The following 10 articles explain and give some examples of different ways to optimize MySQL:

  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

24 thoughts on “10 great articles for optimizing MySQL queries

  1. Pingback: antiprocess.net

  2. Pingback: Top Posts « WordPress.com

  3. Pingback: Donghai Ma

  4. Pingback: Skylog

  5. Pingback: El Blog de Inwe

  6. Pingback: Learn to optimize MySql Queries | PhpScripter

  7. Pingback: MySQL Queries Optimization by Peter Zaitsev

  8. Pingback: A Digital Notepad

  9. Task becomes complex when one does not know how to do this, but getting to know how to do the thing makes us rich with intellect.

    On top of all those tunnings, you will need a sound database to perform correctly. Wise and responsible arrangement of indexes would make the reads much faster. Avoiding flags, and keeping multiple shadow tables would make things simpler.

  10. Pingback: PHP Tutorials Utopia

  11. Pingback: Top Posts 2008

  12. Pingback: Handy MySQL commands and advice | Zen of Linux

  13. Thank you for your list. As mysql tuning is an important topic, I did a try at compiling basic tips myself. Aside from generally understanding the system, I found the tuning-primer.sh script a great help. And your links provided the background.

  14. Pingback: Sin tiempo para escribir.10, Carrero

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s