Details
-
Task
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
None
-
None
Description
For some reason mysqldump has by default max_allowed_packet 24MB.
If you have one field bigger than 24MB, then mysqldump will drop connection in the middle of packet and server will see "connection reset by peer" error.
User has basically no idea, what is causing this error.
24MB seems to be too small default value.
For example mysql client has default max_allowed_packet 1GB.
Yes, it is possible to increase this value from commandline parameter, but as there is no proper error message and user does not know what's the problem causing this error.
I suggest, we should increase mysqldump default value to 1GB, the same as mysql client.