Packet for query is too large
来源:互联网 发布:零境网络 官网 编辑:程序博客网 时间:2024/04/29 22:27
(mysql)Packet for query is too large
- |
- 浏览:582
- |
- 更新:2015-04-22 10:46
- 1
- 2
- 3
- 4
- 5
- 6
- 7
com.mysql.jdbc.PacketTooBigException: Packet for query is too large (11087 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2655)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1604)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3249)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1268)
方法/步骤
项目刚开始运行时是正常的,可以正常访问,可是运行了一段时间就报错
查询下设置最大值
SHOW VARIABLES LIKE '%max_allowed_packet%';
用过mysql的,应该都知道,那么怎么修改呢,找到mysql的安装目录
打开my.ini,文件
查找max_allowed_packet,有的文件没有,没有的话增加
[mysqld]
max_allowed_packet = 20M
然后重启,mysql,运行程序,可以正常添加数据,问题就解决啦
END
- MYSQL Packet for query is too large
- Packet for query is too large
- MYSQL Packet for query is too large
- Packet for query is too large
- Packet for query is too large
- Packet for query is too large
- Packet for query is too large
- Packet for query is too large
- MySQL Packet for query is too large
- Packet for query is too large
- Packet for query is too large
- 【解决】Packet for query is too large
- Packet for query is too large
- Packet for query is too large
- Packet for query is too large (mysql)
- PacketTooBigException: Packet for query is too large
- Packet for query is too large(Packet>1048576)
- Packet for query is too large(mysql写入数据过大)
- nyoj47 过河问题
- mysql异常Packet for query is too large(mysql写入数据过大)
- ACM ? ACM !
- 排序算法进阶(一)——快速排序算法
- 广度搜索的应用实例
- Packet for query is too large
- slf4j 简介
- ubuntu 14.04系统下安装 VMware Tools 方法
- POJ 2096 多系统找n种bug需要的天数期望--期望dp
- HDU1664 Different Digits(bfs +数论剪枝)
- Oracle 树操作(select…start with…connect by…prior)
- Harry Potter and the Forbidden Forest(割边最小的最小割)
- HDU - 4293 Groups (DP)
- Scala学习回顾(七)---- 抽象类、抽象字段、抽象方法