Settings max_allowed_packet MySQL

mySQL

This is just a little note on settings the max allowed packet in mysql without rebooting it.  I always forget how to do it when I neet to change it quickly for something.

set global max_allowed_packet = 32 * 1024 * 1024;

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

Search

Jeff   Roberson