ERROR! MySQL (Percona Server) PID file could not be found!
Starting MySQL (Percona Server).... ERROR! The server quit without updating PID file (/usr/local/mysql/data/AY140223202734935acfZ.pid).
[root@AY140223202734935acfZ ~]# service mysql stop
ERROR! MySQL (Percona Server) PID file could not be found!
当操作mysql过程中,如出现上述MySQL (Percona Server) PID file could not be found!状况,很有肯能是进程卡死的现象,ps -ef | grep mysql 查看是否 有 “?”
[root@AY140223202734935acfZ ~]# ps -ef |grep mysql
root 26341 25946 0 17:00 pts/0 00:00:00 grep mysql
root 30904 1 0 Mar12 ? 00:00:00 /bin/sh /alidata/server/mysql/bin/mysqld_safe --datadir=/alidata/server/mysql/data --pid-file=/alidata/server/mysql/data/AY140223202734935acfZ.pid
mysql 31025 30904 0 Mar12 ? 00:00:16 /alidata/server/mysql/bin/mysqld --basedir=/alidata/server/mysql --datadir=/alidata/server/mysql/data --user=mysql --log-error=/alidata/log/mysql/error.log --pid-file=/alidata/server/mysql/data/AY140223202734935acfZ.pid --socket=/tmp/mysql.sock --port=3306
解决办法:
//杀掉坏死卡掉的进程
[root@AY140223202734935acfZ ~]# kill -9 30904
[root@AY140223202734935acfZ ~]# kill -9 31025
//停止mysql服务
[root@AY140223202734935acfZ ~]# ps -ef |grep mysql
root 26443 25946 0 17:02 pts/0 00:00:00 grep mysql
[root@AY140223202734935acfZ ~]# service mysql stop
Shutting down MySQL (Percona Server).. SUCCESS!
//启动mysql
[root@AY140223202734935acfZ ~]# service mysql start
Starting MySQL (Percona Server). SUCCESS!
转自 http://blog.csdn.net/reblue520/article/details/50525700