max_allowed_packet

2023-08-04 02:22:07  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
  • Session
  • 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.
    You can only view the session value. The session value must be the same as the global value.
    Generally, this variable must be adjusted both in the client and the server.

    Contact Us