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

Add option for SQL thread to kill any blocking DML

Details

    • New Feature
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 12.1
    • Replication
    • None

    Description

      DML executed on primary may be blocked by any long running DML that takes write locks, like SELECT FOR UPDATE or SELECT IN SHARE MODE, on the replica, thus breaking the "high availability" of this setup.

      Please, add a server variable to force priority for SQL thread in such cases,, similar to --slave-abort-blocking-timeout.

      Attachments

        Issue Links

          Activity

            People

              knielsen Kristian Nielsen
              monty Michael Widenius
              Votes:
              1 Vote for this issue
              Watchers:
              8 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.