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