| Command-Line Format |
--max-allowed-packet=# |
| System Variable |
Name |
Max_allowed_packet |
| Scope |
Global, session |
| Dynamic |
Yes |
| Permitted Values (<= 5.6.5) |
Type |
Integer |
| Default |
1048576 |
| Minimum |
1024 |
| Maximum |
1073741824 |
| Permitted Values (>= 5.6.6) |
Type |
Integer |
| Default |
4194304 |
| Minimum |
1024 |
| Maximum |
1073741824 |
Parameter explanation: 1:the default is 4MB, the protocol limit to Max_allowed_packet is 1GB. The new version defaults to 4MB and the current maximum is 1GB.
2: The session-level parameter is read-only, and the client accepts the maximum session-level amount of data, and the server does not send more data than the current global parameter.
3:the global value could will less than the session value if the ' global value is ' changed after the client connects conversation variable can be greater than the full The local variables only occur after the global modification occurs after the client connection.
4: Packet buffering is set by parameter net_buffer_length, but can be scaled to max-allowed-packet size as needed.
If the size is not appropriate, you can modify the Max-allowed-packet:
Set global max-allowed-packet=10000000; global level or set session max-allowed-packet=10000000; Session-level modifications take effect immediately.
