Search This Blog

Thursday, November 22, 2018

Both the client and the server of MySQL have their own max_allowed_packet variable

The largest possible packet that can be transmitted to or from a MySQL 5.7 server or client is 1GB.


When a MySQL client or the mysqld server receives a packet bigger than max_allowed_packet bytes, it issues an ER_NET_PACKET_TOO_LARGE error and closes the connection. With some clients, you may also get a Lost connection to MySQL server during query error if the communication packet is too large.

Both the client and the server have their own max_allowed_packet variable, so if you want to handle big packets, you must increase this variable both in the client and in the server.

You can also use an option file to set max_allowed_packet. For example, to set the size for the server to 16MB, add the following lines in an option file:


[mysqld]
max_allowed_packet=16M