In my previous post I talked about a transaction
which blocked other transactions without doing anything. I talked
about finding data from the blocking transaction using SYS and
But what are the possible solutions?
The first solution is to (automatically) kill the blocking transactions. Long running transactions can also stall the purging in InnoDB. See …