Found the problem. At some point a new variable, innodb_thread_concurrency, was introduced. It defaults to 32. I had, back to my MyISAM days, thread_concurrency set at 16.
All of CPU was being sucked up to effing context switching between competing threads.
Unbelievable.
(2013-01-07, 10:02 PM)georgia_tech_swagger Wrote: [ -> ]Found the problem. At some point a new variable, innodb_thread_concurrency, was introduced. It defaults to 32. I had, back to my MyISAM days, thread_concurrency set at 16.
All of CPU was being sucked up to effing context switching between competing threads.
Unbelievable.
That's odd. I know about that setting. I think it's suppose to be double your cores. So if you have 2 cores then it should be set to 4 threads. You might want to lower it to 8 or even less.
Yes I double checked. If you have a dual core turn it to 4 threads.