Timeline for InnoDB: mmap failed; errno 12
Current License: CC BY-SA 4.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 5, 2018 at 14:23 | comment | added | MarCPlusPlus | Yea I think it is just because of the os allocator internals. Adding to the virtual address space with swap should help. | |
| Oct 5, 2018 at 14:17 | comment | added | digitizedx | With the following values, it is working, innodb_buffer_pool_size=100G innodb_buffer_pool_instances=16 innodb_buffer_pool_chunk_size=256M, if I increase innodb_buffer_pool_size above 100G with any combination of other values, it fails . I will try to add swap. | |
| Oct 5, 2018 at 11:24 | comment | added | MarCPlusPlus | Would you be able to add 32-64gb of swap to the server? Otherwise see if you can decrease the buffer pool by 10-20% and see if the allocation will go through. | |
| Oct 5, 2018 at 10:36 | comment | added | digitizedx | Tried. but still same. Earlier innodb_buffer_pool_chunk_size was 1G. I went back to default value. | |
| Oct 5, 2018 at 9:37 | history | answered | MarCPlusPlus | CC BY-SA 4.0 |