Got a packet bigger than 'max_allowed_packet' bytes

简介: 版权声明:本文为博主原创文章,未经博主允许不得转载。 https://blog.csdn.net/inforstack/article/details/79867678 两种方案临时修改mysql>set global max_allowed_packet=524288000;修改/etc/my.cnf修改mysql的最大允许包大小 ,然后重启mysql服务就可以了。
版权声明:本文为博主原创文章,未经博主允许不得转载。 https://blog.csdn.net/inforstack/article/details/79867678

两种方案

临时修改

mysql>set global max_allowed_packet=524288000;
AI 代码解读

修改/etc/my.cnf

修改mysql的最大允许包大小 ,然后重启mysql服务就可以了。

max_allowed_packet=50M 
AI 代码解读


目录
打赏
0
0
0
0
1
分享
相关文章
Packet for query is too large (4467936 > 4194304). You can change this value on the server by setting the max_allowed_packet' variable
【10月更文挑战第15天】解决Packet for query is too large (4467936 > 4194304). You can change this value on the server by setting the max_allowed_packet' variable
285 1
mysql:1153 Got a packet bigger than ‘max_allowed_packet’ bytes的解决方法
mysql:1153 Got a packet bigger than ‘max_allowed_packet’ bytes的解决方法
254 0
PHP Allowed memory size of 134217728 bytes exhausted (tried to allocate 10489856 bytes)
PHP Allowed memory size of 134217728 bytes exhausted (tried to allocate 10489856 bytes)
143 2
【异常】The field file exceeds its maximum permitted size of 1048576 bytes.
【异常】The field file exceeds its maximum permitted size of 1048576 bytes.
221 0
|
11月前
What value should kernel parameter AIO-MAX-NR be set to ?
What value should kernel parameter AIO-MAX-NR be set to ?
93 0
[ERR] 2006 - MySQL server has gone away,Got a packet bigger than 'max_allowed_packet' bytes
[ERR] 2006 - MySQL server has gone away,Got a packet bigger than 'max_allowed_packet' bytes
77 0
MySQL:Got a packet bigger than ‘max_allowed_packet‘ bytes
我们往MySQL导入数据的时候,当数据量过大的时候,就会报错,这是因为允许的最大数据超出了我们的默认设置,所以我们需要修改MySQL的默认设置
231 0
MySQL:Got a packet bigger than ‘max_allowed_packet‘ bytes
mysql数据库导入报错:Got a packet bigger than‘max_allowed_packet’bytes解决方案
mysql数据库导入报错:Got a packet bigger than‘max_allowed_packet’bytes解决方案
402 0
mysql数据库导入报错:Got a packet bigger than‘max_allowed_packet’bytes解决方案
AI助理

你好,我是AI助理

可以解答问题、推荐解决方案等