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.
Subject
Views
Written By
Posted
3415
October 05, 2018 01:58AM
1014
October 05, 2018 09:40AM
Re: MySQL 8.0: InnoDB: mmap failed; errno 12
825
October 05, 2018 10:40AM
744
October 05, 2018 11:50AM
834
October 05, 2018 12:23PM
717
October 05, 2018 02:30PM
1154
October 05, 2018 08:57PM
883
October 05, 2018 10:05PM
624
October 06, 2018 08:42AM
796
October 06, 2018 10:46PM
838
October 07, 2018 02:10AM
865
October 07, 2018 12:02PM
Sorry, you can't reply to this topic. It has been closed.
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.