Shared servers are often "oversold" which if one bitches about it to most hosts and says, "Well I have 25 customer sites w/ yuse' guyz' that I will put elsewhere" they will move your domain/server space to a less crowded server.
The "Overload" I assume means "Over CPU Quota" that some host firms RAG about absolutely is BS, I got into this with a clients site at Apollo with them. Why! They had no idea who they was messin' with!!!! I (as noted) am a programmer and I know CPU's, Assembler, Registers, Addressing, Opcodes, operands and clock cycles! Bits, Bytes & Nybbles! LOL. Not that I've had much need to code anything in assembler in years. Anyways... They claim that a "site" is using too much CPU and essentially there is NO effective way to measure that. Profiling software exists for applications development as well as measuring server performance. However, THEY install Apache, PHP, MySQL and who knows what else? ALL thats stuff eats CPU. So... simple. I tell em' "Show me, I am fully aware of CPU's, Clock Cycles etc". Show me. The bottom line is they cant or wont. Usually they are trying to upsell.
Most host firms that have a good idea of what they are doing do run seperate database servers. BEWARE host firms that have mySQL or MSSQL on the same server as your domain. They tend to say "Unlimited database size" and you'll find the performance curve will tend to suffer as one grows degrading in a much faster fashion than seems sensible.
Always look for hosting that has a seperate DB server. They tend to limit em', like 150MB of space for example.
A good new thread area here might be hosting yes?[/b]
Hi, actually I meant not what the host companies are providing but the solution itself. I have my own server and I'm curious of such big sites that needs separate boxes for app and db. New thread on hosting will be nice