Re: MySQL 8.0: InnoDB: mmap failed; errno 12
Posted by:
Sujith S
Date: October 06, 2018 10:46PM
my.cnf
[mysqld]
#innodb_buffer_pool_size=100G
#innodb_buffer_pool_instances=16
#innodb_buffer_pool_chunk_size=256M
innodb_dedicated_server = ON
log_error_verbosity=3
datadir=/home/test/mysql
socket=/home/test/mysql/mysql.sock
log-error=/home/test/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[client]
socket=/home/test/mysql/mysql.sock
free -m
total used free shared buff/cache available
Mem: 257417 2103 254891 10 422 254402
Swap: 4095 0 4095
Meanwhile I checked the code a bit. I think failure happens at
storage/innobase/os/os0proc.cc:150
ptr = mmap(NULL, size, PROT_READ | PROT_WRITE, MAP_PRIVATE | OS_MAP_ANON, -1,
0);
if (UNIV_UNLIKELY(ptr == (void *)-1)) {
ib::error(ER_IB_MSG_856) << "mmap(" << size
<< " bytes) failed;"
" errno "
<< errno;
ptr = NULL;
}
I wrote a test program with same code, which will mmap 1GB chunks. That always fails at around 130 GB. mysqld also fails around that range. This problem could be related to the OS too. But I am not sure what it is.
Subject
Views
Written By
Posted
4237
October 05, 2018 01:58AM
1220
October 05, 2018 09:40AM
1016
October 05, 2018 10:40AM
895
October 05, 2018 11:50AM
1032
October 05, 2018 12:23PM
870
October 05, 2018 02:30PM
1473
October 05, 2018 08:57PM
1064
October 05, 2018 10:05PM
764
October 06, 2018 08:42AM
Re: MySQL 8.0: InnoDB: mmap failed; errno 12
969
October 06, 2018 10:46PM
1017
October 07, 2018 02:10AM
1040
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.