数据库文件过大异常及解决方案

oppoppoppo

于 2017-02-22 10:30:11 发布

阅读量1.1k

点赞数

分类专栏： mysql

本文链接：https://blog.csdn.net/oppoppoppo/article/details/56480271

版权

mysql 专栏收录该内容

2 篇文章

订阅专栏

### Cause: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (10485836 > 4194304). You can change this value on the server by setting the max_allowed_packet' variable.
; SQL []; Packet for query is too large (10485836 > 4194304). You can change this value on the server by setting the max_allowed_packet' variable.; nested exception is com.mysql.jdbc.PacketTooBigException: Packet for query is too large (10485836 > 4194304). You can change this value on the server by setting the max_allowed_packet' variable.

修正方案

MySQL的一个系统参数：max_allowed_packet，其默认值为1048576(1M)，
查询：show VARIABLES like '%max_allowed_packet%';

100M

set global max_allowed_packet = 100*1024*1024