From: Dan Nelson
Date: April 4 2002 7:32pm
Subject: Re: More then 2-way SMP, process threading & Sun Fire v880: Re: Best hardware for a very large MySQL server? looking at x86
List-Archive: http://lists.mysql.com/mysql/105152
Message-Id: <20020404193250.GB5488@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Apr 04), JW said:
> I was already looking at these... Does anyone have any experience
> with MySQL a v880? Someone on another list was saying:
> 
> "You've got to remember that in a lot of scenerios, more processors
> can degrade preformance instead of enhancing it.  4 Dual processing
> machines always beats one 8-way machine as far as network services
> related things like File/Web/Print serving.  4-way machines can add
> benefit in fine-grain tightly coupled processes like a heavily
> threaded DB server (like Oracle). You start to loose I/O performance
> with most x86 architectures after 4-way."

That's just a limitation of the x86 platform; inter-processor locking
starts getting really expensive above 4 CPUs.  Oracle definitely has no
problems on the 8-way Solaris/Sparc boxes here, so I'd assume MySQL
would run well also.
 
-- 
	Dan "query" Nelson
	dnelson@stripped