This site is currently being run off of a (slow) dedicated server.
A Pentium III 450 Mhz machine with 128 mb of ram. It has been for all of ONE DAY. I thought this would be enough for only these forums, but apparently not. All 128 megs of ram are used up in addition to another ~90-150 megs of swap. The cpu mainly runs at 3% usage with frequent short spikes up to 25% and more. (I noticed it even go to as much as 80% usage for very very brief periods of time!!)
Obviously this site is busting at the seams trying to use this server - which has only been up for a day. Therefore, an upgrade is definitely in order. Here are three setups I'm looking at. Which do you think would be better suited to run this site alone, which mainly interacts with MySQL and php.
Pentium 4 1.8 ghz with 512 mb of SDRAM
Celeron 1.8 ghz with 1024 mb of SDRAM
Celeron 2.0 ghz with 256 mb DDR RAM
All three solutions come equipped with a 40 gigabyte IDE drive with ~1000 gb bandwidth/month. In addition, they're all similar in price (give or take a very few dollars/month).
Of these three, which would be the best solution (in your opinion) for a database driven site? As far as I know, ram and ram speed are most important over processor speed. Please don't suggest a machine with specs higher than any of these three, because it is most likely above my price range. In addition, I am looking for a long-term solution that I can grow into (if possible). Just as long as it isn't something that daniweb.com will outgrow in the next few months, growing at the rate we are.