I've tried to adjust the max_allow_packet variable in MYSQLD but the startup is controlled by the mysqld_safe file in /bin/sh. So now I'm looking for a safe way to increase that max_allowed_packet size form 1M to 16 or 32M.
Please advise.
Please advise.
In Database
Share this post:
Responses (6)
-
Accepted Answer
-
Accepted Answer
Hi Harry, have you seen this page?
http://dev.mysql.com/doc/refman/5.5/en/packet-too-large.html
It appears that the max packet size has to be set at both the client and the server to be effective
For the above config files - did you add it to the [mysqld] or the [mysqld-safe] section? and then restart the service? -
Accepted Answer
-
Accepted Answer
-
Accepted Answer
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here.
Register Here »