Community

Tracking long running transactions in MySQL

(Yoshinori Matsunobu) Sometimes I want to trace transactions that have taken long time to execute. If a transaction is holding row locks for 30 seconds, all other clients requesting locks for the same rows will be blocked for up to 30 seconds (or will get Lock Wait Timeout errors if you set innodb_l

Read More - Register for Free Membership