MySQL Forums
Forum List  »  Newbie

Re: Not enough memory to allocate insert buffer of size 1073741824
Posted by: Rick James
Date: July 27, 2014 11:36AM

1G is awfully big for bulk_insert_buffer_size. Most people leave it at 8M.

What are you running? If it a 32-bit MySQL or a 32-bit OS or you have 4GB (or less) of RAM, then 1G for this setting is simply too big, hence "Not enough memory to allocate insert buffer of size 1073741824". I recommend using a much smaller value.

If you are still using MyISAM, you should probably convert your tables to InnoDB.

Spotted in the changelog:

----- 2009-09-04 5.0.86 and 5.1.39 -- Bugs Fixed -- Performance -----

For MyISAM tables with bulk_insert_buffer_size ( http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_bulk_insert_buffer_size ) values larger than 256KB, the performance of bulk insert operations such as multiple-row INSERT ( http://dev.mysql.com/doc/refman/5.1/en/insert.html ) and INSERT ... SELECT ( http://dev.mysql.com/doc/refman/5.1/en/insert.html ) operations has been improved greatly when up to a hundred rows are inserted at the same time. (Bug #44723 - http://bugs.mysql.com/bug.php?id=44723 )

Options: ReplyQuote


Subject
Written By
Posted
Re: Not enough memory to allocate insert buffer of size 1073741824
July 27, 2014 11:36AM


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.