MySQL Forums
Forum List  »  Newbie

Re: max_allowed_Packet automatically reset to 1M
Posted by: Rick James
Date: May 05, 2016 09:42PM

What is the value of net_buffer_length?

Perhaps: http://bugs.mysql.com/bug.php?id=59959

----- 2011-05-05 5.5.12 -- Bugs Fixed -- -----

The server permitted max_allowed_packet ( http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_max_allowed_packet ) to be set lower than net_buffer_length ( http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_net_buffer_length ), which does not make sense because max_allowed_packet ( http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_max_allowed_packet ) is the upper limit on net_buffer_length ( http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_net_buffer_length ) values. Now a warning occurs and the value remains unchanged. (Bug #59959, Bug #11766769)

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.