Category: MySQL

When you change Max_Allowed_Packet_Size using the command line or an admin tool, sometimes it does not work.

The best way to do this is to edit the my.cnf file. Under the mysqld section, add the following line:

[mysqld
max_allowed_packet=16MB

Normally it is good to set the value to around 16mb. It is only set to 1mb by default.

Restart mySQL after you have edited the file:

On Linux:

/etc/rc.d/init.d/mysqld restart

On Windows:

Use services to restart

 

Tags:

mySQL

How useful was this post?

Click on a star to rate it!

Average rating / 5. Vote count: