10 great articles for optimizing MySQL queries
  • 2009/11/25 19:44

  • Mamba

  • Moderator

  • Posts: 11377

  • Since: 2004/4/23

Federico Cargnelutti listed 10 articles that 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

Read more here on Federico's Blog, and feel free to add here other source that are good for optimizing MySQL.

Re: 10 great articles for optimizing MySQL queries
  • 2010/7/13 16:01

  • susuanlulu

  • Just popping in

  • Posts: 3

  • Since: 2010/7/13

the first link is said not unsafe by firefox.

Re: 10 great articles for optimizing MySQL queries
  • 2010/9/28 7:38

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1

So, it is better not to open the 'Identifying slow MySQL queries' link (first link in the blog article) until the site there is cleaned up!
No problem for the others.


Who's Online

321 user(s) are online (130 user(s) are browsing Support Forums)

Members: 0

Guests: 321



Goal: $100.00
Due Date: Jun 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits