Im looking for a company that can offer me super fast php hosting. It will be large loads with upto 20 php requests a second, the load is so much that i am currently running mysql on a dedicated mysql server. Any ideas ?
Seems you outgrown shared-hosting; 200 connections at every single time is quite a lot for a site running on a shared hosting account (lets say, i wouldn't want to be another user on the same server). So i guess you will be looking at a dedicated server; looking at your stats i would not recommend a VPS to quickly as your IO load will be high. Why not move the site and sql to the same dedicated server?
Sorry i didnt make it clear the mysql server is a shared dedicated mysql server, and i am trying to split my loads between shared servers, i have previously used a dedicated server from staminus but the profits i make cannot sustain it.
Maybe look into semi-dedicated; or high-end VPS servers.
Splitting mySQL from production web hosting in this case doesn't sound logic unless the server is next to your shared-hosting account and lets the traffic go by a secondary network. All other options would make your php script take longer to execute (time needed to connect to the sql server) and thus use more resources.
ben, now i replied several times, and more and more comes falling out of the closet, maybe you should try to explain more about the situation you are in; to me it seems your site simply belongs on a dedicated server. But maybe more information can give others the chance to point you in a better direction.