内存不够用,启动不了MySQL

来源:互联网 发布:如何投诉淘宝店铺 编辑:程序博客网 时间:2022/10/05 08:09

今天重启测试环境的MySQL,总是报错:

 

[root@XXXX etc]# /etc/init.d/mysql restart
MySQL manager or server PID file could not be found![FAILED]
Starting MySQL.Manager of pid-file quit without updating file.[FAILED]
[root@XXXX etc]#

 

检查了一下log,发现错误:

100910  1:43:04 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use GCC atomic builtins
InnoDB: mmap(2195718144 bytes) failed; errno 12
InnoDB: Fatal error: cannot allocate the memory for the buffer pool
100910  1:43:04 [ERROR] Plugin 'InnoDB' init function returned error.
100910  1:43:04 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
100910  1:43:04 [ERROR] Unknown/unsupported table type: INNODB
100910  1:43:04 [ERROR] Aborting

 

再看看当前的内存使用情况:

[root@XXXX logs]# free -m
             total       used       free     shared    buffers     cached
Mem:          2011       1960         50          0        150        192
-/+ buffers/cache:       1617        394
Swap:         2015       2014          1
[root@XXXX logs]#

把“innodb_buffer_pool_size”改小,重启就可以了。

原创粉丝点击