you need an dedicated server. 4GB RAM and 4 cores is ok. then you can optimize my.cnf

of course you can optimize your vps with this:


query_cache_type=1
query_cache_limit=1
max_user_connections=150
max_connect_errors=20
wait_timeout=20
connect_timeout=20
max_allowed_packed=16M