Performance Tuning Best Practices for MySQL

Just noticed a good summary of MySQL performance tuning tips on google video. Not necessarily PHP, but since many of us use MySQL in one way or another, I thought the group might be interested.

Read on for links and more info

http://video.google.com/videoplay?docid=2524524540025172110&q=type%3Agoogle+engEDU&pl=true

“Jay Pipes is a co-author of the recently published Pro MySQL (Apress, … all » 2005), 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. ”

For those who find this interesting, much of the same information is contained in:

High Performance MySQL
http://www.oreilly.com/catalog/hpmysql/index.html