Questions? Feedback? powered by Olark live chat software
Knowledgebase
Author Avatar

Got a packet bigger than ‘max_allowed_packet’ bytes

Written by: on 27 May 2016 04:22 PM 27 May 2016 04:22 PM

Receiving 'Got a packet bigger than max_allowed_packet bytes' error? Follow our instructions to fix such issues.

If you receive an error from your MySQL server (or website with mySQL backend) stating 'Got a packet bigger than "max_allowed_packet" bytes' then you need to increase your MySQL settings to accommodate the request.

You can do this live without any downtime.

1. Login to SSH

2. Once logged in type:

mysql

set global net_buffer_length=1000000;

set global max_allowed_packet=1000000000;

(2 vote(s))
Helpful
Not helpful