max_allowed_packet MariaDB on Synology

SSH into the Synology Server.

Open the file:  

/volume1/@appstore/MariaDB10/usr/local/mariadb10/etc/my.cnf

#some versions may be found here:
/volume1/var/packages/MariaDB10/etc

Edit the lines:

[mysqld]
max_allowed_packet = 1M

and

[mysqldump]
max_allowed_packet = 1M

with the # bytes or M that you desire. Be sure to update the variable max_allowed_packet under both the[mysqld] and [mysqldump] sections in order to increase the size for both the database IO and the backup IO. Otherwise backup, recovery, and day-to-day IO operations won’t align.

Save changes and restart the MariaDB service OR reboot the Synology:

/usr/syno/bin/synopkg restart MariaDB

---

Related Forum and KB Articles:

https://dev.mysql.com/doc/refman/8.0/en/packet-too-large.html

https://stackoverflow.com/questions/8062496/how-to-change-max-allowed-packet-size

https://docs.oracle.com/cd/E19182-01/820-6323/gicxk/index.html

https://mariadb.com/docs/reference/mdb/system-variables/max_allowed_packet/