These forums are locked and archived, but all topics have been migrated to the new forum. You can search for this topic on the new forum: Search for Increasing 'max_allowed_packet' on the new forum.
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
Anyone have knowledge on this ?
Thanks
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
Related post at http://www.virtualmin.com/node/13254
- - -
Senior Product Manager, and Co-Founder at Ubertus.org Inc.
Love back your Virtualmin & Webmin community
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".