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 126.96.36.199 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?