10 great articles for optimizing MySQL queries
June 12, 2008
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
June 13, 2008 at 7:20 am
Thanks for this set of MySQL articles. I’ll check them soon.
Hugo.
June 13, 2008 at 12:20 pm
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…
June 13, 2008 at 3:08 pm
[...] 10 great articles for optimizing MySQL queries « PHP::Impact ( [str blog] ) [...]
June 14, 2008 at 12:00 am
[...] 10 great articles for optimizing MySQL queries Optimization is a complex task because ultimately it requires understanding of the entire system to be optimized. [...] [...]
June 14, 2008 at 4:30 am
[...] 10 great articles for optimizing MySQL queries « PHP::Impact ( [str blog] ) (tags: tips database performance) [...]
June 14, 2008 at 6:30 am
[...] 10 great articles for optimizing MySQL queries « PHP::Impact ( [str blog] ) (tags: mysql) [...]
June 15, 2008 at 11:09 am
Another great article:
An Introduction to Database Normalization
June 15, 2008 at 6:42 pm
[...] PHP::Impact Tags: base de datos, db, mysql, optimizacion, [...]
June 16, 2008 at 10:02 pm
[...] Cargnelutti has gathered a fine bunch of optimizing links for MySql. Read them and learn them by [...]
June 18, 2008 at 8:16 am
[...] 10 great articles for optimizing MySQL queries [...]
July 1, 2008 at 3:11 pm
[...] 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. [...]
July 29, 2008 at 9:49 am
Thanks for the links, they will be of great help for the project I’m working on!!!
September 20, 2008 at 10:43 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.
October 23, 2008 at 6:26 am
Thanks for this articles. It’s that, what I was looking for - greate job, Thanks.
October 29, 2008 at 4:13 pm
[...] 10 great articles for optimizing MySQL queries [...]
October 31, 2008 at 11:34 am
Great articles! Thanks for putting this together, its very useful.
November 5, 2008 at 4:03 pm
it is a very good set of articles at one place.
Really usefull.
MySQL admin or developer should read it.
Kanhaiya Lal