MySQL Forums
Forum List  »  InnoDB

MySQL 8.0: InnoDB: mmap failed; errno 12
Posted by: Sujith S
Date: October 05, 2018 01:58AM

Hi,
I am Getting following error after modifying the innodb buffer pool size values.

2018-10-05T07:35:47.023697Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.12) MySQL Community Server - GPL.
2018-10-05T07:36:43.909180Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.12) starting as process 127616
2018-10-05T07:36:52.962993Z 0 [ERROR] [MY-012681] [InnoDB] InnoDB: mmap(137428992 bytes) failed; errno 12
2018-10-05T07:36:52.967840Z 0 [ERROR] [MY-012681] [InnoDB] InnoDB: mmap(137428992 bytes) failed; errno 12
2018-10-05T07:36:52.969252Z 0 [ERROR] [MY-012681] [InnoDB] InnoDB: mmap(137428992 bytes) failed; errno 12
2018-10-05T07:36:52.969845Z 0 [ERROR] [MY-012681] [InnoDB] InnoDB: mmap(137428992 bytes) failed; errno 12
2018-10-05T07:36:53.038190Z 0 [ERROR] [MY-012681] [InnoDB] InnoDB: mmap(137428992 bytes) failed; errno 12
2018-10-05T07:36:53.071308Z 0 [ERROR] [MY-012681] [InnoDB] InnoDB: mmap(137428992 bytes) failed; errno 12
2018-10-05T07:36:53.071978Z 0 [ERROR] [MY-012681] [InnoDB] InnoDB: mmap(137428992 bytes) failed; errno 12
2018-10-05T07:36:53.154088Z 0 [ERROR] [MY-012681] [InnoDB] InnoDB: mmap(137428992 bytes) failed; errno 12
2018-10-05T07:36:55.085538Z 1 [ERROR] [MY-012956] [InnoDB] InnoDB: Cannot allocate memory for the buffer pool
2018-10-05T07:36:55.085639Z 1 [ERROR] [MY-012930] [InnoDB] InnoDB: Plugin initialization aborted with error Generic error.
2018-10-05T07:36:55.085715Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2018-10-05T07:36:55.086358Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2018-10-05T07:36:55.086439Z 0 [ERROR] [MY-010119] [Server] Aborting
2018-10-05T07:36:55.088807Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.12) MySQL Community Server - GPL.

137428992 is innodb_buffer_pool_chunk_size.

This started after following was added to my.cnf

innodb_buffer_pool_size=200G
innodb_buffer_pool_instances=40

Machine is having 256 GB RAM.


All the other values are default. mysql is started via systemctl. ulimit is unlimited.

What could be causing this?

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL 8.0: InnoDB: mmap failed; errno 12
74
October 05, 2018 01:58AM


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.