Shulou(Shulou.com)05/31 Report--

The main content of this article is to explain "what is the reason for the error of MySQL server has gone away". Interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Next, let the editor take you to learn "what is the reason for the error of MySQL server has gone away?"

[current investigation]

The error message of 2006 MySQL server has gone away generally occurs in the following situations for your reference:

The 1.MySQL process failed.

two。 The connection expires when it reaches the wait timeout value, but a sql is still sent

3.SQL text is too large, larger than max_allowed_packet

It is recommended that the 4.SQL be terminated unexpectedly. The application side should set up the application reconnection mechanism. When a timeout disconnection occurs, the reconnection can be done. If there is a long SQL in the business, you can adjust the max_allowed_packet parameters appropriately to avoid SQL execution failure. You can see how many timeout parameters are set and compare the settings of business connection pooling. You can also take a look at the time point of the problem and the specific request SQL text initiated to see if there is a relatively large SQL. The network does not time out, and the customer does not set the time out.

At this point, I believe you have a deeper understanding of "what is the reason for the error of MySQL server has gone away?" you might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

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.