Re: thread_concurrency in linux

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

thread_concurrency in linux

Hi, Does anyone know if thread_concurrency works in linux or is it just limited to Solaris and Windows? I know the general rule is number of CPU's*2 but will this actually have any effect with Linux's threading model? Thanks for any help :) Andrew Mysql, query This message has been scanned

thread_concurrency in linux

Hi, Does anyone know if thread_concurrency works in linux or is it just limited to Solaris and Windows? I know the general rule is number of CPU's*2 but will this actually have any effect with Linux's threading model? Thanks for any help :) Andrew Mysql, query This message has been scanned

Re: thread_concurrency in linux

: Hi, Does anyone know if thread_concurrency works in linux or is it just limited to Solaris and Windows? I know the general rule is number of CPU's*2 but will this actually have any effect with Linux's threading model? Thanks for any help :) Andrew Mysql, query This message has been

RE: thread_concurrency in linux

Hi, Just to make it clear; I mean thread_concurrency, not innodb_thread_concurrency. Cheers, Andrew From: Alex Arul Lurthu [mailto:[EMAIL PROTECTED] Sent: Wed, 29 August 2007 10:10 To: Andrew Braithwaite Cc: mysql@lists.mysql.com Subject: Re

thread_concurrency in linux

Hi, Does anyone know if thread_concurrency works in linux or is it just limited to Solaris and Windows? I know the general rule is number of CPU's*2 but will this actually have any effect with Linux's threading model? Thanks for any help :) Andrew Mysql, query This message has been scanned

Does thread_concurrency do anything on a non-Solaris OS?

Looking around in the docs, I found this regarding thread_concurrency: thread_concurrency On Solaris, mysqld will call thr_setconcurrency() with this value. thr_setconcurrency() permits the application to give the threads system a hint for the desired number of threads that should be run

Re: Does thread_concurrency do anything on a non-Solaris OS?

In the last episode (Feb 20), Bill Marrs said: Looking around in the docs, I found this regarding thread_concurrency: thread_concurrency On Solaris, mysqld will call thr_setconcurrency() with this value. thr_setconcurrency() permits the application to give the threads system a hint

Re: thread_concurrency

On Tue, Oct 14, 2003 at 02:13:35PM -0700, Dathan Vance Pattishall wrote: Does thread_concurrency work for x86 Linux systems? I've never found it to help in the systems I've tweaked. Perhaps someone else has? Is there a particular problem you're trying to fix, or are you just curious? Jeremy

thread_concurrency

Does thread_concurrency work for x86 Linux systems? If so, if a thread is waiting for a table (locked, etc.) does that mean the thread in question could use up a one of the thread_concurrency pooled values? For Instance you have 20 active threads. Thread_concurrency is set to 8 and 8+ threads

thread_concurrency (Try number of CPU's*2 for thread_concurrency)

set-variable= thread_cache=8 # Try number of CPU's*2 for thread_concurrency set-variable= thread_concurrency=8 If I have 2 CPU's, does the above mean that I should set thread_concurrency=16 ? I am using a MySQL database 4.0.4 Regards, Jacob

Re: thread_concurrency (Try number of CPU's*2 for thread_concurrency)

Hi, No, you should set it to 4 if you have 2 CPU :) (2*2 ;)) Regards, Jocelyn - Original Message - From: Jacob Friis Larsen [EMAIL PROTECTED] To: Mysql maillist [EMAIL PROTECTED] Sent: Monday, November 25, 2002 8:46 AM Subject: thread_concurrency (Try number of CPU's*2