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
