怎么处理mysqld dead but subsys lockedITeye - 千亿集团

怎么处理mysqld dead but subsys lockedITeye

2019年04月04日10时23分27秒 | 作者: 姿诺 | 标签: 处理,办法,装置 | 浏览: 761

mysql dead but subsys lockedrnmysqld 已死,但是 subsys 被锁rnrn我是先用rpm 装置了mysql,然后又编译装置了一个mysql 后来我把他们都删了,又用rpm 装置,但是仍是不可rnrnrn网上找的两种办法都试过了,仍是不可,rnrn办法一rn处理办法如下rnshell service mysqld stop rnshell rm -fr /var/lib/mysql/* rnshell rm /var/lock/subsys/mysqld rnshell killall mysqld rnshell service mysqld start rn rn意义如下: rn1. 中止MYSQL效劳 rn2. 删去/var/lib/mysql/下的一切文件,我想这些文件可能是MYSQL5.1留下来的. rn3. 删去确定文件 rn4. 杀死一切mysqld进程 rn5. 发动MYSQL效劳 rnrn办法二rnrn1. Obviously the ole check the log file for anything nastyrnrncat /var/log/mysqld.logrnrn2. Stop the servicernrnservice mysqld stoprnrn3. Check to see if the service stopped, it might be calling the wrong pid.rnrnps aux | grep mysqlrnrn4. Kill any mysql process that might still be running.rnrnkill -9 ??? ???rnrn5. (*CAREFUL*) Remove/move/backup any databases from the data directory, only do this step if you need to.rnrnrm -Rf /var/lib/mysql/*rnrn6. Check your global options configuration file, should be similar to stevanbts initial post.rnrncat /etc/my.cnfrnrn7. Copy over one of the preconfigured sample server-specific options file. Global (/etc/my.cnf) file has priority over server-specific file, but these have more options in them and have been tuned for a certain role.rnrncp /usr/share/doc/mysql-server-?.??.??/my-small.cnf /var/lib/mysqlrnrn8. Recreate the initial databases, this step is optional as the initscripts will do this anyway.rnrnmysql_install_dbrnrn9. Check and set the runlevels for the service.rnrnchkconfig level 345 mysqld onrnchkconfig list mysqldrnrn10. Start the service.rnrnservice mysqld startrnrn11. Check the log file (step 1)rnrnThats just a basic step through check, most of you have probably already done this.rnrn其实做到step 9问题都已经处理了。rnrnrnrnrnrn

版权声明
本文来源于网络,版权归原作者所有,其内容与观点不代表千亿集团立场。转载文章仅为传播更有价值的信息,如采编人员采编有误或者版权原因,请与我们联系,我们核实后立即修改或删除。

猜您喜欢的文章

阅读排行

  • 1

    exceptionITeye

    成果,形似,有点
  • 2
  • 3

    mysql的count函数优化ITeye

    索引,优化,情况
  • 4
  • 5

    DB2锁机制ITeye

    机制,程序,数据
  • 6

    oracle功能优化总结ITeye

    索引,视图,优化
  • 7

    oracle存储进程ITeye

    存储,进程,数据
  • 8

    Oracle中rownum、rowid、rowITeye

    相同,记载,排名
  • 9
  • 10