… Linux process scheduler you can be looking at 500.000+ context switches which system can do. I would look at some 200.000 context switches a second as the point where context switching itself can…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… between wasting CPU time running spin locks and doing unneeded context switches. The next section is about deadlock errors: ———————— LATEST DETECTED DEADLOCK… query executions are executed by threads running queries. On Unix/Linux you will always see 4 helper threads, on Windows it…
Comment: How Percona diagnoses MySQL server stalls
March 9, 2011 By 6 Comments
… the deadlock the most evident OS parameter was the CPU context switches, from 10-20k to 300-400k and hundreds of processes…. if you use cores on different cpus it is BAD, context swiches are much higher. Also creating one key cache for… table and preloading indexes helped lower the contention. Moving to linux (centos) allowed to go back to 16 cores.
