MySQL Forums
Forum List  »  NDB clusters

Re: ndb watchdog overslept
Posted by: Mikael Ronström
Date: February 21, 2017 08:34AM

That is what I mean.
When using --single-transaction the dump will start with
BEGIN TRANSACTION. So MySQL will try to use very large
transactions when importing the data into NDB. So if the
--single-transaction is removed the import will happen in
many small transactions instead which will avoid these
problems.

But obviously setting max_allowed_packet smaller also
somehow decreases the transaction size. Not sure exactly how
this happens.

Options: ReplyQuote


Subject
Views
Written By
Posted
3098
d g
February 08, 2017 11:44AM
1421
February 09, 2017 03:06PM
1862
d g
February 11, 2017 08:40PM
1080
d g
February 14, 2017 06:12AM
1139
d g
February 20, 2017 05:17AM
1275
February 21, 2017 04:36AM
1139
February 21, 2017 05:27AM
1058
d g
February 21, 2017 06:04AM
Re: ndb watchdog overslept
1263
February 21, 2017 08:34AM
1163
d g
February 21, 2017 10:38AM
1063
d g
February 22, 2017 08:38AM


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.