MySQL Forums
Forum List  »  NDB clusters

Re: Mysql NDB cluster - Big import fail
Posted by: Cesar Hernandez
Date: June 02, 2022 12:52AM

>
> You can work around this by creating a new
> dumpfile. You have 2 options, either remove
> extended inserts completely:
> mysqldump --extended-insert=0
> Or you can set "net_buffer_length" to control the
> size of the extended inserts:
> mysqldump --net_buffer_length=4096
>
> I would try to set net_buffer_length=4096 and
> re-run the import.

Already tried the two choices but no luck

> You can run a grep to see how many inserts are
> created: grep -c INSERT slabb.dump

8058

>
> As Jon suggested, another options is to first
> import data into InnoDB and then run alter table
> and set engine to NDB.

I haven't tried changing the engine after the engine, but I will
>
> Have a good day!
>
> Kind Regards,
> Ted
Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Mysql NDB cluster - Big import fail
106
June 02, 2022 12:52AM


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.