- Mysql:Packet for query is too la
- Packet for query is too large
- elasticsearch.js search的限制
- linux下mysql innodb 新建表提示超出最大索引
- 【MYSQL】备份数据还原报错Got a packet bigg
- On Writing Well - Chapter 2
- Got a packet bigger than 'max_al
- MYSQL error: Got a packet bigger
- Python学习第七天——《A Byte of Python》笔
- Got a packet bigger than‘max_all
1.问题描述：Packet for query is too large (1354 > 1024). You can change this value on the server by setting the max_allowed_packet' variable
2.问题分析：MySql根据配置文件会限制Server接受的数据大小。增，改，查可能都会出现问。
3.解决方式：
首先查看当前配置情况
show VARIABLES like '%max_allowed_packet%';
image.png
一般默认是4M
两种解决方式：
1.(已验证)修改mysql\bin\my.ini:追加
max_allowed_packet =67108864，重启mysql
image.png
2.（验证不生效，也许自己操作有问题）
命令行：
set global max_allowed_packet = 524288000;或者
set global max_allowed_packet = 500*1024*1024;
image.png
网友评论