Categorized | News

Optimizing MySQL for Heavy Loads

Posted on 16 September 2002 by Demian Turner

Jeremy Zawodny, Yahoo!’s MySQL expert, reveals some interesting tips on MySQL optimization. Zawodny is in the interesting position of making sure things run smoothly for Yahoo’s PHP/MySQL setup.
A typical day:

  • up to 3,150 simultaneous connections on a single DB
  • 45 server webfarm feeding into one master DB server
  • 260 million record tables
  • Size of database: 25 GB

It’s good to see PHP/MySQL holding it’s own on the front lines 🙂

Bookmark and Share

Leave a Reply



Demian Turner's currently-reading book recommendations, reviews, favorite quotes, book clubs, book trivia, book lists



PHPkitchen recommends you also check out the following sites :

Accounting for Small Businesses

FreeAgent sign-up