MySQL崩溃解决办法

最新推荐文章于 2022-08-31 16:31:52 发布

用户昵称不能为空

最新推荐文章于 2022-08-31 16:31:52 发布

阅读量7.3k

点赞数 1

分类专栏： MySQL笔记文章标签： mysql 奔溃

本文链接：https://blog.csdn.net/default7/article/details/86478284

版权

当尝试访问特定表时，MySQL出现崩溃。通过日志分析，发现该表为复制自一个分区表并添加了新字段，这导致了崩溃。解决方法包括删除表，重新复制不带分区的版本，然后安全地添加字段。

摘要由CSDN通过智能技术生成

重现方法

执行 select * from test，MySQL自动奔溃关闭，访问其他的表没有问题，单独这个表绝对会这样。

报错日志

07:30:01 UTC - mysqld got exception 0xc0000005 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
Attempting to collect some information that could help diagnose the problem.
As this is a crash and something is definitely wrong, the information
collection process might fail.

key_buffer_size=8388608
read_buffer_size=8192
max_used_connections=2
max_threads=151
thread_count=1
connection_count=1
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 49892 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread point