MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Not enough memory to allocate insert buffer of size 1073741824
Posted by: Rick James
Date: August 13, 2014 11:24AM

Digging deeper...

What about max_allowed_packet (GLOBAL and SESSION)?
(32M may be a reasonable size)
And max_long_data_size ? (It has been removed in newer versions.)
What version of MySQL are you running?

Does Workbench have any tunables that are currently set to 1G?

Are you running on an Operating System (or VM) that can restrict the amount of memory each process can use? And is that limit set to something like 1G (or less) for Workbench (or for all processes)? 32-bit FreeBSD used to have a default of 512M.

Are you inserting large BLOB/TEXT fields? How big might the be?
Are you using Workbench to copy a particular table when this error occurs? For that table, please provide the table schema:
SHOW CREATE TABLE

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


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