Mysql启动失败：InnoDB: mmap(137428992 bytes) failed； errno 12

hi_1900

已于 2022-09-24 11:23:24 修改

阅读量484

点赞数

文章标签：服务器 mysql 数据库

于 2022-09-24 11:21:28 首次发布

本文链接：https://blog.csdn.net/Zinnir/article/details/127022981

版权

博客讲述了在Linux服务器上遇到MySQL启动失败的问题，错误日志显示因内存不足导致InnoDB初始化失败。通过`free`指令发现服务器缺少Swap分区。为解决此问题，博主创建了一个1G的Swap分区，并成功启动了MySQL服务。

摘要由CSDN通过智能技术生成

[root@iZwz98m7yqiqoatk3bc39fZ ~]# systemctl start mysqld
Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.

linux服务器上Mysql启动报错，找了很多资料，查看Mysql日志如下：

[root@iZwz98m7yqiqoatk3bc39fZ ~]# tail -200f /var/log/mysqld.log
2022-03-25T18:15:52.462587Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12
2022-03-25T18:15:52.462593Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2022-03-25T18:15:52.462599Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2022-03-25T18:15:52.462608Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-03-25T18:15:52.462613Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-03-25T18:15:52.462618Z 0 [ERROR] Failed to initialize builtin pl