Thanks for advice, --- Adam Nelson <[EMAIL PROTECTED]> wrote: > I've posted my comments before but the important > thing is that P4 is > largely unnecessary as it doesn't have instructions > that apply to server > applications (mostly).
thats mainly what I was asking for. I'll go with pIII than. > So, PIII (dual is quite helpful) the fastest you can > get without paying > a premium > 1 GB ram > dual scsi drives (raid 1) > > This is the simplest scenario and will handle tons > of queries (100/sec) > with drive failover (very very nice) very fast and > it can fit in 1U. I'm aiming rather at 500 queries a sec. Will have 4 cheetah SCSI drives. Two pairs of RAID1 and databases will be spread on them. We already run similiar setup and its avarage load is about 250q/s. > If you have less money, I would drop the second > proc, then move to lower > speed proc, then less memory. > > > -----Original Message----- > > From: Nicolas MONNET (Tech) > [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, December 04, 2002 10:46 AM > > To: Helmut Apfelholz > > Cc: [EMAIL PROTECTED] > > Subject: RE: Serwer Hardware p4 or pIII ? > > > > > > On Wed, 2002-12-04 at 15:23, Helmut Apfelholz > wrote: > > > --- Simon Green <[EMAIL PROTECTED]> wrote: > > > > MySQL uses memory and HDD the most and so > processor > > > > speed is not so > > > > important. > > > > > > Well, processor speed is also important, on some > of > > > our servers processors are almost 100% occupied. > > > > If your bottleneck is memory speed, you will see > 100% CPU > > usage even if > > the CPU actually spend 99% of its time idle, > waiting for data to come > > in. > > > > I'm not too up to date on the latest RAM > technology, but I > > hear there's > > several types of DDR, the most expensive one being > > > significantly faster. > > Or is it? > > > > Anyone care to share some insight on this? > > > > > __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php