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

Categories

Books

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

Facebook