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:
- 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
Thanks for this set of MySQL articles. I’ll check them soon.
Hugo.
Hugo
June 13, 2008 at 7:20 am
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…
Tarique Sani
June 13, 2008 at 12:20 pm
[...] 10 great articles for optimizing MySQL queries « PHP::Impact ( [str blog] ) [...]
antiprocess.net
June 13, 2008 at 3:08 pm
[...] 10 great articles for optimizing MySQL queries Optimization is a complex task because ultimately it requires understanding of the entire system to be optimized. [...] [...]
Top Posts « WordPress.com
June 14, 2008 at 12:00 am
[...] 10 great articles for optimizing MySQL queries « PHP::Impact ( [str blog] ) (tags: tips database performance) [...]
Donghai Ma
June 14, 2008 at 4:30 am
[...] 10 great articles for optimizing MySQL queries « PHP::Impact ( [str blog] ) (tags: mysql) [...]
Skylog
June 14, 2008 at 6:30 am
Another great article:
An Introduction to Database Normalization
phpimpact
June 15, 2008 at 11:09 am
[...] PHP::Impact Tags: base de datos, db, mysql, optimizacion, [...]
El Blog de Inwe
June 15, 2008 at 6:42 pm
[...] Cargnelutti has gathered a fine bunch of optimizing links for MySql. Read them and learn them by [...]
Learn to optimize MySql Queries | PhpScripter
June 16, 2008 at 10:02 pm
[...] 10 great articles for optimizing MySQL queries [...]
MySQL Queries Optimization by Peter Zaitsev
June 18, 2008 at 8:16 am
[...] 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. [...]
A Digital Notepad
July 1, 2008 at 3:11 pm
Thanks for the links, they will be of great help for the project I’m working on!!!
Re@PeR
July 29, 2008 at 9:49 am
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.
php-trivandrum
September 20, 2008 at 10:43 am
Thanks for this articles. It’s that, what I was looking for – greate job, Thanks.
Praca
October 23, 2008 at 6:26 am
[...] 10 great articles for optimizing MySQL queries [...]
PHP Tutorials Utopia
October 29, 2008 at 4:13 pm
Great articles! Thanks for putting this together, its very useful.
Magnus
October 31, 2008 at 11:34 am
it is a very good set of articles at one place.
Really usefull.
MySQL admin or developer should read it.
Kanhaiya Lal
Kanhaiya
November 5, 2008 at 4:03 pm
that’s a good articles. thanks for your good info to me.
Santos
December 2, 2008 at 5:12 am
[...] 10 great articles for optimizing MySQL queries [...]
Top Posts 2008
January 10, 2009 at 3:01 pm
[...] 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 [...]
Handy MySQL commands and advice | Zen of Linux
January 12, 2009 at 9:49 am
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.
Zen of Linux
January 12, 2009 at 10:08 am
Nice list of mysql querys :D optimizing mysql is so good !!
webdesign
June 10, 2009 at 1:46 pm
[...] 10 grandes artículos para optimizar la consultas a bases de datos MySQL. En inglés. vía: Fedecarg [...]
Sin tiempo para escribir.10, Carrero
July 7, 2009 at 6:21 am