MySQL Forums :: NDB clusters :: ndb watchdog overslept


Advanced Search

Re: ndb watchdog overslept
Posted by: d g ()
Date: February 21, 2017 10:38AM

mysqldump uses by default "extended INSERT" queries (multiple rows within the same INSERT command). it seems the max-allowed-packet parameter limits the size of this "extended insert" to what is specified. In my case 128M packet lead to many concurrent operations (many multiple row in one insert) and that would explain why i had to raise the parameter MaxNoOfConcurrentOperations but that didnt helped and just overloaded the datanodes (job buffer).

i will test also with 64M packet size and will report my expierience with that.

thank you for your help so far.

Regards
Denny

Options: ReplyQuote


Subject Views Written By Posted
ndb watchdog overslept 205 d g 02/08/2017 11:44AM
Re: ndb watchdog overslept 117 Mikael Ronström 02/09/2017 03:06PM
Re: ndb watchdog overslept 116 d g 02/11/2017 08:40PM
Re: ndb watchdog overslept 73 d g 02/14/2017 06:12AM
Re: ndb watchdog overslept 69 d g 02/20/2017 05:17AM
Re: ndb watchdog overslept 70 Mikael Ronström 02/21/2017 04:36AM
Re: ndb watchdog overslept 49 Mikael Ronström 02/21/2017 05:27AM
Re: ndb watchdog overslept 64 d g 02/21/2017 06:04AM
Re: ndb watchdog overslept 52 Mikael Ronström 02/21/2017 08:34AM
Re: ndb watchdog overslept 52 d g 02/21/2017 10:38AM
Re: ndb watchdog overslept 56 d g 02/22/2017 08:38AM


Sorry, only registered users may post in this forum.

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.