I am getting following error after modifying the innodb buffer pool size values.
InnoDB: mmap(137428992 bytes) failed; errno 12 InnoDB: Cannot allocate memory for the buffer pool
137428992 is innodb_buffer_pool_chunk_size.
I am having a machine with 256 GB RAM.
Following is what I added to my.cnf
All the other values are default. Resolution for similar questions are either increase RAM or decrease buffer pool size. If I monitor the memory usage when mysqld is starting, I see that it increases to 8-9 GB before the failure occurs.
Following is free -g output
total used free shared buff/cache available Mem: 251 2 247 0 1 248 Swap: 3 0 3
What could be causing this issue?
ulimitset? Is this running in a systemd service where someone has added a memory limit?