Some MySQL Performance tuning links

mySQL Performance Tuning is a good overview of which settings to tune for better performance. A complete list of tuning parameters is here.

MyTop is a cool cool tool authored by Yahoo! Finance's Jeremy Zawodny that shows current activity on a mysql server in a familiar "top" format, perfect for an ssh session.

Zawodny has explained Yahoo's use of MySQL and Perl or PHP many times, including this time.

This presentation outlines the growing pains of LiveJournal.com, and how the architecture had to continually be adjusted to account for growth. Very interesting and easy to follow, chock full of good lessons applicable to any rapidly growing website.