Hi all,

(sorry I have mistakingly posted this message in the 'Tutorial' section:bawling: )

I'm new to dedicated servers and hoping if i could get some help on deciding the server specs.

I'm thinking of a P4 2.4g with 512m ram server and wondering if this is adequate for my site load.

here is what it performs:
intensive mysql queries with php
mysql tracking pageviews consisting of 12,000,000 pageviews (that translates into 140 db update queries per second).

if it's not adequate (or if it's ridiculous), what kind of machine should i be looking at?

thank you in advance for your suggestions.

i really think you should add another 512mb ram making it 1GB ram.

140? Well, I would recommend a server with 1GB RAM at least. If your budget allows, go for SCSI too.

Yeap SCSI I think is a Must, better put a Raid 5 with 5 of those disks, give a 30% increase in performance, with such heavy I/O, u will need it.

I had a forum with those kinds of pageviews and the server choked with 512MB Ram. I added another 512 and it ran perfectly. 512 is not enough for you.

Thank you all for your suggestions!!
I'll look around:D
mostlikely post again with more questions;)

Hi,

So is it the memory and hd that matters in terms of DB I/O performance? and not the CPU?

CPU should be fine. IDE harddrive will be a bottleneck. 512 Mb RAM may be enough if you get a SCSI drive, but 1 GB RAM is the best.

phpdeveloper,

Thanks for your comment:)
So I guess i'll go with the plan and upgrade the ram and hd.