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:
- Identifying slow MySQL queries
- MySQL & PHP Performance Optimization Tips
- MySQL Presentations: Optimizing MySQL
- MySQL 5 Optimization and Tuning Guide
- Survive heavy traffic with your Web server
- Tools to use for MySQL Performance – Peter Zaitsev
- MySQL Queries Optimization (video) – Peter Zaitsev
- Table Design and MySQL Index Details
- MySQL Reference Manual: Optimization Overview
- MySQL Reference Manual: The MySQL Query Cache
Federico Cargnelutti 
24 responses to “10 great articles for optimizing MySQL queries”
Thanks for this set of MySQL articles. I’ll check them soon.
Hugo.
Chapter 4 of the Second edition on High Perfomance MySQL is about Query Optimization and a free download http://www.highperfmysql.com/downloads/ – Yeah technically it is not an article but very much related…
[…] 10 great articles for optimizing MySQL queries « PHP::Impact ( [str blog] ) […]
[…] 10 great articles for optimizing MySQL queries Optimization is a complex task because ultimately it requires understanding of the entire system to be optimized. […] […]
[…] 10 great articles for optimizing MySQL queries « PHP::Impact ( [str blog] ) (tags: tips database performance) […]
[…] 10 great articles for optimizing MySQL queries « PHP::Impact ( [str blog] ) (tags: mysql) […]
Another great article:
An Introduction to Database Normalization
[…] PHP::Impact Tags: base de datos, db, mysql, optimizacion, […]
[…] Cargnelutti has gathered a fine bunch of optimizing links for MySql. Read them and learn them by […]
[…] 10 great articles for optimizing MySQL queries […]
[…] 10 great articles for optimizing MySQL queries – Nice links to good sites that aid in MySQL optimization. Many of these tips may apply to other SQL driven databases. […]
Thanks for the links, they will be of great help for the project I’m working on!!!
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.
Thanks for this articles. It’s that, what I was looking for – greate job, Thanks.
[…] 10 great articles for optimizing MySQL queries […]
Great articles! Thanks for putting this together, its very useful.
it is a very good set of articles at one place.
Really usefull.
MySQL admin or developer should read it.
Kanhaiya Lal
that’s a good articles. thanks for your good info to me.
[…] 10 great articles for optimizing MySQL queries […]
[…] to read: A good starting point post is Federico’s post. Or the 10 tips that don’t suck. Related PostsSQL select from two tables with the same field […]
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.
Nice list of mysql querys :D optimizing mysql is so good !!
[…] 10 grandes artículos para optimizar la consultas a bases de datos MySQL. En inglés. vía: Fedecarg […]
or put your slow queries in xcache ;) -> http://lifeofguenter.de/killing-mysql-slow-queries-with-xcache