Increase MySQL Default Packet Size

JFrog Installation & Setup Documentation

Content Type
Installation & Setup
ft:sourceType
Paligo

Since some data files (like builds and configurations) are stored in MySQL, it is extremely important to increase the maximum allowed packet size used by MySQL to avoid errors related to large packets. For more information, refer to Packet Too Large in the MySQL documentation.

Modify /etc/my.cnf

If /etc/my.cnf does not exist, create the file under the absolute path and not under $JFROG_HOME.

# The MySQL server
[mysqld]
.
# The maximum size of the binary payload the server can handle
max_allowed_packet=8M
.

After modifying the maximum allowed packed size, you need to restart MySQL.

Use command line

You can also change the max_allowed_packet variable on the MySQL command line as in the following example:

SET GLOBAL max_allowed_packet = 134217728;

However, upon a restart, the value of the max_allowed_packet variable is read from the /etc/my.cnf file and reverts to the value in that file. Therefore, we recommend that you modify the value in the /etc/my.cnf file.