max_allowed_packet specifies the maximum size in bytes of a network packet.
| Property | Description |
|---|---|
| Parameter type | Int |
| Default value | 4194304 |
| Value range | [1024,1073741824] |
| Effective scope | * GLOBAL * SESSION |
| Involved in serialization | Yes |
Note
This variable can only be modified by using a SET GLOBAL xxx = yyy statement which takes effect globally, but cannot be enabled to take effect only in the current session by using an ALTER SESSION SET xxx = yyy; statement. Generally, this variable must be adjusted both in the client and the server.