List:General Discussion« Previous MessageNext Message »
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
View as plain text  
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
Thread
Best hardware for a very large MySQL server? looking at x86JW4 Apr
  • Re: Best hardware for a very large MySQL server? looking at x86Tod Harter4 Apr
Re: Best hardware for a very large MySQL server? looking at x86JW4 Apr
  • Re: Best hardware for a very large MySQL server? looking at x86Dan Nelson4 Apr
    • More then 2-way SMP, process threading & Sun Fire v880: Re: Best hardware for a very large MySQL server? looking at x86JW4 Apr
      • Re: More then 2-way SMP, process threading & Sun Fire v880: Re: Best hardware for a very large MySQL server? looking at x86Dan Nelson4 Apr