[MrEyes]

Originally Posted by FRDS

Who is your current hosting provider?

up there /\ :erm:

I've used PowerVPS in the past, and their mid-range VPS easily supported 150-225 users online at a time with pretty much the same modifictions you've listed and a few more.

If you're able to optmize your VPS, have you tried doing that let? Sometimes it'll help fill the gap in between needing a VPS, and needing a dedicated server.

My main problem is that I am no expert at server administration, I can do the technical side of code but server administration is a new game to me, unfortunately my site became extremely popular extremely quickly so I was unexpectedly thrown in the deep end with concrete boots. I am just about keeping afloat.

Looking at the PowerVPS package pages, my current package is more or less the same as their "LINUX CPANEL BASIC VPS" (no mention of burstable RAM). So based on what you have said maybe there is room for the host to make some optimisations (are you listening? (not you FRDS) )

To give you an idea these are my current SQL stats (this is after 2 days 22 hours of uptime)

__ Key __________________________________________________ _______________
Buffer used 6.54M of 8.00M %Used: 81.76
Current 7.95M %Usage: 99.39
Write hit 42.02%
Read hit 99.46%

__ Questions __________________________________________________ _________
Total 4.74M 18.7/s
DMS 4.30M 16.9/s %Total: 90.74
Com_ 222.45k 0.9/s 4.69
COM_QUIT 216.36k 0.9/s 4.56
+Unknown 282 0.0/s 0.01
Slow (10) 332 0.0/s 0.01 %DMS: 0.01 Log: OFF
DMS 4.30M 16.9/s 90.74
SELECT 3.10M 12.2/s 65.33 71.99
INSERT 626.28k 2.5/s 13.20 14.55
UPDATE 513.76k 2.0/s 10.83 11.94
DELETE 53.41k 0.2/s 1.13 1.24
REPLACE 11.96k 0.0/s 0.25 0.28
Com_ 222.45k 0.9/s 4.69
change_db 215.13k 0.8/s 4.54
set_option 1.93k 0.0/s 0.04
show_proces 846 0.0/s 0.02