Increase max_allowed_packet Size

max_allowed_packetis a MySQL variable. If you wanto to increase max_allowed_packet, you can use the SQL statement below.

First step is to check the current size of max_allowed_packet:

SHOW VARIABLES LIKE 'max_allowed_packet';

Next step is to set max_allowed_packet – in this case to 16MB:

SET GLOBAL max_allowed_packet=16777216;

Now, max_allowed_packet has been changed.

Leave a Comment