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 are in a "waiting for table" status. Does this mean that
until these 8 threads finish everything else will just wait or have a
lower execution priority /*Possible deadlock case*/?
For this page
http://www.mysql.com/doc/en/SHOW_VARIABLES.html
* 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 at the same time.
I know that there is an abstraction layer in mysql to make various OS
thread behavior act much like POSIX threads, but the statement above
seems to indicate that this is a Solaris specific option.
Sthreads
Pthreads
Are a bit different, how does this option behave on Linux? Is
concurrency dependent upon an execution state?
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
