MySQL Forums
Forum List  »  Newbie

Re: Not enough memory to allocate insert buffer of size 1073741824
Posted by: Rick James
Date: August 09, 2014 10:36AM

Try
set SESSION bulk_insert_buffer_size=25000;
from within Workbench. If you can't do it inside workbench, then try
set GLOBAL bulk_insert_buffer_size=25000;
and restart the MySQL server.

The above instructions should make it so that the value is seen by the client and/or server.

Yes, _decrease_ the value, do not increase the value. The error is complaining about running out of memory; do not aggravate it by asking for even more. Anyway, there is a point of "diminishing returns" beyond which having a bigger buffer does not help more.

In converting from MSSql to MySQL, it would be better to use ENGINE=InnoDB instead of ENGINE=MyISAM when creating tables. The InnoDB engine has features closer to MSSql's. And, InnoDB does not need the 'bulk_insert_buffer';

Options: ReplyQuote


Subject
Written By
Posted
Re: Not enough memory to allocate insert buffer of size 1073741824
August 09, 2014 10: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.