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

Add option for SQL thread to limit maximum execution time per query replicated

Details

    Description

      Currently execution time for the replicated query is not limited in any clear way. On primary node we can use max_statement_time, but this value is neither passed to slave nor enforced for SQL thread when it's set locally. So, there is no way to "control" replication delay and just stop with error when it's too big already.

      I think option to stop with error after specific timeout (that may be different than local max_statement_time or primary's max_statement_time) would be useful for replication setups.

      Attachments

        Activity

          Transition Time In Source Status Execution Times
          Brandon Nesterenko made transition -
          Open In Progress
          206d 13h 23m 1
          Brandon Nesterenko made transition -
          In Progress In Review
          7d 20h 52m 1
          Andrei Elkin made transition -
          In Review Stalled
          28d 22h 11m 1
          Andrei Elkin made transition -
          Stalled Closed
          35s 1

          People

            bnestere Brandon Nesterenko
            valerii Valerii Kravchuk
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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