MySQL :: Re: Not enough memory to allocate insert buffer of size 1073741824

New Topic

Re: Not enough memory to allocate insert buffer of size 1073741824

Posted by: Shane Bester
Date: August 16, 2014 04:56AM

bulk_insert_buffer_size is not used for innodb, so don't bother with it.
InnoDB would benefit most from increasing innodb_buffer_pool_size.

See
https://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_bulk_insert_buffer_size

And:

http://dev.mysql.com/doc/refman/5.6/en/optimizing-innodb.html

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Views

Written By

Posted

Not enough memory to allocate insert buffer of size 1073741824

2599

Xin Li

July 29, 2014 02:14PM

Re: Not enough memory to allocate insert buffer of size 1073741824

814

Xin Li

August 04, 2014 02:20PM

Re: Not enough memory to allocate insert buffer of size 1073741824

782

Xin Li

August 07, 2014 02:10PM

Re: Not enough memory to allocate insert buffer of size 1073741824

854

douglas wilson

August 21, 2014 02:46AM

Re: Not enough memory to allocate insert buffer of size 1073741824

818

Shane Bester

August 16, 2014 04:56AM

Re: Not enough memory to allocate insert buffer of size 1073741824

775

Xin Li

August 18, 2014 08:14AM

Re: Not enough memory to allocate insert buffer of size 1073741824

770

Juan Rene Ramirez Monarrez

August 21, 2014 12:21PM

Re: Not enough memory to allocate insert buffer of size 1073741824

820

Xin Li

August 21, 2014 01:09PM

Re: Not enough memory to allocate insert buffer of size 1073741824

1377

Juan.Rene Ramirez Monarrez

August 22, 2014 10:11AM

Re: Not enough memory to allocate insert buffer of size 1073741824

898

Xin Li

August 25, 2014 02:58PM

Re: Not enough memory to allocate insert buffer of size 1073741824

944

Milosz Bodzek

September 02, 2014 10:17AM

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.