Saturday, November 21, 2020

(Drupal) How to change max_allowed_packet size


#

#  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