MySQL: Problem: Err 1153 - Got a packet bigger than max_allowed_packet bytes

原创已于 2025-06-11 12:11:56 修改 · 1.1k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#MySQL #problem #Err 1153 #command #max_allowed_packet

于 2019-02-19 08:42:02 首次发布

Command 同时被 3 个专栏收录

87 篇文章

订阅专栏

MySQL

36 篇文章

订阅专栏

Problem

17 篇文章

订阅专栏

本文详细介绍了如何解决MySQL中出现的'Err]1153-Gotapacketbiggerthan‘max_allowed_packet’bytes'错误。通过调整'max_allowed_packet'参数的大小，可以有效避免因数据包过大导致的连接问题。

Problem

MySQL: [Err] 1153 - Got a packet bigger than ‘max_allowed_packet’ bytes [Err] /*

Solution

mysql> show VARIABLES like '%max_allowed_packet%';
+--------------------------+------------+
| Variable_name            | Value      |
+--------------------------+------------+
| max_allowed_packet       | 1048576    |
| slave_max_allowed_packet | 1073741824 |
+--------------------------+------------+
2 rows in set (0.00 sec)

mysql> set global max_allowed_packet = 4194304;
Query OK, 0 rows affected (0.00 sec)

mysql> exit
mysql> show VARIABLES like '%max_allowed_packet%';
+--------------------------+------------+
| Variable_name            | Value      |
+--------------------------+------------+
| max_allowed_packet       | 4194304    |
| slave_max_allowed_packet | 1073741824 |
+--------------------------+------------+
2 rows in set (0.00 sec)