Note
This variable was introduced in OceanBase Database V3.2.3.
Description
max_allowed_packet specifies the maximum size of a network packet.
Attributes
Attribute |
Description |
|---|---|
| Type | Integer |
| Default value | 16777216, in bytes
NoteThe default value has been changed from |
| Value range | [1024, 1073741824] |
| Effective scope | GLOBAL |
| Modifiable | Yes. You can use the SET GLOBAL statement to modify the variable. |
Considerations
You can use the
SET GLOBALstatement to modify the global value of the variable. However, you cannot use theSET SESSIONstatement to modify a session value of the variable.This variable must be modified on both the client and the OBServer node. If the values on the client and the OBServer node are inconsistent, the following error is returned:
ERROR 1153 (08S01): Got a packet bigger than \'max_allowed_packet\' bytes".
Example
obclient> SET GLOBAL max_allowed_packet=4194304;