… to consider a high number. With modern hardware and modern 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…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…time running spin locks and doing unneeded context switches. The next section is about deadlock errors: …executed by threads running queries. On Unix/Linux you will always see 4 helper threads…by calling fsync() for modified files. Constant high values for any of these variables …
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… cpus it is BAD, context swiches are much higher. Also creating one key cache for each high concurrency table and preloading indexes helped lower the contention. Moving to linux (centos) allowed to go…
