MySQL Forums
Forum List  »  Newbie

Re: Not enough memory to allocate insert buffer of size 1073741824
Posted by: Xin Li
Date: August 11, 2014 09:36AM

I just tried but unfortunately I got the same error message: Not enough memory to allocate insert buffer of size 1073741824

mysql> show global variables like '%bulk%';
+-------------------------+-------+
| Variable_name | Value |
+-------------------------+-------+
| bulk_insert_buffer_size | 25000 |
+-------------------------+-------+
1 row in set (0.00 sec)

mysql> show variables like '%bulk%';
+-------------------------+-------+
| Variable_name | Value |
+-------------------------+-------+
| bulk_insert_buffer_size | 25000 |
+-------------------------+-------+
1 row in set (0.00 sec)


any other things I can try? Thank you very much!

Options: ReplyQuote


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