MySQL Forums
Forum List  »  NDB clusters

Re: how to troubleshoot "Lock wait timeout exceeded; try restarting transaction' ???
Posted by: Michael Neubert
Date: August 09, 2007 02:42AM

Hello,

I can confirm the same problem. I'm using MySQL Cluster 5.1.20 ndb-6.3.2 Telco Edition from source development tree (R 1.2561)...

It occurs mainly in the following situation:
-> the table has a lot of rows (~ 8 Million rows+)
-> there are big varchar(xxxx) or text columns

I get the error even when I use the mysqlimport tool.

At the moment I make good experiences with the following settings:

TransactionDeadlockDetectionTimeout=10000
HeartbeatIntervalDbDb=3000
HeartbeatIntervalDbApi=3000

Maybe this can help you.

Beste wishes
Michael

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.