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屋!