mysql进程无法停止 [英] mysql process cannot be stopped

问题描述

我最近在Ubuntu 12.04 OS桌面中安装了5.5.28-29.2 Percona服务器(GPL)29.2版.我试图使用其他方法停止服务器:

I have recently installed 5.5.28-29.2 Percona Server (GPL), Release 29.2 in a Ubuntu 12.04 OS Desktop. I have tried to stop the server using different methods:

- sudo /etc/init.d/mysql stop
- sudo kill -9 pid
- mysqladmin -u root -p shutdown

所有这些方法都会停止该过程，但是它死后会自动启动.我检查了syslog(/var/log/syslog/)，并始终向我显示下一条跟踪记录:

All this methods stop the process, however it starts up automatically after it dies. I have checked syslog (/var/log/syslog/) and always shows me the next trace:

Jan  4 17:50:44 kernel: [ 1915.494219] init: mysql main process (17311) killed by KILL signal
Jan  4 17:50:44 kernel: [ 1915.494245] init: mysql main process ended, respawning
Jan  4 17:50:44 kernel: [ 1915.500025] type=1400 audit(1357318244.557:48): apparmor="STATUS" operation="profile_replace" name="/usr/sbin/mysqld" pid=18458 comm="apparmor_parser"
Jan  4 17:50:46 /etc/mysql/debian-start[18501]: Upgrading MySQL tables if necessary.
Jan  4 17:50:46 /etc/mysql/debian-start[18504]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
Jan  4 17:50:46 /etc/mysql/debian-start[18504]: Looking for 'mysql' as: /usr/bin/mysql
Jan  4 17:50:46 /etc/mysql/debian-start[18504]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Jan  4 17:50:46 /etc/mysql/debian-start[18504]: This installation of MySQL is already upgraded to 5.5.28, use --force if you still need to run mysql_upgrade
Jan  4 17:50:46 /etc/mysql/debian-start[18515]: Checking for insecure root accounts.
Jan  4 17:50:46 /etc/mysql/debian-start[18520]: Triggering myisam-recover for all MyISAM tables

您知道该过程自动重新启动的原因吗? 预先谢谢你！

Do you know the reason why the process restarts automatically ? Thank you in advance!!

推荐答案

我遇到了完全相同的问题.运行kill命令将终止该进程，但就我而言，它将以其他进程ID再次弹出.

I was having this exact same problem. Running the kill command would kill the process, but in my case it would keep popping up again under a different process ID.

我能弄清楚如何永久阻止它的唯一方法是:

The only way I could figure out how to stop it for good was this:

sudo stop mysql

希望有帮助.

来源: http://www.itfromscratch.com /how-to-stop-the-percona-mysql-server/

这篇关于mysql进程无法停止的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！