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

Documentation: Possibly incorrect behavior of mysqldump --master-data?

    XMLWordPrintable

Details

    Description

      I believe that in mariadb 5.3 mysqldump was improved to use the consistent transaction vs. binlog position instead of FLUSH TABLES WITH READ LOCK.

      But I'm not sure that the KB documentation for mysqldump has been updated
      In the first paragraph of the --master-data description on https://mariadb.com/kb/en/mariadb/documentation/clients-and-utilities/backup-restore-and-import/mysqldump/, it says: "This option will turn --lock-all-tables on, unless --single-transaction is specified too (on servers before MariaDB 5.3 this will take a global read lock for a short time at the beginning of the dump; don't forget to read about --single-transaction below)."

      This is not super clear but can be interpreted as consistent with the 5.3 improvement.

      But a later paragraph says "The --master-data option automatically turns off --lock-tables. It also turns on --lock-all-tables, unless --single-transaction also is specified, in which case, a global read lock is acquired only for a short time at the beginning of the dump (see the description for --single-transaction)."

      My reading of that is that FLUSH TABLES WITH READ LOCK would be used if you use --single-transaction and --master-data together - and I thought this was the problem that was fixed by the improvement in 5.3 so a global read lock is no longer needed.

      Is this correct?

      NB. `man mysqldump` for 10.0 has the same content as the KB - and that sentence is the same as in mysql 5.5.

      Attachments

        Activity

          People

            greenman Ian Gilfillan
            will.bryant Will Bryant
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.