Re: More than 4 CPUs?

2006-08-19 Thread Jochem van Dieten
On 8/19/06, Wai-Sun Chia wrote: On 8/19/06, Jochem van Dieten wrote: Tweakers.net did a benchmark comparing a trace of the queries generated by their own website on a T1 to a dual Opteron. The article is in Dutch, but the graphs speak for themselves: http://tweakers.net/reviews/633/7

Re: More than 4 CPUs?

2006-08-18 Thread Jochem van Dieten
On 8/12/06, Miles Teg wrote: Sun also has some awesome CoolThreads offerings (SPARC architecture), but I haven't had a chance to benchmark one yet. With 32 concurrent threads on a single 8 core 4 way threaded cpu, I'd like to see how MySQL's performance is on those systems. Does anyone have

Re: More than 4 CPUs?

2006-08-12 Thread Miles Teg
, August 11, 2006 12:53 PM Subject: Re: More than 4 CPUs? From the articles I've read recently, 8 CPU's seems to be the point where the scalability ratio starts dropping. See the following articles for examples: http://developers.sun.com/solaris/articles/mysql_perf_tune.html http

More than 4 CPUs?

2006-08-11 Thread Ed Pauley II
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! -- Ed Pauley II -- MySQL General Mailing List For list

Re: More than 4 CPUs?

2006-08-11 Thread Dan Buettner
Ed, I don't recall that being an issue, though you will likely need to tweak the values of your my.cnf file (thread_concurrency for example) to ensure you're taking advantage of all the cores. This is highly dependent on your situation - but as you increase number of CPUs, where you may start to

Re: More than 4 CPUs?

2006-08-11 Thread Scott Tanner
From the articles I've read recently, 8 CPU's seems to be the point where the scalability ratio starts dropping. See the following articles for examples: http://developers.sun.com/solaris/articles/mysql_perf_tune.html

Re: More than 4 CPUs?

2006-08-11 Thread Michael Loftis
--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