May 24, 2012

Post: How Innodb Contention may manifest itself

July 28, 2011 By 1 Comment

…context switches, however sometimes there is just too much spinning and it becomes inefficient. Reducing innodb_sync_spin_loops variable to…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…

Filed Under: Insight for DBAs, MySQL