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]

Reply via email to