And one other thing... our smallest load database server was a pair
of G4 XServes, running about 300 queries per second, taking 5%CPU on
the top display (which on OS X is 5% of one CPU).... We ran the same
load on a pair of Sun V440 Quad processor with 16Gbytes of memory and
it used 30 - 50% CPU (which on Solaris is the percentage of all the
CPUs combined). Even switching back to a 32 bit Solaris binary we had
major performance loss compared to the Macs... the bus speed is an
issue on the Sun boxes... fast processors don't mean anything when
they are tied to a sub 200MHz system bus.
Ignoring the time to connect issue in the Anandtech articles because
it simply doesn't affect us, the Mac boxes really perform very very
well for us (which is the only benchmark that means anything to us).
On the 64 bit side if you aren't planning on giving MySQL more than
2GBytes of memory, it's not an issue to start with.
Best Regards, Bruce
On Sep 7, 2005, at 4:23 PM, Scott Haneda wrote:
on 9/7/05 2:40 PM, Bruce Dembecki at [EMAIL PROTECTED] wrote:
We're happy with our Mac based MySQL servers in many respects. We've
got some 64 bit issues that are causing a little grief, so we're
looking at our options... Obviously working with Apple and MySQL to
determine the real reason for the 64 bit failures will be high on
the
list. At the same time we're going to take a look at Yellow Dog's
Linux for Power PC and then we can do a direct comparison and see
what differences a change in Operating System makes to us in real
life, not just what effect it has on Anandtech's "benchmarks", which
don't represent how we work at all. Once we've looked at Yellow Dog
we'll be happy to talk about our experiences there too.
Ok, you are almost selling me on getting an Xserve, can you tell
me a bit
about the 64bit issues and how they affect me? I have someone who
may just
donate my a xserve, one of the older ones, but still, not a bad
piece of
hardware at all.
--
-------------------------------------------------------------
Scott Haneda Tel: 415.898.2602
<http://www.newgeo.com> Novato, CA U.S.A.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]