InnoDB: mmap(686817280 bytes) failed; errno 12 问题记录

遇到的情况如下：

服务器配置比较差（1核1G 40G）已搭建了web 服务环境，后又安装了禅道 同时运行两个mysql服务 倒致内存不足。

web服务的mysql 服务出错，停止服务
出错信息如下：

2018-09-07 04:39:14 13993 [Note] Plugin 'FEDERATED' is disabled.
2018-09-07 04:39:14 13993 [Note] InnoDB: Using atomics to ref count buffer pool pages
2018-09-07 04:39:14 13993 [Note] InnoDB: The InnoDB memory heap is disabled
2018-09-07 04:39:14 13993 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-09-07 04:39:14 13993 [Note] InnoDB: Memory barrier is not used
2018-09-07 04:39:14 13993 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-09-07 04:39:14 13993 [Note] InnoDB: Using Linux native AIO
2018-09-07 04:39:14 13993 [Note] InnoDB: Using CPU crc32 instructions
2018-09-07 04:39:14 13993 [Note] InnoDB: Initializing buffer pool, size = 640.0M
InnoDB: mmap(686817280 bytes) failed; errno 12
2018-09-07 04:39:14 13993 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2018-09-07 04:39:14 13993 [ERROR] Plugin 'InnoDB' init function returned error.
2018-09-07 04:39:14 13993 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2018-09-07 04:39:14 13993 [ERROR] Unknown/unsupported storage engine: InnoDB
2018-09-07 04:39:14 13993 [ERROR] Aborting

 

 

查到网上的文件：

有以下文章：https://www.cnblogs.com/olinux/p/5144205.html
https://www.cnblogs.com/mingjian/p/5230387.html
https://www.cnblogs.com/janehoo/p/7725042.html
https://www.jb51.net/article/48625.htm
https://blog.csdn.net/shaochenshuo/article/details/53465016

可供参考解决问题