There is not only MySQL in VPS, Apache and PHP configuration also the fact that count for speed and minimize the cpu load.

What i suggest in your place is to first

Run MySQL Tunner script and follow that.
Tunning the Apache settings
make sure use FastCGI with Apache to serve PHP/Dynamic things.

All tutorial available in VPS Management forum in the last on Main index of this forum. Go -> Read -> Implement.