max_allowed_packet sets the maximum packet size allowed during data transmission between the SQLEngine and clients, measured in bytes. When a client sends a packet exceeding the value of max_allowed_packet, the SQLEngine will reject the packet.max_allowed_packet parameter, you need to consider the following factors:max_allowed_packet can be appropriately increased to improve the system's concurrent processing capacity. In the case of resource shortage, the value of max_allowed_packet needs to be reduced to avoid resource exhaustion.max_allowed_packet may need to be increased to meet concurrency requirements. For applications with low requirements for data packet size, the value of max_allowed_packet can be reduced to save system resources.max_allowed_packet may need to be increased to improve their concurrency processing capability. For databases with poor performance, the value of max_allowed_packet needs to be reduced to avoid database overload.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 |
Esta página foi útil?
Você também pode entrar em contato com a Equipe de vendas ou Enviar um tíquete em caso de ajuda.
comentários