Got a packet bigger than 'max_allowed_packet' bytes
0.mysql根据配置文件中max_allowed_packet的值限制server接受的数据包大小
1.查看max_allowed_packet
show VARIABLES like '%max_allowed_packet%';
以上说明目前的配置是：1M
2.修改配置
2.1临时修改
set global max_allowed_packet=134217728;
set global max_allowed_packet=134217728;
修改为 #128M
注:需重新mysql后查看
2.2永久修改
my.cnf中max_allowed_packet = 128M，重启mysql
导入Mysql报错，如下：Got a packet bigger than 'max_allowed_packet...
0.mysql根据配置文件中max_allowed_packet的值限制server接受的数据包大小 1.查看ma...
mysql:1153 Got a packet bigger than ‘max_allowed_packet’ ...
数据导入报错：Got a packet bigger than‘max_allowed_packet’bytes的...
MySQL导入数据报Got a packet bigger than‘max_allowed_packet’byt...
数据库启动 servicemysqld start mysql:1153 Got a packet bigger ...
问题1：MySQL Error 1153 - Got a packet bigger than'max_allow...
[ERROR] console - Error: ER_NET_PACKET_TOO_LARGE: Got a p...
问题描述： Err [Imp] 1153 - Got a packet bigger than 'max_allo...
今天用SQLYog执行数据插入命令，一共3万多条记录吧，导入数据库时提示： Error Code:1153 Got...
本文标题：mysql 写入报错： Got a packet bigger
本文链接：https://www.haomeiwen.com/subject/dtejkttx.html
网友评论