MySQL Forums
Forum List  »  Backup

Re: ERROR 2006 (HY000) MySQL server has gone away
Posted by: Rick James
Date: December 06, 2013 11:52PM

"When you change the message buffer size by changing the value of the max_allowed_packet variable, you should also change the buffer size on the client side if your client program permits it. The default max_allowed_packet value built in to the client library is 1GB, but individual client programs might override this. For example, mysql and mysqldump have defaults of 16MB and 24MB, respectively. They also enable you to change the client-side value by setting max_allowed_packet on the command line or in an option file.
"
-- http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_max_allowed_packet

Also...
http://forums.mysql.com/read.php?10,591684,591720
http://forums.mysql.com/read.php?35,521425,521859
http://dev.mysql.com/doc/refman/5.1/en/gone-away.html

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: ERROR 2006 (HY000) MySQL server has gone away
12931
December 06, 2013 11:52PM


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.