MySQL Forums
Forum List  »  NDB clusters

Re: linked error "Lock wait timeout exceeded"
Posted by: Martin Skold
Date: June 23, 2005 10:26AM

Communication is definitely a bottleneck if not batching inserts
since each insert will generate one roundtrip over the network
(when batching, messages for several operations are piggy backed).
Also if you load inserts with division into several transaction you
will keep locks for a long time.
Have you tried LOAD DATA INFILE ... ?
You mention in the subject you had a cluster crash, any information
you can send on that?

-- Martin

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.