From: Jay Pipes
Date: September 3 2007 7:25pm
Subject: Re: thread_concurrency in linux
List-Archive: http://lists.mysql.com/mysql/208874
Message-Id: <46DC5FB4.1040701@mysql.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Andrew Braithwaite wrote:
> Does anyone know if thread_concurrency works in linux or is it just
> limited to Solaris and Windows?

Hi!  That variable only affects Solaris, as the Solaris threading 
library supports thr_setconcurrency().

innodb_thread_concurrency, however, can affect all platforms, AFAIK:

http://www.mysql.org/doc/refman/5.0/en/innodb-parameters.html#option_mysqld_innodb_thread_concurrency

> I know the general rule is number of CPU's*2 but will this actually have
> any effect with Linux's threading model?

Nope, at least AFAIK.

-jay