Re: question about innodb_thread_concurrency

Devanada, normally you do not need to tune this option at all. I introduced the option when certain Linux binaries showed 'thread thrashing' at high concurrency. Setting the option to 1 or 2 could in some cases alleviate the problem. You can experiment by setting the option to 500 to disable

Re: question about innodb_thread_concurrency

Heikki Tuuri wrote: Devanada, normally you do not need to tune this option at all. I introduced the option when certain Linux binaries showed 'thread thrashing' at high concurrency. Setting the option to 1 or 2 could in some cases alleviate the problem. You can experiment by setting the option to

question about innodb_thread_concurrency

Hi, This is a question about optimization of mysql's InnoDB performance ... quoting the doc's The default value is 8. If you have low performance and |SHOW INNODB STATUS| reveals many threads waiting for semaphores, you may have thread thrashing and should try setting this parameter lower or