I have been receiving many requests on writing a detailed server optimization guide. Unfortunately, at the moment I am quite busy with work. However, while I keep you guys waiting, keep watching this post as I will post some of the available MySQL and Apache optimization resources.
If you know of a good tutorial on tuning MySQL and Apache, please add it by adding your comments.
EV1 Forums: Four Primary Areas (MySQL, Apache, sysctl.conf, PHP) for Optimizing your server
Jeremy Zawodny: MySQL Tuning Advice
MySQL: MySQL Tuning and Optimization/Optimisation Tips
Linux Magazine: MySQL Performance Tuning (Registration required)