解决Mysql You can change this value on the server by setting the max_allowed_packet' variable. 异常
来源:互联网 发布:通达信日线数据 编辑:程序博客网 时间:2024/05/24 06:17
场景:
项目需要导入excel数据,2200行。
报错信息:
Mysql You can change this value on the server by setting the max_allowed_packet' variable.
Packet for query is too large (6832997 > 4194304). You can change this value on the server by setting the max_allowed_packet' variable.
解释:
用于查询的数据包太大(6832997> 4194304)。 您可以通过设置max_allowed_packet的变量来更改服务器上的这个值。通过解释可以看到用于操作的包太大。这里要插入的excel表大小为1.3M 所以报错。
解决方法:
服务上的数据库是mysql。然后查了一下资料是MySQL的一个系统参数问题:
max_allowed_packet,其默认值为1048576(1M),
查询:show VARIABLES like '%max_allowed_packet%';
修改此变量的值:MySQL安装目录下的my.ini文件中的[mysqld]段中的
"max_allowed_packet = 1M",如更改为4M(或更大,如果没有这行内容,增加一行),
保存,重起MySQL服务。现在可以load大于1M的文件了。
阅读全文
0 0
- 解决Mysql You can change this value on the server by setting the max_allowed_packet' variable. 异常
- MYSQL 异常 You can change this value on the server by setting the max_allowed_packet' variable
- Mysql You can change this value on the server by setting the max_allowed_packet' variable. 异常
- packet for query is too large <1781> 1024 >. you can change this value on the server by setting the
- Packet for query is too large (1029 > 1024). You can change this value on the server by setting the
- Packet for query is too large (1032 > 1024). You can change this value on the server by setting the
- mysql Packet for query is too large (5058927 > 4194304). You can change this value on the server by
- Packet for query is too large (1986748 > 1048576). You can change this value on the server by
- mysql5中大数据错误:Packet for query is too large (***>***). You can change this value on the ser
- mysql5中大数据错误:Packet for query is too large (1117260 > 1048576). You can change this value on the ser
- linux异常系列:Can't connect to X11 window server using ':0.0' as the value of the DISPLAY variable.
- mysql:Variable 'character_set_client' can't be set to the value of 'NULL'解决
- mysql The server time zone value 异常
- mysql The server time zone value 异常
- Can't connect to X11 window server using ':0.0' as the value of the DISPLAY variable.
- Can't connect to X11 window server using ':0.0' as the value of the DISPLAY variable.
- when the preview menu is diabled in BO, you can add this setting to enabled it
- This check can be disabled by setting the system property org.apache.el.parser.SKIP_IDENTIFIER_CHEC
- C++得到函数执行所用时间
- Ruby基础学习(一)
- 编写Qt Designer自定义控件(一)——如何创建并使用Qt自定义控件
- 在陌生Linux环境查看Tomcat服务的方法
- k8s--dns插件部署
- 解决Mysql You can change this value on the server by setting the max_allowed_packet' variable. 异常
- 14、Python 3.x 之操作 MySQL
- 斐波那契数列
- Java自学必备的视频教学之面向对象
- spring-依赖注入的实现方式
- 习题7.1
- shadow的socks5服务器搭建
- LeetCode.724 Find Pivot Index
- 别人分析的mips架构的linux启动第一步(作为对比)