Increase innodb_buffer_pool_size prohibited
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 184.108.40.206 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?
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.