… papers, you’ll see a pretty extensive list of suggestions for what to monitor in MySQL. Those are only suggestions; …deadlocks. Deadlocks (and lock wait timeouts, covered in another plugin) are frequent causes of serious errors in applications because the applications often don’t handle deadlocks…
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
…in very long execution times for even simplest queries, or a huge deadlock. In…in MySQL data directory. Unfortunately this is a startup time parameter, so unless you set it early, it will not be available in…what MySQL…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… kinds of other things. In MySQL 5 number of Innodb performance counters were exported and now available in SHOW STATUS output. …a ;; *** WE ROLL BACK TRANSACTION (2) For last deadlock Innodb shows transactions which caused deadlocks, their state during deadlock, what locks they were holding and what…
Post: Test Drive of Solid
September 22, 2006 By 5 Comments
…a deadlock. Test 2: SELECT FOR UPDATE: mysql> begin; Query OK, 0 rows affected (0.00 sec) mysql…what we’ll see in final version. Current behavior is however very different from Innodb in…
