This is just short post on settings the max_allowed_packet in MySQL without rebooting it. I always forget how to do it when I need to change it quickly for whatever reason.

set global max_allowed_packet = 32 * 1024 * 1024;

This will set it for 32 MEGS. Change the 32 to have it larger or smaller.

Since this resets when the service restarts below is a link to the command line and my.cnf configuration information.

MySQL max_allowed_packet

Related Posts | mysql |