MySQL测试环境遇到 mmap(xxx bytes) failed; errno 12解决方法

时间:2023-03-10 04:48:54
MySQL测试环境遇到 mmap(xxx bytes) failed; errno 12解决方法

查看Mysql日志

InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap( bytes) failed; errno
InnoDB: Completed initialization of buffer pool
InnoDB: Fatal error: cannot allocate memory for the buffer pool
[ERROR] Plugin 'InnoDB' init function returned error.
[ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
[ERROR] Unknown/unsupported storage engine: InnoDB
[ERROR] Aborting

缓存太少了

[root@dep5 ~]# free -m
total used free shared buffers cached
Mem:
-/+ buffers/cache:
Swap:

增加缓存

$  dd if=/dev/zero of=/swapfile bs=1M count= #增加1G的SWAP进去
$ mkswap /swapfile
$ swapon /swapfile
$ free
total used free shared buffers cached
Mem:
-/+ buffers/cache:
Swap:

此处不建议将swapon 写到/etc/fstab这里,直接写到/etc.rc.local中更为稳妥

启动解决...

出自:http://www.cnblogs.com/olinux/p/5144205.html