Re: MySQL 8.0: InnoDB: mmap failed; errno 12

[Sujith S]

I am assuming that following is the rule that is being referred "Buffer pool size must always be equal to or a multiple of innodb_buffer_pool_chunk_size * innodb_buffer_pool_instances"

initial configuration I tried was
innodb_buffer_pool_size=200G
innodb_buffer_pool_instances=40
innodb_buffer_pool_chunk_size=1G

Then I tried
innodb_buffer_pool_size=192G
innodb_buffer_pool_instances=32
innodb_buffer_pool_chunk_size=1G


Both failed. Are these not following this rule(192 is a multiple of 32) or am I missing something really bad here. :(

But with following config it is working,
innodb_buffer_pool_size=100G
innodb_buffer_pool_instances=16
innodb_buffer_pool_chunk_size=256M

But anything above 100GB is failing.