Community

Identifying and killing blocking transactions in InnoDB

(Todd Farmer) The MySQL Server has a few options to help deal with transactions holding InnoDB locks for excessive periods of time. The –innodb-lock-wait-timeout option is one such option, but that just affects statements waiting on locks already held by another transaction. If you want to ensure

Read More - Register for Free Membership