当前位置：网站首页>Using MySQL in Ubuntu/Linux environment: Solve the problem of com.mysql.jdbc.PacketTooBigException: Packet for query is too large

Using MySQL in Ubuntu/Linux environment: Solve the problem of com.mysql.jdbc.PacketTooBigException: Packet for query is too large

2022-08-09 00:32:00 【Daughter controls fake full stack Lao Xu】

OS: Ubuntu 17.04 64-bit

MySQL version: MySQL 5.7

1. Questions

In the process of developing with MySQL, it is easy to encounter the following exceptions thrown by MySQL when saving large files:

Packet for query is too large

The reason for this error is because MySQL restricts data write operations, limiting the upper limit of the data size for a single write operation.

To solve this problem is very simple, just modify the configuration of MySQL.

2. Resolve

2.1 find the configuration file

The name of the configuration file we want to modify is as follows:

mysqld.cnf

If it is in a Windows environment, it is easy to find this file in the MySQL installation directory

My development environment is under Linux, and the location of the file is as follows:

/etc/mysql/mysql.conf.d/mysqld.cnf

2.2 Modify the configuration file

After locating the file, open it, and under the [mysqld] configuration item, find or add the following configuration items:

max_allowed_packet = 30M

The right side of the equation is the upper limit of the maximum written data, which can be modified according to your actual needs.The development environment can be appropriately larger, but the production environment should be controlled a little smaller.