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

Implement --slave-abort-blocking-timeout

    XMLWordPrintable

Details

    Description

      Request from Monty, from a user:

      Implement an option --slave-abort-blocking-timeout. When this is set lower than --lock-wait-timeout and a slave replicating query (like an ALTER TABLE) is waiting for more that @@slave_abort_blocking_timeout blocked on a user query, then that query is killed to allow the slave to continue.

      This is intended to solve a problem, where there is a long-running SELECT for example running on a slave, and a DDL being replicated needs to wait for that SELECT to complete. Then until the SELECT completes, the replication will be completely blocked, potentially causing massive slave lag.

      Attachments

        Issue Links

          Activity

            People

              knielsen Kristian Nielsen
              knielsen Kristian Nielsen
              Votes:
              0 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 2d 3h 40m
                  2d 3h 40m

                  Git Integration

                    Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.