Got a packet bigger than ‘max_allowed_packet’ bytes

A single SQL statement submitted to the MySQL server constitutes a communication packet. One gigabyte is the maximum packet size that can be delivered to a MySQL server. The MySQL server displays the error shown below when it gets a packet larger than the maximum amount permitted.

MySQL said: Documentation
#1153 – Got a packet bigger than ‘max_allowed_packet’ bytes

At times you might loose connectivity with mysql server if the packet is too large. Both client & server has a threshold of max packet size, so if you want to handle big packets, you must increase the variable limits on the server.

Open the file below on your server. You cannot increase the limits on shared hosting OR reseller hosting plans.

# vi /etc/my.cnf

The limit can be raised to suit your needs. We will set it to 16MB right now. Here are the items you must include in the MySQL configuration file.

max_allowed_packet=16M

Save the file & exit. Restart mysql.
You can check the increased limit with command.

# mysqladmin variables | grep max_allowed_packet

You can configure custom mysql variables as required with our VPS hosting & dedicated server plans.