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
    • 11.6
    • 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

        Activity

          People

            sciascid Daniele Sciascia
            seppo Seppo Jaakola
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.