Recently, I was working on one of the issue related to locks and deadlocks with InnoDB tables and I found very interesting details about how InnoDB locks and deadlocks works with or without index for different Isolation levels. Here, I would like to describe a small test case about how SELECT ..FOR UPDATE (with and without limit) behave [&]

The post InnoDB locks and deadlocks with or without index for different isolation level appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/04/09/innodb-locks-deadlocks-without-index-different-isolation-level/