This post was originally published on the MySQL Support Team Blog at https://blogs.oracle.com/mysqlsupport/entry/innodb_locks_analysis_why_is on 14 April 2017. Consider the scenario that you execute a query. You expect it to be fast – typically subsecond – but now it take not …

InnoDB Locks Analysis: Why is Blocking Query NULL and How To Find More Information About the Blocking Transaction? Read more »