mysql - 启动错误InnoDB: mmap(137363456 bytes) failed; errno 12

【zsm】下午mysql出现了问题，很纠结，最后找到了原因，原因是内存不够用；

查看内存显示   [root@AY1305070924544 /]# free -m              total       used       free     shared    buffers     cached Mem:           995        928         66          0          6         19 -/+ buffers/cache:        903         91 Swap:            0          0          0 重启错误提示  [root@AY1305070924544 /]# /etc/init.d/mysqld start Starting MySQL. ERROR! The server quit without updating PID file (/var/mysql/data/AY1305070924544.pid). [root@AY1305070924544 /]# /etc/init.d/mysqld restart  ERROR! MySQL server PID file could not be found! Starting MySQL. ERROR! The server quit without updating PID file (/var/mysql/data/AY1305070924544.pid). 这个其实日志里面说的很明白就是 mysql要占用内存的时候 物理内存不够用导致的 所有 vim /etc/my.cnf [inonodb] innodb_buffer_pool_size=64MB  把这个数值改小 高版本的默认是128mb  版本的默认是8Mb

转载于:https://www.cnblogs.com/zsmynl/p/3602319.html