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 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
