ubuntu下处理mysql无法启动故障一例

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了ubuntu下处理mysql无法启动故障一例，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含2528字，纯文字阅读大概需要4分钟。

内容图文

  24 InnoDB: about forcing recovery.
  25 02:27:28 UTC - mysqld got signal 6 ;
  26 This could be because you hit a bug. It is also possible that this binary
  27 or one of the libraries it was linked against is corrupt, improperly built,
  28 or misconfigured. This error can also be caused by malfunctioning hardware.
  29 We will try our best to scrape up some info that will hopefully help
  30 diagnose the problem, but since we have already crashed,
  31 something is definitely wrong and this may fail.
  32
  33 key_buffer_size=16777216
  34 read_buffer_size=131072
  35 max_used_connections=0
  36 max_threads=151
  37 thread_count=0
  38 connection_count=0
  39 It is possible that mysqld could use up to
  40 key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 346079 K  bytes of memory
  41 Hope that‘s ok; if not, decrease some variables in the equation.
  42
  43 Thread pointer: 0x0
  44 Attempting backtrace. You can use the following information to find out
  45 where mysqld died. If you see no messages after this, something went
  46 terribly wrong...
  47 stack_bottom = 0 thread_stack 0x30000
  48 The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
  49 information that should help you find out what is causing the crash.

核实是INNODB出现故障导致。根据红色链接中的方法：

you can add the following line to the [mysqld] section of your option file before restarting the server:

[mysqld]
innodb_force_recovery = 4

将这个设置加入到/etc/mysql/my.cnf, 后start mysql服务恢复正常。

注释：

4 (SRV_FORCE_NO_IBUF_MERGE)

Prevent insert buffer merge operations. If they would cause a crash, do not do them. Do not calculate table statistics.

 

前期处理重新安装mysql的过程也记录下：

重新安装mysql

删除mysql：

apt-get autoremove --purge mysql-server

apt-get remove mysql-common

清理残留数据：

dpkg -l |grep ^rc|awk ‘{print $2}‘ |sudo xargs dpkg -P

最后再执行下 apt-get autoremove

安装 mysql：
apt-get install mysql-server-5.5
apt-get install mysql-client-5.5  //正常情况，此步已经包含在上步中，无需再安装。
apt-get install php5-mysql

安装完毕执行

#dpkg-reconfigure重新配置
dpkg-reconfigure mysql-server-5.5

#quick mysql package check
dpkg -l *mysql*

禁止mysql做域名解析
[mysqld]
skip-name-resolve

 

完毕！

ubuntu下处理mysql无法启动故障一例

标签：处理   nod   atomic   art   rem   mina   linux   nat   where   

本文系统来源：http://www.cnblogs.com/gordonchang/p/6681712.html

内容总结

以上是互联网集市为您收集整理的ubuntu下处理mysql无法启动故障一例全部内容，希望文章能够帮你解决ubuntu下处理mysql无法启动故障一例所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

---