MySQL Forums
Forum List  »  Newbie

Not enough memory to allocate insert buffer of size 1073741824
Posted by: Xin Li
Date: July 25, 2014 02:33PM

when I use workbench to migrate data from MSSQL to MySQL, I got the following error:

Not enough memory to allocate insert buffer of size 1073741824

I tried to increase the bulk_insert_buffer_size

set global bulk_insert_buffer_size=1073741824;

but it doesn't work.

Please advise what I should do?

Thanks.

Options: ReplyQuote


Subject
Written By
Posted
Not enough memory to allocate insert buffer of size 1073741824
July 25, 2014 02:33PM


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.