YOUR ARE VIEWING ARTICLE

MySql Max Allowed Packet value

MySql Max Allowed Packet value

If you are using a MySql database and receiving an error message like “packets larger than max_allowed_packet” you need to increase the MySql variable max_allowed_packet value from 1MB, which is the default value, to something bigger like 5MB.

Some instructions on changing this value can be found on the MySQL website here:

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

There are also some discussions on the subject here:

http://stackoverflow.com/questions/8062496/how-to-change-max-allowed-packet-size

This error happens because some images such as photos can be bigger than 1MB and MySQL is defined to only accept 1MB BLOB values by default.

TOPICS

CATEGORY

AUTHOR
Support Team

PUBLISHED
November 07, 2016

MODIFIED
April 27, 2022

US business only within scope

ISO/IEC 27001:2013 

United States

2010 Elkins Way, Suite 1122
Brentwood, CA 94513

Monday – Friday
9am – 5pm (EST)
+1 (925) 529 4999

Netherlands

Smallepad 32
3811 MG Amersfoort

Monday – Friday
9am – 5pm (CET)
+31 (0)20 2251 447

© 2023 CardExchange Solutions, Inc.