MySQL Forums
Forum List  »  MySQL Workbench

Advanced Search
New Topic

Re: Not enough memory to allocate insert buffer of size 1073741824
Posted by: Xin Li
Date: August 21, 2014 01:09PM

Thank you very much for your reply.

yes, we have the following variables set to 1G

max_allowed_packet = 1G

the variable max_packet_size you mentioned is max_allowed_packet, right?

I can reduce the variable and give a try. Can you please tell me, if we have a large BLOB column, what will happen if the size of the column is large than max_packet_size? we just don't want to lose any data when we migrate SQL Server DB to MySQL.

thank you so much and looking forward to your reply.

Navigate: Previous Message• Next Message
Options: Reply• Quote




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.