Re: Identifying and mitigating an unknown performance bottleneck
Your hardware specs are a little outdated, although in theory 1.5GB ram is sufficient to run a fairly busy box. I would want Xeon or better processors on a production box but failing that core quad or duo. I suspect with that present setup your hard drives may be a bit of a weak link as well.
You new spec sounds much better, although not sure what you mean by keeping back hard drives for desktop? 5 drives would optimally be configured in a raid 1+5 (never can remember raid sets) mirrored then stripped, cuts the the total space by half then stripes across the mirror; with a fast 1500rpm drive read/write speeds will be very fast.
Not sure about the DNS question although doubt that this is actually an issue in this scenario but my watchword to a degree is ‘not all eggs in one basket’ so I tend to keep certain things separated and park my domains one place then either IP point them and use the registras DNS as separate from the hosting box or specify a third party dns service such as ZoneEdit which is fast and reliable. If I need to move domains I can do so quickly and I’m also assured on running on dedicated reliable server for DNS purposes.
Regarding the tweat I would perhaps not may too much heed to that, I tried to ping your site and received 100% packet loss, this may well be for the reason that the network is deliberately not returning icmp echo requests – technically a violation of protocols but I understand that it is somewhat considered now a security aspect and I guess blocking ping requests prevents echo flooding?
Your mention of failure to connect to DB is an aspect that puzzles me, and think you need to start to examine your server logs in detail when events happen, ultimately this is the purpose of logs and the only way you can ever actually investigate and establish what is happening.
As for splitting off the DB to another machine, yes it gives great performance benefits but not to the degree that will make a huge difference to your situation it would simply be overkill, unless you were experiencing really high loads, if you can do it it wouldn’t hurt but simply getting one server running at best and all your network connections as fast as possible is going to make the most noticeable difference.
