ubuntu下的mysql无法启动是怎么回事(详细情况看内容)
发布网友
发布时间：2022-04-09 19:01
共2个回答
懂视网
时间：2022-04-09 23:22
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
热心网友
时间：2022-04-09 20:30
