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