• Dear Pleskians! The Plesk Forum will be undergoing scheduled maintenance on Monday, 7th of July, at 9:00 AM UTC. The expected maintenance window is 2 hours.
    Thank you in advance for your patience and understanding on the matter.

how to increase max_allowed_packet?

Sven L.

Regular Pleskian
Hi,

migrating some stuff from 9.5.4 to 11.5 and i get an warning in the migration manager about max_allowed_packet

i have tried to find some information how to increase this limit (seems like it's at 1M and i would like it to be 2-4M) but everything points me to old folders that no longer seem to be relevant.

how can i achieve this in plesk 11.5?
 
Just add

Code:
max_allowed_packet=4M

in your /etc/my.cnf (in [mysqld] section) and then do:

service mysqld restart
(or whatever you need to do to restart MySQL in your Linux flavour)
 
does this change survive through updates or will I have to do that everytime?

Plesk doesn't touch MySQL settings so you are safe there.

Indeed, as a rule of thumb, it doesn't touch any configuration file in /etc/ unless it is necessary in order to achieve what you ask it to do (e.g. /etc/named/* when you add/edit a domain, and similarly with apache).

The design methodology of Plesk is to decouple it as much as possible from OS, so that updates to Plesk have a minimal impact on your system's settings. Of course there are some big changes during installation - just not during updates. (by updates I mean MU installation not full version upgrades, which sometimes have to make bigger changes)
 
Back
Top