Forums

Resolved
0 votes
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.
Sunday, December 05 2010, 09:57 AM
Share this post:
Responses (6)
  • Accepted Answer

    Monday, January 10 2011, 08:13 AM - #Permalink
    Resolved
    0 votes
    Thanks for the tip, Tim. I'm not an expert on this. I'll have to figure out what the 'client' means in this case. I suppose it's something like the php.ini files? Thanks anyway.
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, December 23 2010, 10:16 PM - #Permalink
    Resolved
    0 votes
    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?
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, December 23 2010, 09:17 PM - #Permalink
    Resolved
    0 votes
    Nope. I think I found all the .cnf files already, changed the max_ everywhere but nothing helps.
    Support of Clearfoundation doesnt know either.
    Funny.
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, December 23 2010, 11:52 AM - #Permalink
    Resolved
    0 votes
    /usr/share/system-mysql/etc/my.cnf?
    The reply is currently minimized Show
  • Accepted Answer

    Sunday, December 05 2010, 08:40 PM - #Permalink
    Resolved
    0 votes
    Thanks for the reply, Tim.
    Unfortunately that didn't help.


    :(
    The reply is currently minimized Show
  • Accepted Answer

    Sunday, December 05 2010, 08:28 PM - #Permalink
    Resolved
    0 votes
    Hi Harry, try /etc/my.cnf ?
    max_allowed_packet=16M

    service mysqld restart
    The reply is currently minimized Show
Your Reply