#
# GL 2020-11-21 Increase max_allowed_packets to to prevent comms
# error from occurring when sending large queries
# to MySQL / MariaDB server
#
# Symptom:
# Communication link failure: 1153 Got a packet bigger than 'max_allowed_packets' bytes
#
# Discussion:
# https://mariadb.com/kb/en/server-system-variables/#max_allowed_packet
#
# Parameter:
# MariaDB [(none)]> show variables like 'max_allowed_packet';
#
# Resolution:
#
# https://stackoverflow.com/questions/8062496/how-to-change-max-allowed-packet-size
#
# Actions::
# A) Set parameter in /etc/my.cnf.d/server.cnf as follows
# [myssqld]
# max_allowed_packet=500M
#
# B) Restart MariaDB server
# # service mariadb restart
#
No comments:
Post a Comment