MySQL Forums :: Newbie :: Not enough memory to allocate insert buffer of size 1073741824


Advanced Search

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 Xin Li 07/25/2014 02:33PM
Re: Not enough memory to allocate insert buffer of size 1073741824 Rick James 07/27/2014 11:36AM
Re: Not enough memory to allocate insert buffer of size 1073741824 Xin Li 07/27/2014 01:07PM
Re: Not enough memory to allocate insert buffer of size 1073741824 Rick James 07/29/2014 06:36PM
Re: Not enough memory to allocate insert buffer of size 1073741824 Xin Li 08/04/2014 12:59PM
Re: Not enough memory to allocate insert buffer of size 1073741824 Xin Li 08/04/2014 02:04PM
Re: Not enough memory to allocate insert buffer of size 1073741824 Xin Li 08/07/2014 02:11PM
Re: Not enough memory to allocate insert buffer of size 1073741824 Rick James 08/09/2014 10:36AM
Re: Not enough memory to allocate insert buffer of size 1073741824 Xin Li 08/11/2014 09:03AM
Re: Not enough memory to allocate insert buffer of size 1073741824 Xin Li 08/11/2014 09:36AM
Re: Not enough memory to allocate insert buffer of size 1073741824 Rick James 08/13/2014 11:24AM
Re: Not enough memory to allocate insert buffer of size 1073741824 Xin Li 08/13/2014 01:08PM
Re: Not enough memory to allocate insert buffer of size 1073741824 Rick James 08/15/2014 09:49AM
Re: Not enough memory to allocate insert buffer of size 1073741824 Katrin Kern 09/17/2014 08:10AM
Re: Not enough memory to allocate insert buffer of size 1073741824 Xin Li 09/26/2014 09:43AM
Re: Not enough memory to allocate insert buffer of size 1073741824 Tech Speedy 10/17/2014 05:33AM


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.