Re: Serwer Hardware p4 or pIII ?
Hello. On Fri 2002-12-06 at 14:57:00 -0500, [EMAIL PROTECTED] wrote: Helmut, I suppose that depends really upon the composition of your database. That's completely true. On the data stored and how it is used, i.e. what are common queries. [...] The only other thing that I can add is if your database is going to be relatively small (In comparison to some of the databases discussed on this list.) you will probably see admirable performance on the fastest Pentium 4 and the fastest AMD Athlon XP+ system you can build or buy. (Based upon an earlier response that states how Intel beefed up the FPU in the Pentium 4.) I feel as long as you don't skimp on the hardware, you shouldn't have too many issues. Helmet, I wanted to generalize the above: it should not matter which CPU you go with. Even if one of the two would be 10% faster. The moment you really need these 10%, you are in trouble anyhow (because queries are going to pile up) and would go with a different solution. In other words: if your 2 CPUs are too slow, you don't take faster ones, you go with a 4 CPU or a clustering solution or such. Similarly, if your disks are too slow, you don't only buy the fastest, but go with RAID 10 or such. Operating your system at the limit is going to make you more trouble than it's worth the savings. Well, now the real question is, where is your intended usuage relatively to the limit of the suggested hardware? That, you can only find out yourself. [...] I am assembling mysql only server. I am planning 2Gb RAM, 4 x 15k SCSI disks. However I cannot decide if I should get 2 p4 processors or 2 tuallatin pIII. I could not find any mysql specif?c benchmarks, that would show which processors I should use. I will be running linux on the server. Could anyone share his/hers experience with me ? A reasonable approach is to test on common hardware and look what becomes the bottleneck. You don't want any default benchmark, because those very specific things and not your application. So be sure to benchmark your usage against a real system before deciding. Use a reasonable desktop PC before, if you have nothing else at hand. Although this will make some work, assuring the hardware will be up to your needs, will save you buying another server just after starting production use. And as Robert said, for average databases - that means, average regarding what is asked on this list, a single CPU dektop system would do fine. If your application is more demanding, it really, really, depends on your usuage patterns. If everything (used) fits in memory, disk speed becomes almost meaningless. If the (used) database size is 100 times the disk size, fastest RAID is needed and CPU speed becomes almost meaningless (because it is waiting all the time for the disks). That are extreme corner-cases, but I think you get the point: Test it! HTH, Benjamin. I have often wondered about that myself so I would be interested in other people's views. I currently run a number of servers with dual 1GHz P3's. Andy - 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 __ 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 -- [EMAIL PROTECTED] - 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
Re: Serwer Hardware p4 or pIII ?
Thank you all for your input. I've gathered the information I need to start with. thank you again --- Benjamin Pflugmann [EMAIL PROTECTED] wrote: Hello. On Fri 2002-12-06 at 14:57:00 -0500, [EMAIL PROTECTED] wrote: Helmut, I suppose that depends really upon the composition of your database. That's completely true. On the data stored and how it is used, i.e. what are common queries. [...] The only other thing that I can add is if your database is going to be relatively small (In comparison to some of the databases discussed on this list.) you will probably see admirable performance on the fastest Pentium 4 and the fastest AMD Athlon XP+ system you can build or buy. (Based upon an earlier response that states how Intel beefed up the FPU in the Pentium 4.) I feel as long as you don't skimp on the hardware, you shouldn't have too many issues. Helmet, I wanted to generalize the above: it should not matter which CPU you go with. Even if one of the two would be 10% faster. The moment you really need these 10%, you are in trouble anyhow (because queries are going to pile up) and would go with a different solution. In other words: if your 2 CPUs are too slow, you don't take faster ones, you go with a 4 CPU or a clustering solution or such. Similarly, if your disks are too slow, you don't only buy the fastest, but go with RAID 10 or such. Operating your system at the limit is going to make you more trouble than it's worth the savings. Well, now the real question is, where is your intended usuage relatively to the limit of the suggested hardware? That, you can only find out yourself. [...] I am assembling mysql only server. I am planning 2Gb RAM, 4 x 15k SCSI disks. However I cannot decide if I should get 2 p4 processors or 2 tuallatin pIII. I could not find any mysql specif?c benchmarks, that would show which processors I should use. I will be running linux on the server. Could anyone share his/hers experience with me ? A reasonable approach is to test on common hardware and look what becomes the bottleneck. You don't want any default benchmark, because those very specific things and not your application. So be sure to benchmark your usage against a real system before deciding. Use a reasonable desktop PC before, if you have nothing else at hand. Although this will make some work, assuring the hardware will be up to your needs, will save you buying another server just after starting production use. And as Robert said, for average databases - that means, average regarding what is asked on this list, a single CPU dektop system would do fine. If your application is more demanding, it really, really, depends on your usuage patterns. If everything (used) fits in memory, disk speed becomes almost meaningless. If the (used) database size is 100 times the disk size, fastest RAID is needed and CPU speed becomes almost meaningless (because it is waiting all the time for the disks). That are extreme corner-cases, but I think you get the point: Test it! HTH, Benjamin. I have often wondered about that myself so I would be interested in other people's views. I currently run a number of servers with dual 1GHz P3's. Andy - 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 __ 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 -- [EMAIL PROTECTED] __ 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
RE: Serwer Hardware p4 or pIII ?
Robert, thank you for your answer. I will be using the server strictly for MySQL database. That will be a backend for several Web Applications written mostly in PHP. What hardware is advised in such a configuration ? --- Robert Adkins [EMAIL PROTECTED] wrote: I am running a few AMD based servers in our offices here and have no issues with them. The big question is, What kind of operations are you most likely to see with your servers? If the servers will be doing some heavy floating point operations stay away from the Intel P4. (Unless recent versions have been fixed.) The Pentium 4 has a TERRIBLE FPU. If you need high FPU and MUST stick with Intel, then by all means look for Pentium III CPUs or look from some Pentium Xeon CPUs. If you aren't brand specific, take a look at AMD. They perform admirably for FPU options. For instance, there is one workstation application that we have for developing CNC Mill cutter path that simply tears things up when it is run on an AMD chip. Our old system would take nearly an hour to generate the same cutter path that is generated in less then 30 seconds on the AMD Chip. (Athlon 2000+ XP) In the tests performed by our vendor, a similar speed Pentium 4 takes quite a bit longer to generate the same cutter path. Something close to 5 minutes longer. Of course, that's all FPU doing the work there. The one thing that the P4 has over the AMD Athlon XP and P3 CPUs is raw memory bandwidth. It can easily outpace both of those other processors for VERY specific operations, like video editing and other HIGH Memory bandwidth hungry applications. Depending upon what you are building, you might want to utilize more then one CPU type across several boxes to be able to utilize the strengths of each processor design. Good luck! Regards, Robert Adkins II IT Manager/Buyer Impel Industries, Inc. Ph. 586-254-5800 Fx. 586-254-5804 -Original Message- From: andy thomas [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 1:33 PM To: [EMAIL PROTECTED]; Helmut Apfelholz; Robert Adkins Cc: [EMAIL PROTECTED] Subject: Re: Serwer Hardware p4 or pIII ? On Wed, 4 Dec 2002, Helmut Apfelholz wrote: Hi, I am assembling mysql only server. I am planning 2Gb RAM, 4 x 15k SCSI disks. However I cannot decide if I should get 2 p4 processors or 2 tuallatin pIII. I could not find any mysql specif?c benchmarks, that would show which processors I should use. I will be running linux on the server. Could anyone share his/hers experience with me ? I have often wondered about that myself so I would be interested in other people's views. I currently run a number of servers with dual 1GHz P3's. Andy - 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 __ 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
RE: Serwer Hardware p4 or pIII ?
Helmut, I suppose that depends really upon the composition of your database. Unfortunately, I am far from an expert when it comes to MySQL or virtually any other database, I just happen to know a little bit about hardware and some performance related information. All of that is only on the low-end commodity hardware of the personal computer. If you know what size database, meaning how many tables and how much information you will have in the database then I am certain that other more database knowledgeable members of this list will be able to offer some suggestions. The only other thing that I can add is if your database is going to be relatively small (In comparison to some of the databases discussed on this list.) you will probably see admirable performance on the fastest Pentium 4 and the fastest AMD Athlon XP+ system you can build or buy. (Based upon an earlier response that states how Intel beefed up the FPU in the Pentium 4.) I feel as long as you don't skimp on the hardware, you shouldn't have too many issues. Good luck. Regards, Robert Adkins II IT Manager/Buyer Impel Industries, Inc. Ph. 586-254-5800 Fx. 586-254-5804 -Original Message- From: Helmut Apfelholz [mailto:[EMAIL PROTECTED]] Sent: Friday, December 06, 2002 7:39 AM To: Robert Adkins; andy thomas; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: Serwer Hardware p4 or pIII ? Robert, thank you for your answer. I will be using the server strictly for MySQL database. That will be a backend for several Web Applications written mostly in PHP. What hardware is advised in such a configuration ? --- Robert Adkins [EMAIL PROTECTED] wrote: I am running a few AMD based servers in our offices here and have no issues with them. The big question is, What kind of operations are you most likely to see with your servers? If the servers will be doing some heavy floating point operations stay away from the Intel P4. (Unless recent versions have been fixed.) The Pentium 4 has a TERRIBLE FPU. If you need high FPU and MUST stick with Intel, then by all means look for Pentium III CPUs or look from some Pentium Xeon CPUs. If you aren't brand specific, take a look at AMD. They perform admirably for FPU options. For instance, there is one workstation application that we have for developing CNC Mill cutter path that simply tears things up when it is run on an AMD chip. Our old system would take nearly an hour to generate the same cutter path that is generated in less then 30 seconds on the AMD Chip. (Athlon 2000+ XP) In the tests performed by our vendor, a similar speed Pentium 4 takes quite a bit longer to generate the same cutter path. Something close to 5 minutes longer. Of course, that's all FPU doing the work there. The one thing that the P4 has over the AMD Athlon XP and P3 CPUs is raw memory bandwidth. It can easily outpace both of those other processors for VERY specific operations, like video editing and other HIGH Memory bandwidth hungry applications. Depending upon what you are building, you might want to utilize more then one CPU type across several boxes to be able to utilize the strengths of each processor design. Good luck! Regards, Robert Adkins II IT Manager/Buyer Impel Industries, Inc. Ph. 586-254-5800 Fx. 586-254-5804 -Original Message- From: andy thomas [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 1:33 PM To: [EMAIL PROTECTED]; Helmut Apfelholz; Robert Adkins Cc: [EMAIL PROTECTED] Subject: Re: Serwer Hardware p4 or pIII ? On Wed, 4 Dec 2002, Helmut Apfelholz wrote: Hi, I am assembling mysql only server. I am planning 2Gb RAM, 4 x 15k SCSI disks. However I cannot decide if I should get 2 p4 processors or 2 tuallatin pIII. I could not find any mysql specif?c benchmarks, that would show which processors I should use. I will be running linux on the server. Could anyone share his/hers experience with me ? I have often wondered about that myself so I would be interested in other people's views. I currently run a number of servers with dual 1GHz P3's. Andy - 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 __ 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
RE: Serwer Hardware p4 or pIII ?
Its more to do with the amount of memmory than its speed. As MySQL will try and load as much data (tables) into memmory as posible the more the better. The next thing is disc speed. Simon -Original Message- From: Nicolas MONNET (Tech) [mailto:[EMAIL PROTECTED]] Sent: 04 December 2002 15:46 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? - 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
RE: Serwer Hardware p4 or pIII ?
I am running a few AMD based servers in our offices here and have no issues with them. The big question is, What kind of operations are you most likely to see with your servers? If the servers will be doing some heavy floating point operations stay away from the Intel P4. (Unless recent versions have been fixed.) The Pentium 4 has a TERRIBLE FPU. If you need high FPU and MUST stick with Intel, then by all means look for Pentium III CPUs or look from some Pentium Xeon CPUs. If you aren't brand specific, take a look at AMD. They perform admirably for FPU options. For instance, there is one workstation application that we have for developing CNC Mill cutter path that simply tears things up when it is run on an AMD chip. Our old system would take nearly an hour to generate the same cutter path that is generated in less then 30 seconds on the AMD Chip. (Athlon 2000+ XP) In the tests performed by our vendor, a similar speed Pentium 4 takes quite a bit longer to generate the same cutter path. Something close to 5 minutes longer. Of course, that's all FPU doing the work there. The one thing that the P4 has over the AMD Athlon XP and P3 CPUs is raw memory bandwidth. It can easily outpace both of those other processors for VERY specific operations, like video editing and other HIGH Memory bandwidth hungry applications. Depending upon what you are building, you might want to utilize more then one CPU type across several boxes to be able to utilize the strengths of each processor design. Good luck! Regards, Robert Adkins II IT Manager/Buyer Impel Industries, Inc. Ph. 586-254-5800 Fx. 586-254-5804 -Original Message- From: andy thomas [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 1:33 PM To: [EMAIL PROTECTED]; Helmut Apfelholz; Robert Adkins Cc: [EMAIL PROTECTED] Subject: Re: Serwer Hardware p4 or pIII ? On Wed, 4 Dec 2002, Helmut Apfelholz wrote: Hi, I am assembling mysql only server. I am planning 2Gb RAM, 4 x 15k SCSI disks. However I cannot decide if I should get 2 p4 processors or 2 tuallatin pIII. I could not find any mysql specif?c benchmarks, that would show which processors I should use. I will be running linux on the server. Could anyone share his/hers experience with me ? I have often wondered about that myself so I would be interested in other people's views. I currently run a number of servers with dual 1GHz P3's. Andy - 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
RE: Serwer Hardware p4 or pIII ?
I saw some discussion on this topic last night, and forgot to put in my .02: Whomever said that memory and hard disk hardware should be the focal point in a new mySQL DB server, and not processors, I very much disagree with. While I agree that ample and fast memory, in addition to an efficient, reliable, and speedy storage system, is vital, neither of those mean squat if you don't have a high speed bus and powerful CPU to do the computations. You can have gigs and gigs of RAM and the fastest SCSI RAID array, for all I care, if it's still on a tiny 100MHZ FSB (like _original_ P3s), you still have a huge bottleneck looming on your horizon. I've been an AMD user for quite some time, and I really think AMD can kick some butt, but I think the statement that P4 FPU performance is poor is not entirely correct. the 2.53GHz P4 is right on par, if not better, than all but the highest (2600+) AMD XP chips. The 2.8 certainly edges them out, and the 3.06 GHz's performance is ASTONISHING. This is based on multiple benchmarks I've either seen or done, so I'm not just talking whitepapers (and keep in mind, I've been a big AMD fan for a couple years now). I refused to be impressed by the performance of Intel's processors, but this made my head spin. As far as cash goes, yes the 3.06 is VERY expensive (around $700 right now), but the other tiers below it are getting ever more reasonable. It comes down to cash flow, I think. P3's strong points is that they are tried and true, powerful, reliable, but inexpensive. P4's fast memory bandwidth, and the upper echelon of P4s are just impressive, but expensive. AMD's are cheap and pack a good punch. I won't go into Xeon, MP, and other multi-proc stuff, that's a slightly different ballgame. I very much agree with mixing and matching different types of boxes based on their strongpoints. Mike -Original Message- From: Robert Adkins [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 9:22 AM To: andy thomas; [EMAIL PROTECTED]; Helmut Apfelholz Cc: [EMAIL PROTECTED] Subject: RE: Serwer Hardware p4 or pIII ? I am running a few AMD based servers in our offices here and have no issues with them. The big question is, What kind of operations are you most likely to see with your servers? If the servers will be doing some heavy floating point operations stay away from the Intel P4. (Unless recent versions have been fixed.) The Pentium 4 has a TERRIBLE FPU. If you need high FPU and MUST stick with Intel, then by all means look for Pentium III CPUs or look from some Pentium Xeon CPUs. If you aren't brand specific, take a look at AMD. They perform admirably for FPU options. For instance, there is one workstation application that we have for developing CNC Mill cutter path that simply tears things up when it is run on an AMD chip. Our old system would take nearly an hour to generate the same cutter path that is generated in less then 30 seconds on the AMD Chip. (Athlon 2000+ XP) In the tests performed by our vendor, a similar speed Pentium 4 takes quite a bit longer to generate the same cutter path. Something close to 5 minutes longer. Of course, that's all FPU doing the work there. The one thing that the P4 has over the AMD Athlon XP and P3 CPUs is raw memory bandwidth. It can easily outpace both of those other processors for VERY specific operations, like video editing and other HIGH Memory bandwidth hungry applications. Depending upon what you are building, you might want to utilize more then one CPU type across several boxes to be able to utilize the strengths of each processor design. Good luck! Regards, Robert Adkins II IT Manager/Buyer Impel Industries, Inc. Ph. 586-254-5800 Fx. 586-254-5804 -Original Message- From: andy thomas [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 1:33 PM To: [EMAIL PROTECTED]; Helmut Apfelholz; Robert Adkins Cc: [EMAIL PROTECTED] Subject: Re: Serwer Hardware p4 or pIII ? On Wed, 4 Dec 2002, Helmut Apfelholz wrote: Hi, I am assembling mysql only server. I am planning 2Gb RAM, 4 x 15k SCSI disks. However I cannot decide if I should get 2 p4 processors or 2 tuallatin pIII. I could not find any mysql specif?c benchmarks, that would show which processors I should use. I will be running linux on the server. Could anyone share his/hers experience with me ? I have often wondered about that myself so I would be interested in other people's views. I currently run a number of servers with dual 1GHz P3's. Andy - 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
Re: Serwer Hardware p4 or pIII ?
Does anybody have any benchmarks of MySQL running on otherwise equivalent machines but with different CPUs? 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: 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? - 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
RE: Serwer Hardware p4 or pIII ?
MySQL uses memory and HDD the most and so processor speed is not so important. So I would go with what ever costs me the less. Also how you OS works with the processors will be important. What OS are you going to got for? Threads and OS limits will also play a big part with speed. Simon -Original Message- From: Helmut Apfelholz [mailto:[EMAIL PROTECTED]] Sent: 04 December 2002 13:10 To: [EMAIL PROTECTED] Subject: Serwer Hardware p4 or pIII ? Hi, I am assembling mysql only server. I am planning 2Gb RAM, 4 x 15k SCSI disks. However I cannot decide if I should get 2 p4 processors or 2 tuallatin pIII. I could not find any mysql specif?c benchmarks, that would show which processors I should use. I will be running linux on the server. Could anyone share his/hers experience with me ? TIA Helmut SQL, mysql, database __ 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 - 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
Re: Serwer Hardware p4 or pIII ?
On Wed, 4 Dec 2002, Helmut Apfelholz wrote: Hi, I am assembling mysql only server. I am planning 2Gb RAM, 4 x 15k SCSI disks. However I cannot decide if I should get 2 p4 processors or 2 tuallatin pIII. I could not find any mysql specif?c benchmarks, that would show which processors I should use. I will be running linux on the server. Could anyone share his/hers experience with me ? I have often wondered about that myself so I would be interested in other people's views. I currently run a number of servers with dual 1GHz P3's. Andy - 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
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? - 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
RE: Serwer Hardware p4 or pIII ?
--- 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. So I would go with what ever costs me the less. Also how you OS works with the processors will be important. What OS are you going to got for? It will be Linux, 2.4 kernel Threads and OS limits will also play a big part with speed. Simon -Original Message- From: Helmut Apfelholz [mailto:[EMAIL PROTECTED]] Sent: 04 December 2002 13:10 To: [EMAIL PROTECTED] Subject: Serwer Hardware p4 or pIII ? Hi, I am assembling mysql only server. I am planning 2Gb RAM, 4 x 15k SCSI disks. However I cannot decide if I should get 2 p4 processors or 2 tuallatin pIII. I could not find any mysql specif?c benchmarks, that would show which processors I should use. I will be running linux on the server. Could anyone share his/hers experience with me ? TIA Helmut SQL, mysql, database __ 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 __ 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
Re: Serwer Hardware p4 or pIII ?
Having the fastest memory that is available in your system is not as important as having enough memory in your system. Without sufficient memory, you can choke your whole system and bring your server to a crawl (or even crash). Bruce - Original Message - From: Nicolas MONNET (Tech) [EMAIL PROTECTED] To: Helmut Apfelholz [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, December 04, 2002 9:45 AM 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? - 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
RE: Serwer Hardware p4 or pIII ?
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: 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? - 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