One Box to Rule Them All ;]

Did anyone red really good book/post about MySQL performance tuning from developer perspective? Im talking about all "SELECT*" optimizing :) If you can recommend any good reading - gamebit@gmail.com

Working on mokejimai.lt see some problems with MySQL query performance. While there was not many records everything looked good. Now then we got almost 4milion records some query starting to slow down. Don't get me wrong - main querys what user sees still executing in "Query took 0.0007 sec", but some querys on administration side can take really long time :) Looking forward i think i should reed some smart literature.