max_allowed_packet is used to specify the maximum packet size, in bytes, allowed during a single packet transmission between SQLEngine and a client. If a packet sent by a client exceeds the value of max_allowed_packet, SQLEngine rejects the packet.max_allowed_packet parameter, consider the following factors:max_allowed_packet to improve the system's concurrent processing capability. When resources are constrained, you need to decrease the value of max_allowed_packet to avoid resource exhaustion.max_allowed_packet to meet concurrent demands. For applications that require smaller packet sizes, you can decrease the value of max_allowed_packet to conserve system resources.max_allowed_packet to improve concurrent processing capability. For databases with poorer performance, you need to decrease the value of max_allowed_packet to avoid overloading the database.Required | Description |
Parameter Type | ULONG |
Default Value | 67108864 |
Value Range | 1024 ~ 1073741824 Note: The value of this variable should be an integer multiple of 1024. If the value is not divisible by 1024, a warning will be issued and the value will be rounded down. For example, if set to 1025, the actual value used in TDSQL Boundless will be 1024. |
Effective Scope | GLOBAL SESSION |
Restart Required | No |
フィードバック