It would be interesting to compare Athlon vs Pentium III vs Pentium IV vs Pentium IV Xeon at various speeds.
And yes, while a Pentium IV is generally slower than a Pentium III at the same clock rate. What happens when you take the fasted Pentium III (1.4 Ghz?) and compare it with the fastest Pentium IV (3.0 Ghz?) or Xeon (2.? Ghz)?
Also, has anybody compared the performance of SCSI Raid 1, with IDE RAID 1 using a card like 3ware.com that uses independent channels for each drive?
In general, for a particular amount of disk space, IDE RAID, including an extra controller card, tends to be about 1/2 the price (or less) than SCSI. If I used that money and by additional RAM, which will perform better?
It would be interesting to have a comparison of machines (possible sponsored by various vendors, AMD, IBM, Intel, 3ware, penguin, etc) that compared machines with the same retail price running some standard benchmarks. Something like http://www.mysql.com/information/benchmark-results/result-mysql-platform-relative.html but with hardware more recent that a 400 Mhz pentium pro.
Adam Nelson 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).
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.
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:If your bottleneck is memory speed, you will see 100% CPU usage even if
MySQL uses memory and HDD the most and so processorWell, processor speed is also important, on some of
speed is not so
important.
our servers processors are almost 100% occupied.
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?
---------------------------------------------------------------------
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
--------------------------------------------------------------------- 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
