Is there a Recommended Size for max_allowed_packet
(Doc ID 2451058.1)
Last updated on FEBRUARY 27, 2020
Applies to:MySQL Server - Version 5.6 and later
Information in this document applies to any platform.
To understand the relationship of few of the packet sizing variables in MySQL and their use , eg for replication.
Depending on the application in use, there may be a requirement to set a specific size ( typically an up to N number ) for packet sizes.
This will allow the application to communicate with the server with packet sizes larger than the default:
|Default Value (>= 5.6.6)||
|Default Value (<= 5.6.5)||
|Default Value (>= 8.0.3)||
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document