…. The pmp-check-mysql-deadlocks plugin can help you detect such problems, in conjunction with Percona Toolkit’s pt-deadlock-logger tool. Open…. Similarly to deadlocks and timeouts, applications often don’t handle or log this error appropriately. The pmp-check-mysql-status plugin can… pooling, for example, which can sometimes require application downtime to resolve), then it might be worth considering to let you deal…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… ROLL BACK TRANSACTION (2) For last deadlock Innodb shows transactions which caused deadlocks, their state during deadlock, what locks they were holding and what they were waiting for, which of transactions Innodb decided to roll back to resolve deadlock… id 1148250464, thread declared inside InnoDB 442 mysql tables in use 1, locked 0 MySQL thread id 8079, query id 728899 localhost…
Post: SELECT LOCK IN SHARE MODE and FOR UPDATE
August 6, 2006 By 51 Comments
Baron wrote nice article comparing locking hints in MySQL and SQL Server. In MySQL/Innodb LOCK IN SHARE MODE and SELECT FOR… Innodb level before MySQL performs like matching, and row is not unlocked if it does not match. Smarter deadlock victum scheduling At this point transaction which made least updates is killed to resolve deadlock. Which means if…
Post: Announcing Percona XtraDB Cluster 5.5.29-23.7.1
January 30, 2013 By 8 Comments
… abort transaction that is on the way, caused the deadlock situation. Resolved by grabbing Global Read Lock before pausing wsrep provider. Bug…-Cluster-server and Percona-XtraDB-Cluster-client would conflict with mysql and mysql-server packages. Bug fixed #1087506 (Ignacio Nin). Other bug…
Post: Test Drive of Solid
September 22, 2006 By 5 Comments
… hopefully be resolved in further versions. Test 5: UPDATE / SELECT FOR UPDATE in OPTIMISTIC mode Solid optimistic: Session1: mysql> begin; …: Test 1: Deadlock detection (deadlock is correctly detected): insert into test2 values (1,’Mysql‘),(2,’Solid’),(3,’MyISAM’); Session1: mysql> begin; Query …
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
Even killing FLUSH TABLES WITH READ LOCK won’t resolve the deadlock as of MySQL 5.5 – other queries will still be stuck in ‘Waiting for table flush’ even after the FLUSH TABLES WITH READ LOCK goes away. 
http://bugs.mysql.com/bug.php?id=44884
