Uploaded image for project: 'Percona XtraBackup'
  1. Percona XtraBackup
  2. PXB-684

LP #1277403: Use FLUSH TABLES before FTWRL

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None

      Description

      **Reported in Launchpad by Alexey Kopytov last update 21-05-2015 17:49:57

      Similar to mysqldump, XtraBackup can potentially lower the impact from FTWRL if an extra FLUSH TABLES is executed before executing FLUSH TABLES WITH READ LOCK. That is, first wait for all currently executing queries to complete without placing a global read lock (and thus, without blocking new queries). Then try to acquire the global read lock.

      There is of course always a chance that another long-running query is started in between. If so, we are in the same situation as we were without the extra FLUSH TABLES. Otherwise we get less downtime due to FTWRL.

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              lpjirasync lpjirasync (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: