mysql几天挂一次 InnoDB: Fatal error: cannot allocate memory for the buffer pool

jasonstar

mysql几天挂一次，不知道什么原因磁盘没满。mysql err日志已上传  麻烦军哥帮忙看下
170921 12:40:07 InnoDB: Initializing buffer pool, size = 512.0M
InnoDB: mmap(549453824 bytes) failed; errno 12
170921 12:40:07 InnoDB: Completed initialization of buffer pool
170921 12:40:07 InnoDB: Fatal error: cannot allocate memory for the buffer pool
170921 12:40:07 [ERROR] Plugin 'InnoDB' init function returned error.
170921 12:40:07 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
170921 12:40:07 [ERROR] Unknown/unsupported storage engine: InnoDB
170921 12:40:07 [ERROR] Aborting

licess

170921 12:40:07 InnoDB: Initializing buffer pool, size = 512.0M
InnoDB: mmap(549453824 bytes) failed; errno 12
170921 12:40:07 InnoDB: Completed initialization of buffer pool
170921 12:40:07 InnoDB: Fatal error: cannot allocate memory for the buffer pool
170921 12:40:07 [ERROR] Plugin 'InnoDB' init function returned error.
170921 12:40:07 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
170921 12:40:07 [ERROR] Unknown/unsupported storage engine: InnoDB
170921 12:40:07 [ERROR] Aborting
按提示是无法分配内存，也就是内存不够用了，可能你其他程序占用较多
可以先调整/etc/my.conf 中 innodb_buffer_pool_size 调小些再观察看看，如果vps/服务器上没swap的话，再添加上个swap试试

jasonstar

已经改小 ， 然后几个小时就挂了！！！只有mysql崩溃，内存是够用的啊
最新日志见附件！


[ 本帖最后由 jasonstar 于 2017-10-14 22:54 编辑 ]

jasonstar

https://bbs.vpser.net/thread-16630-1-1.html
我跟这个人的错误日志看起来是一样的 好奇怪啊。


我的my.cnf 也上传了 见附件
我的lnmp版本是1.3

[ 本帖最后由 jasonstar 于 2017-10-14 23:04 编辑 ]

licess

你这不是崩溃时的内存占用情况没法说明崩溃时内存时够用的