Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Mysql recovers the solution of automatic disconnection of oversized files

2025-04-04 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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

Recently used backup file for mysqdump recovery, due to large data, it will automatically disconnect in 2 hours, so try the following settings to solve the problem

?

set global max_allowed_packet=100 000 000; set global net_buffer_length=100000; SET GLOBAL interactive_timeout=28800 000; SET GLOBAL wait_timeout=28800000

Explanation of the above statement:

max_allowed_packet=XXX Maximum size of buffer for client/server communication;

-net_buffer_length=XXX TCP/IP and socket communication buffer size, creating lines up to net_buffer_length

-interactive_timeout = 10; valid for subsequent interactive links;

-wait_timeout is valid for the current interactive link;

The above statement mainly solves: connection timeout, imported sql file is too large.

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report