mysql 启动时找不到PID 进程坏死的问题

[root@AY140223202734935acfZ ~]#  service mysql restart
 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