MySQL Forums
Forum List  »  NDB clusters

Re: How to resolve "Lock wait timeout exceeded" issue reported by MySQL Cluster
Posted by: Ted Wennmark
Date: June 14, 2016 01:49AM

Hi Steven,

There are several timeouts protecting NDB.
You most likely hit the limit of TransactionDeadlockDetectionTimeout if you are using NDBCLUSTER storage engine.
More details can be found here: https://dev.mysql.com/doc/refman/5.6/en/mysql-cluster-ndbd-definition.html#ndbparam-ndbd-transactiondeadlockdetectiontimeout
The default value is only 1.2 seconds, this is low per default to prevent long running transaction holding to many locks. Be careful setting value of TransactionDeadlockDetectionTimeout to high.

Kind Regards,
Ted

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.