Here's a script that was mentioned on the infrastructure list for tuning your MySQL database.
MySQL tuning script