Packet for query is too large(Packet>1048576)

原创 2016年08月31日 09:54:40

在保存数据到MySql服务器的时候,有时会发生该错误,解决方法:

1、SHOW VARIABLES LIKE '%max_allowed_packet%';

若没修改过的话,其值默认为1048576(1M),本人设置为10M,所以显示如下

2,打开MySql的配置文件(在其安装目录下的一个my.ini的文件);

打开找到max_allowed_packet参数,若有,修改大一点,若无加上该参数,然后赋值大一些,10M、20M都可以;


3,保存配置文件,重启MySql服务器。

搞定!



相关文章推荐

Packet for query is too large (xxxx > xxxx)

控制台错误提示:ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper -Packet for query is too large (1313 ...

com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1157 > 1024).

1. com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1157 > 1024). com.mysql.jdb...

sftp登录linux Received message too long (or "Bad packet length") 原因,已解决

sftp登录linux Received message too long (or "Bad packet length") 原因,已解决

Linux system log avahi-daemon[3640]: Invalid query packet.

Linux 系统运维

Zookeeper客户端错误:Packet len* is out of range!

这是一个生产环境使用zookeeper异常的情况,错误是java.io.IOException: Packet len8854970 is out of range!。...

iptables -- administration tool for IPv4 packet filtering and NAT

iptables -- administration tool for IPv4 packet filtering and NAT

A JIT for packet filters

A JIT for packet filters By Jonathan CorbetApril 12, 2011 The BerkeleyPacket Fil...
  • wzb56
  • wzb56
  • 2011年07月22日 15:26
  • 796

iptables - administration tools for packet filtering and NAT

2. iptables - administration tools for packet filtering and NAT Linux Iptables Manual ...

Oracle导数时报错:ORA-12899: value too large for column

原文链接:http://blog.csdn.net/shuiqingtinglin/article/details/7095787实际场景用Oracle自身支持的sqlldr语句导数据的时候,本来一直...

318240-byte external allocation too large for this process 问题

参考资料: http://stackoverflow.com/questions/4193917/external-allocation-too-large-for-this-process-in-a...
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:Packet for query is too large(Packet>1048576)
举报原因:
原因补充:

(最多只允许输入30个字)