Increase innodb_buffer_pool_size prohibited

Posted on September 22, 2014

Hi There,

Ive been trying desperately to have my innodb_buffer_pool_size increased from the current 2G to 10G. And all the while I have been receiving the following…

140922  9:33:48 InnoDB: The InnoDB memory heap is disabled
140922  9:33:48 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140922  9:33:48 InnoDB: Compressed tables use zlib 1.2.3.4
140922  9:33:48 InnoDB: Initializing buffer pool, size = 3.0G
InnoDB: mmap(3263692800 bytes) failed; errno 12
140922  9:33:48 InnoDB: Completed initialization of buffer pool
140922  9:33:48 InnoDB: Fatal error: cannot allocate memory for the buffer pool
140922  9:33:48 [ERROR] Plugin 'InnoDB' init function returned error.
140922  9:33:48 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140922  9:33:48 [ERROR] Unknown/unsupported storage engine: InnoDB
140922  9:33:48 [ERROR] Aborting

I have 16G of memory and want to enable optimal use of my memory for our high transaction, Saas platform. Could you advise at your earliest?

Thanks

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

leighweston

September 22, 2014

Hi there,

The output of Top is typically …

Tasks: 111 total, 1 running, 110 sleeping, 0 stopped, 0 zombie Cpu(s): 0.0%us, 0.0%sy, 0.0%ni, 99.9%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Mem: 16563068k total, 811032k used, 15752036k free, 98660k buffers Swap: 8388604k total, 0k used, 8388604k free, 404040k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
6669 mysql 20 0 2420m 205m 7264 S 0 1.3 1:12.93 mysqld
11585 root 20 0 0 0 0 S 0 0.0 0:00.02 kworker/1:0
1 root 20 0 3540 1896 1288 S 0 0.0 0:01.37 init
2 root 20 0 0 0 0 S 0 0.0 0:00.01 kthreadd

Our installation didnt have swap which ive enabled(8Gigs) but i still cannot increase the innodb buffer to beyond 2G. Is there something else we need doing?

Read the link but amok nor top point to anything conclusive. was hoping you could let me know if there are any kernel parameters set by DO that we may need to check/undo?

Would really appreciate feedback.

Thanks