mysql错误，求mysql大神

Question

mysql经常遇到下面两个错误，哪位大神遇到过
Lost connection to MySQL server during query
Malformed packet

Answer 1

Set max_allowed_packet to 200M and try

Answer 2

I have also encountered the first one. My guesses are as follows:
1. The graphical tools such as navicat used will have strange problems, causing the connection to be lost;
2. It may be your sql execution Poor planning, resulting in too long time, being killed by the server, or by monitoring scripts, etc., or by the DBA.

Answer 3

It means that your garbage SQL statement is executed too slowly and is immediately abandoned due to timeout.