Increasing 'max_allowed_packet'

5 posts / 0 new
Last post
#1 Sun, 12/11/2011 - 06:50
Anonymous

Increasing 'max_allowed_packet'

Hi.

I am getting this error on one of my scripts:

Could not Insert to CB_MAIN (update)Got a packet bigger than 'max_allowed_packet' bytes

I guess that I need to increase the 'max_allowed_packet' byte value in MySQL

With VirtualMin there is the option to change "MySQL System Variables"

In there I find that 'max_allowed_packet' is set to : 1048576

What is a reasonable figure to increase it to ?

Also why ıs it 1048576 and not 1,000,000 ?

I am going to double the number up to 2,097,152 and see what happens !

Is there any other variable that should also be adjusted ?

Thanks

Tue, 12/13/2011 - 04:12
Davvit

Anyone have knowledge on this ?

Thanks

Tue, 12/13/2011 - 11:53
andreychek

Howdy,

I'm unfortunately not familiar with that setting -- however, there's a page over at mysql.com that describes the problem you're running into as well as the details of changing that parameter here:

http://dev.mysql.com/doc/refman/5.5/en/packet-too-large.html

Wed, 12/03/2014 - 00:09
Francewhoa
Francewhoa's picture

- - -
Senior Product Manager, and Co-Founder at Ubertus.org Inc.
Love back your Virtualmin & Webmin community

Sun, 06/17/2018 - 09:02
5qXsromGzky

You can edit the setting like this: Webmin > Servers > MySQL Database Server > MySQL Server Configuration,

Change the value in "Maximum packet size" box,

Click "Save and Restart My SQL".

Topic locked