Mysql过程不会死

Question

我试图扼杀一个过程，但每次我这样做都会回来。这一过程如下：

我看过Mysql上的进程列表，什么都没有。

/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/server.weloveyou.err --pid-file=/var/lib/mysql/server.weloveyou.com.pid

我调查过这些日志，这种情况一直在发生：

130726 13:32:03 [Note] /usr/sbin/mysqld: Normal shutdown

130726 13:32:03 [Note] Event Scheduler: Purging the queue. 0 events
130726 13:32:03  InnoDB: Starting shutdown...
130726 13:32:05  InnoDB: Shutdown completed; log sequence number 0 2115443139
130726 13:32:05 [Note] /usr/sbin/mysqld: Shutdown complete

130726 13:32:05 mysqld_safe mysqld from pid file /var/lib/mysql/server.weloveyou.pid ended
130726 13:32:05 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130726 13:32:05 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
130726 13:32:05 [Note] Plugin 'FEDERATED' is disabled.
130726 13:32:05  InnoDB: Initializing buffer pool, size = 8.0M
130726 13:32:05  InnoDB: Completed initialization of buffer pool
130726 13:32:06  InnoDB: Started; log sequence number 0 2115443139
130726 13:32:06 [Note] Event Scheduler: Loaded 0 events
130726 13:32:06 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.70-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
130726 13:32:15 mysqld_safe Number of processes running now: 0
130726 13:32:15 mysqld_safe mysqld restarted
130726 13:32:15 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
130726 13:32:15 [Note] Plugin 'FEDERATED' is disabled.
130726 13:32:15  InnoDB: Initializing buffer pool, size = 8.0M
130726 13:32:15  InnoDB: Completed initialization of buffer pool
130726 13:32:15  InnoDB: Started; log sequence number 0 2115443139
130726 13:32:15 [Note] Event Scheduler: Loaded 0 events
130726 13:32:15 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.70-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL) 

有人有什么想法吗？

干杯

约翰

Answer 1

mysql服务器运行两个进程，mysqld和mysqld_safe。如果您使用SIGKILL信号(9)杀死mysqld，mysqld_safe将恢复mysqld。如果你以标准的方式停止mysqld，或者用sigint(15)信号杀死它，mysqld_safe就会注意到它并结束。如果有紧急情况，记得总是先杀死-9 mysqld_safe .

在这种情况下，mysqld_safe似乎是在关机后重新启动的。你到底是怎么杀死mysql的？