If you want to improve MySQL performances you can refer to :

-http://dev.mysql.com/books/hpmysql-excerpts/ch06.html
-http://dev.mysql.com/doc/refman/5.1/en/innodb-tuning.html