MySQL Forums
Forum List  »  MySQL Workbench

Re: Not enough memory to allocate insert buffer of size 1073741824
Posted by: Xin Li
Date: August 18, 2014 08:14AM

Thank you so mush for your reply.

it seems like the error comes from wbcopytables.exe, but I didn't see much info on the utility.

I just checked my innodb_buffer_pool_size, it is pretty big, shown as below:

innodb_buffer_pool_size | 4294967296

much much higher than 1073741824 which is complained by the error.

what do you think? do you think I should increase the variable even further? by the way, the server is a dedicated server for this task, no other user/application is using the MySQL.

another thought is, the workbench is 32-bit application, I am not sure if it is the reason or not. Unfortunately, there is no 64-bit workbench.

Options: ReplyQuote




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.