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.
feronso Reviewed by feronso on . Archive my.cnf for VPS 512mb RAM [Help!] Hello, sorry for my English. I have a VPS with 512MB Warez-Host. My site was inoperative for 2 months and lost lots of visitors. When I was in a shared hosting up to 180 users could be connected online in my forum. What happens, in this VPS that I can not have acquired not even 70 users online for every 2 or 3 hours, the forum goes down for 1 hour and then quickly return to after a few hours, turn to fall. I do not know which values ​​have mysql shared hosting, but mine is this: Rating: 5