Whats the best book or article you have read on optimizing mysql servers (linux)?

Question

I am searching for a good book or article which will help me optimize my mysql servers even more. I am using InnoDB and want to make sure the whole db is loaded into RAM but don't know how.

Answer 1

You might give more detail on the type of app, schema, joins, indexing, etc. Also your operating systme, what kind of host/server and RAID, specific issues. However

these blogs are some of the best for detailed insights

http://provenscaling.com/blog/

http://highscalability.com/tags/mysql

http://xaprb.com/blog/

http://mysqldba.blogspot.com/

http://mysqldatabaseadministration.blogspot.com/

Answer 2

High Peformance MySQL Second Edition is highly recommended.