Can you please increase max allowed packet size for my server?

Avatar
canna
  • Answered
Right now it is
"MAX_ALLOWED_PACKET 5242880"

Can you please increase it to at least 16mb? 64mb or more would be nice, but i need at least 16mb to run my applications. Thanks!
Duplicates 1
Need to increase max_allowed_packet
I'm getting a "Error while sending QUERY packet" error while updating plugins for my wordpress site. I checked mysql and see that SHOW VARIABLES LIKE 'max_allowed_packet' is set to 5242880. I would like this increased to 16777216. I can't issue a SET GLOBAL max_allowed_packet in phpymadmin as I don't have permissions to do that. I've seen older posts here indicating that I can edit either ~/etc/my.cnf or ~/public_html/php.ini files to set 'max_allowed_packet=16777216;' but I do not have either of these files in my home directory.
The posts regarding this are pretty old (circa 2012), so it's most likely things have changed in the way user accounts have been set up.
Even if I were to change the php.ini , I would need to bounce at least the apache2 service (or whatever httpd server is being used) or if I did the mysql change, the mysqld. I wouldn't think that would be feasible as both the httpd and mysql services would be shared among all the users on the same inmotion server we're located on.

Could someone in support please increase max_allowed_packet to 16777216 for my account or give me a link to a current set of instructions and I can do it myself.
Thanks!
Replies 2
Avatar
0
Arn
Updated answer:

The provided error "Error while sending QUERY packet. PID=613708 in /home/......./public_html/wp-includes/wp-db.php on line 1811" suggests that your script exceeded the MySQL max_packet_size configuration limit. Unfortunately, this is not something that can be adjusted in a shared hosting environment as it would affect the entire server's MySQL configuration. You would require a VPS+ to modify this configuration or have a developer review your website code and reduce the size of the query being sent from your website to the MySQL server.
Avatar
0
jamesr
Thank you for your question canna! We checked your php.ini on line 160 and the max_allowed_packet = 32m. You can edit this by going to your php.ini in your public_html and changing the value. Please see the following link on this. How to update your local php settings The php.ini will need to be recursive to work in the subfolders. Please see the following link. How can I make my php.ini file recursive ? Also, the .htaccess has php_flag and php_value settings in there. These will be problematic on a SuPhp server because the directives are set in the php.ini not the .htaccess. You will want to comment these lines by adding a # in front of them on the line. If these changes do not fix your errors, we will need steps to replicate the problem. Regards James R