转自:http://blog.csdn.net/zyk906705975/article/details/6664560
解决办法:MySQL的一个系统参数:max_allowed_packet,其默认值为1048576(1M),
查询:showVARIABLES like '%max_allowed_packet%';
修改此变量的值:
MySQL安装目录下的
my.ini文件中的[mysqld]段中的"max_allowed_packet = 1M",(可能有些文件会没有这一行的)
格式为:
[mysqld]
max_allowed_packet = 1M ( 将1M更改为4M(如果没有这行内容,增加一行)),
保存,
重起MySQL服务。
现在可以load大于1M的文件了
分享到:
相关推荐
博文链接:https://zyx19920203.iteye.com/blog/2301226
今天在往mysql中插入数据时遇到的问题,翻译过来的意思是:查询数据包太大 建议修改max_allowed_packet参数值。 针对我执行的插入操作来说,意味着一次性执行的sql语句太大,超过了mysql默认设置的值(我用的是...
主要介绍了MySQL Packet for query is too large 问题及解决方法,需要的朋友可以参考下
想改变这个问题,需要注意几点: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (2054817 > 1048576). You can change this value on the server by setting the max_allowed_packet’ ...
com.mysql.jdbc.PacketTooBigException: Packet for query is too large (4232009 > 4194304). You can change this value on the server by setting the max_allowed_packet’ variable. 出现上面的错误是因为...
MySQL批量插入问题 ...nested exception is com.mysql.jdbc.PacketTooBigException: Packet for query is too large (5677854 > 1048576). You can change this value on the server by setting the max_allowed_pac
mysql5.7 修改max_allowed_packet方法
glut packet for Dev C++. glut is a free packet for opengl application development.
当日志中出现了诸如:“Package for query is too large (xxxxxxxx > 4194304). You can change this value on the server by setting the max_allowed_package variable”的提示的时候,错误的本身就清楚的提示了...
18.2.3 Host '...' is blocked错误 18.2.4 Out of memory错误 18.2.5 Packet too large错误 18.2.6 The table is full错误 18.2.7 Commands out of sync in client错误 18.2.8 Ignoring ...
High Performance Packet Classification for Netfilter
# 7.1.5.1 名字的大小写敏感性 o 7.2 用户变量 o 7.3 列类型 + 7.3.1 列类型的存储要求 + 7.3.5 数字类型 + 7.3.6 日期和时间类型 # 7.3.6.1 问题和日期类型 # 7.3.6.2 DATETIME,DATE和TIMESTAMP类型 # 7.3...
Packet Tracer 7.2.1 for Windows 32 bit 模拟器,32位版本。
Cisco Packet Tracer is a powerful network simulator that can be utilized in training for CCNA TM and CCNP TM certification exam by allowing students to create networks with an almost unlimited number ...
代码如下:Lost connection to MySQL server at ‘reading initial communication packet’, system error: 0 很明显这是连接初始化阶段就丢失了连接的错误。 google半天大多是说的注释掉配置文件中 bind-address = ...
windows Packet32 包中的函数及数据说明,非常详细
6.8.1 Packet Tracer - Configure NAT for IPv4 Cisco Packet Tracer 思科模拟器 正确答案文件 可直接上交正确答案文件 本答案版权归mewhaku所有,严禁再次转载!!! Copyright @mewhaku 2022 All Rights ...
Algorithms for Packet Classication Pankaj Gupta and Nick McKeown Computer Systems Laboratory, Stanford University