Increase MariaDB 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 MariaDB, it is extremely important to increase the maximum allowed packet size used by MariaDB to avoid errors related to large packets. For more information, refer to Packet Too Large in the MariaDB 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 MariaDB server
[MariaDBd]
.
# 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 MariaDB.

Use Command Line

You can also change the max_allowed_packet variable on the MariaDB 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.