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

mariadb-dump --net-buffer-length

    XMLWordPrintable

Details

    Description

      This week I learned that --net-buffer-length can help to reduce the size of a line/statement in the dump. This was important to solve an issue with Galera Cluster with too long rows for a schema restore throttling the whole cluster...

      Checking the docu: https://mariadb.com/kb/en/mariadb-dumpmysqldump/

      "The initial size of the buffer for client/server communication. When creating multiple-row INSERT statements (as with the --extended-insert or --opt option), mysqldump creates rows up to net_buffer_length length. If you increase this variable, you should also ensure that the net_buffer_length variable in the MariaDB server is at least this large."

      It is IMHO not too obvious. Something like "net-buffer-length can limit the size of a row in the dump" would make it more clear.

      Attachments

        Activity

          People

            greenman Ian Gilfillan
            oli Oli Sennhauser
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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