Linux中MySQL数据库max_allowed_packet的调整

最新推荐文章于 2025-02-17 08:33:06 发布

转载最新推荐文章于 2025-02-17 08:33:06 发布 · 81 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/xiandedanteng/p/4168854.html

文章标签：

#数据库 #操作系统

本文介绍了解决MySQL数据库中Blob字段上传文件过大导致的问题。通过调整服务器配置文件my.cnf中的max_allowed_packet参数，将文件上传大小限制从1MB增加到20MB，并重启MySQL服务来解决文件上传限制问题。

在MySQL数据库里某表有一个blob字段，当上传文件超过1M的时候出现下面的错误：

PreparedStatementCallback; SQL [insert into uos.docfile(remark,content,email,addtime,filename) values ('654645',?,'ufo@163.com',NOW(),'飞得更高-汪峰.mp3' )]; Packet for query is too large (6571400 > 1048576). 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 (6571400 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.

这个问题是如下解决的。

用VI打开/etc/my.cnf,增加下面加粗的一行,这句话是把上传文件大小改到20M：

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
max_allowed_packet = 20M
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
# symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid