MySQL Forums
Forum List  »  InnoDB

Re: MySQL 8.0: InnoDB: mmap failed; errno 12
Posted by: Sujith S
Date: October 05, 2018 10:40AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL 8.0: InnoDB: mmap failed; errno 12
18
October 05, 2018 10:40AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.