Tuning your MySQL server
June 14, 2007[From IBM DeveloperWorks]
You can do three things to make your MySQL server faster, from least effective to most effective:
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.