I had an article published about MySQL tuning a while ago:

http://blog.scoutapp.com/articles/2011/02/10/understanding-d...

Always tune for your workload. Be sure to index your damn tables. And yes, measure.