MySQL不停地自动重启的解决方法

MySQL不停地自动重启的解决方法不停地自动重启的解决方法

主要给大家介绍了关于MySQL不停地自动重启的解决方法，文中通过示例代码介绍的非常详细，对大家学习或者使用MySQL具有一定的参考学习价值，需

要的朋友们下面来一起学习学习吧

前言前言

近期，测试环境出现了一次MySQL数据库不断自动重启的问题，导致的原因是强行kill -9 杀掉数据库进程导致，报错信息如下：

2019-07-24T01:14:53.769512Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition

engine. You may use the startup option '--disable-partition-engine-check' to skip this check.

2019-07-24T01:14:53.769516Z 0 [Note] Beginning of list of non-natively partitioned tables

collection process might fail.

Please help us make Percona Server better by reporting any

bugs at http://bugs.percona.com/

key_buffer_size=33554432

read_buffer_size=8388608

max_used_connections=0

max_threads=501

thread_count=4

connection_count=0

It is possible that mysqld could use up to

stack_bottom = 7f4846172820 thread_stack 0x80000

/usr/local/mysql5.7/bin/mysqld(my_print_stacktrace+0x2c)[0xed481c]

/usr/local/mysql5.7/bin/mysqld(handle_fatal_signal+0x461)[0x7a15a1]

/lib64/libpthread.so.0(+0xf7e0)[0x7f498697c7e0]

/usr/local/mysql5.7/bin/mysqld(_ZN12ha_federated7rnd_posEPhS0_+0x2f)[0x12bcc3f]

/usr/local/mysql5.7/bin/mysqld(_ZN7handler10ha_rnd_posEPhS0_+0x172)[0x804a12]

/usr/local/mysql5.7/bin/mysqld(_ZN14Rows_log_event24do_index_scan_and_updateEPK14Relay_log_info+0x1e3)[0xe50e23]

/usr/local/mysql5.7/bin/mysqld(_ZN14Rows_log_event14do_apply_eventEPK14Relay_log_info+0x716)[0xe50196]

/usr/local/mysql5.7/bin/mysqld(_ZN9Log_event11apply_eventEP14Relay_log_info+0x6e)[0xe48fde]

/usr/local/mysql5.7/bin/mysqld(_Z26apply_event_and_update_posPP9Log_eventP3THDP14Relay_log_info+0x1f0)[0xe8d6f0]

Query (0): is an invalid pointer

Connection ID (thread ID): 2

Status: NOT_KILLED

You may download the Percona Server operations manual by visiting

http://www.percona.com/software/percona-server/. You may find information

in the manual which will help you identify the cause of the crash.

1. 初探过程初探过程

之前出现过类似的情况时，是因为内存不足，因日志中也有对应的提示：

key_buffer_size=33554432

read_buffer_size=8388608

Hope that's ok; if not, decrease some variables in the equation.

此测试环境物理内存确实不大，且剩余内存也不足，而且是作为另一个测试环境的从库，内存分配的也少。

之前一些环境也出现过类似的情况，通过调整参数及释放内存的等处理后可以正常启动，于是尝试着关闭一些临时程序并调整MySQL上述几个参数的值，如：

[mysqld]

max_connections = 50

然后重新启动MySQL，结果依旧不断重启。

初步处理未果。