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 15, 2014 09:49AM

> the first table, which does have a long text column, but only 302 rows.

SHOW TABLE STATUS (or otherwise find out how bit that table is).
SELECT MAX(LENGTH(the_long_text_col)) FROM first_table; (to get a clue of how big the biggest row is.)

> we got the same error for all tables

Change max_allowed_packet to something significantly smaller, say, 50M. It should probably be bigger than the SELECT, above.

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.