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

Improve DROP TABLE execution speed in Galera Cluster

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • None
    • Galera
    • None

    Description

      DROP TABLE is executed, by default, in Galera Cluster by Total Order replication (TOI) method. The TOI replication will hold total order commit monitor during the whole duration of DROP TABLE execution.
      This could be improved by ending the TOI state as soon as DROP TABLE execution releases MDL locks, and leaving the later time consuming file delete operations to happen in background.

      This approach requires that all operations happening after MDL lock releasing, must be successful. A potentially offending scenario would be if some other replicated (DML or DDL) statement or transaction would interfere with the DROP TABLE later stage file operations.

      Attachments

        Issue Links

          Activity

            People

              sciascid Daniele Sciascia
              seppo Seppo Jaakola
              Votes:
              0 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.