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
