You are here

InnoDB locks and deadlocks with or without index for different isolation level

MySQL Performance Blog - Thu, 09/04/2015 - 6:27pm

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.