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

  • Mamba

  • Moderator

  • Posts: 11253

  • 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.

2
susuanlulu
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.

3
ghia
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.

Login

Who's Online

50 user(s) are online (25 user(s) are browsing Support Forums)


Members: 0


Guests: 50


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Aug 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits