Tuning your MySQL server

Thursday Jun 14th 2007 by DatabaseJournal.com Staff

Make your MySQL server fly with these server tuning tips. This series of three articles discusses many of the server configuration items that can make or break an application's performance. This third article, the last in the series, focuses on tuning the database layer for maximum efficiency.

[From IBM DeveloperWorks]

You can do three things to make your MySQL server faster, from least effective to most effective:

  1. Throw hardware at the problem.
  2. Tune the settings of the MySQL process.
  3. Optimize your queries.

Throwing hardware at a problem is often the first thought, especially because databases are resource hogs. This solution can only take you so far, though. In practical terms, you can usually double your central processing unit (CPU) or disk speed, and maybe increase your memory by a factor of 4 or 8.

The article continues at http://www.ibm.com/developerworks/linux/library/l-tune-lamp-3.html?S_TACT=105AGX59&S_CMP=GR&ca=dgr-lnxw25LAMPTuningP3

Mobile Site | Full Site