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

Allow write operations to an InnoDB tablespace that is locked with "FLUSH TABLES ... FOR EXPORT"

    XMLWordPrintable

Details

    Description

      Currently, FLUSH TABLES ... FOR EXPORT takes a read lock on a table, and this prevents any INSERT, UPDATE, or DELETE operations from affecting the table until the lock has been released with UNLOCK TABLES.

      Some users would like to allow INSERT, UPDATE, or DELETE operations to affect a table during the export process. Would it be possible to implement this? Perhaps it could be implemented using the same kind of log used to track changes during a table rebuild with ALTER TABLE ... ALGORITHM=INPLACE? i.e. the log referred to by the innodb_online_alter_log_max_size system variable:

      https://mariadb.com/kb/en/library/innodb-system-variables/#innodb_online_alter_log_max_size

      Attachments

        Issue Links

          Activity

            People

              ralf.gebhardt Ralf Gebhardt
              GeoffMontee Geoff Montee (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              4 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.