【zsm】下午mysql出现了问题,很纠结,最后找到了原因,原因是内存不够用;
查看内存显示 [root@AY1305070924544 /]# free -m total used free shared buffers cachedMem: 995 928 66 0 6 19-/+ buffers/cache: 903 91Swap: 0 0 0重启错误提示 [root@AY1305070924544 /]# /etc/init.d/mysqld startStarting 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