I recently found this really good lecture on performance tuning practices for MySQL. Definatly worth a watch.

Abstract:
Jay Pipes Jay Pipes is a co-author of the recently published Pro MySQL, which covers all of the newest MySQL 5 features, as well as in-depth discussion and analysis of the MySQL server architecture, storage engines, transaction procesing, benchmarking, and advanced SQL scenarios. You can also see his name on articles appearing in Linux Magazine and can read more articles about MySQL at his website.

Check out the video:

Thankyou Google Video!