MySQL :: Re: How to resolve "Lock wait timeout exceeded" issue reported by MySQL Cluster

New Topic

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

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Views

Written By

Posted

How to resolve "Lock wait timeout exceeded" issue reported by MySQL Cluster

5448

Jingyu Hu

May 26, 2016 03:53AM

Re: How to resolve "Lock wait timeout exceeded" issue reported by MySQL Cluster

3127

Mikael Ronström

May 30, 2016 09:05AM

Re: How to resolve "Lock wait timeout exceeded" issue reported by MySQL Cluster

2090

Jingyu Hu

May 30, 2016 10:16PM

Re: How to resolve "Lock wait timeout exceeded" issue reported by MySQL Cluster

3213

Steven Welz

June 13, 2016 08:26AM

Re: How to resolve "Lock wait timeout exceeded" issue reported by MySQL Cluster

2491

Ted Wennmark

June 14, 2016 01:49AM

Re: How to resolve "Lock wait timeout exceeded" issue reported by MySQL Cluster

1931

Steven Welz

June 15, 2016 04:57AM

Re: How to resolve "Lock wait timeout exceeded" issue reported by MySQL Cluster

2235

Ted Wennmark

June 16, 2016 05:57AM

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.