max_allowed_packet

2025-12-04 09:32:54  Updated

max_allowed_packet specifies the maximum size in bytes of a network packet.

Attribute Description
Type int
Default value 4194304
Value range [1024, 1073741824]
Applicable scope Global
Involved in serialization? Yes
Modifiable? You can use the SET GLOBAL statement to modify the global value of the variable. However, you cannot use the SET SESSION statement to modify a session value of the variable.
Generally, this variable must be adjusted both in the client and the server.

Contact Us