Shulou(Shulou.com)06/01 Report--

When a sql file with more than 100g is imported, it will be broken automatically in more than an hour, and an error will be reported:

Mysql lost connection during query

It was found in the log that mysql had signs of restart, looked for Guantian cron and so on, but did not find any problems.

In the meantime, no one restarted the mysqld service manually.

Begin to suspect that some parameters are improperly set, such as max_allowded_packet or connectiong_timeout.

The parameter setting is too small, and the problem remains after adjustment. Finally, it is found that swap has been used up, but there is still a lot of memory left.

This shows that some parameters in the configuration file of mysql are improperly set and finally adjusted.

The parameter innodb_buffer_poll_size solves the problem

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.