Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-32263

Increase mysqldump default max_allowed_packet variable

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.11, 11.0, 11.1
    • 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.

      Attachments

        Activity

          People

            TheLinuxJedi Andrew Hutchings
            BB Silver Asu
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.