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

Editor to share with you mysql tips on how to do got timeout reading communication packets, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Error prompt:

User: 'root' host: `localhost' (Got timeout reading communication packets)

MYSQL server has gone away

The cause is not terrible. The reason is that the disconnection time of the system has been changed.

Mysql > show gloable variables like "timeout%"

To view

The threshold value of interactive_timeout is 28800

Default value of wait_timeout: 120

Increase according to the situation.

These two values are a global variable that can be increased dynamically, such as:

Mysql > set global interactive_timeout=28800

Query OK, 0 rows affected (0.00 sec)

Mysql > show global variables like "interactive_timeout"

+-+ +

| | Variable_name | Value |

+-+ +

| | interactive_timeout | 28800 | |

+-+ +

1 row in set (0.00 sec)

Causes that can cause Got timeout reading communication packets errors

Https://dev.mysql.com/doc/refman/5.5/en/communication-errors.html

There are several possible reasons for Got Timeout reading communication packets errors:

A client attempts to access a database but has no privileges for it. (no permission)

A client uses an incorrect password. (wrong password)

A connection packet does not contain the right information. (the connection does not contain the correct information)

It takes more than connect_timeout seconds to obtain a connect packet. (how long has it taken for connect_timeout to obtain connection information)

The client program did not call mysql_close () before exiting. (the client did not call the mysql_close () function)

The client had been sleeping more than wait_timeout or interactive_timeout seconds without issuing any requests to the server. (the empty connection time of the client is too long, exceeding the time of wait_timeout and interactive_timeout)

The client program ended abruptly in the middle of a data transfer. (end in the process of data transmission)

Error troubleshooting:

Because of the problem caused by the out of sync between our mobile version and the php function on PC, the problem will be solved by checking it carefully.

The above is all the contents of this article "mysql Tips what to do with got timeout reading communication packets". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.