--On August 11, 2006 2:44:34 PM -0400 Ed Pauley II <[EMAIL PROTECTED]> wrote:
It seems like I once read that you don't get any performance gains in MySQL when you go above 4 CPUs per server. Is this correct? I was considering a 4 dual-core CPU machine. Should I go with a 2 dual-core machine instead? Thanks!
Well....That may not be entirely true with Opteron's but with Intel's it is. IT's not just a MySQL thing, past the 4th CPU there just isn't much/any gain because you're bottlenecked on RAM and FSB. I've not personally run such a large MySQL machine but I don't know why there'd be a scaling issue assuming your application is designed properly and does it's best to not lock tables. I'd check to make sure you're CPU bound before investing in so much CPU. More likely you're I/O bound.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
