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

query timeout, executing kill only if we got a lock contention

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • OTHER
    • None

    Description

      now with query timeouts being implemented
      we could allow a timeout checking if any other connection have a lock contention with the current query

      at a high level (show processlist) we can know if a thread is blocking or not other query checking the tables being used (maybe mdl?) but sometimes with innodb it's difficult to find since we have row level locks

      the idea is create a method to check others process when the current query is timed out, if no other connection have a lock contention don't allow the kill command, if we found a lock contention allow the kill command and kill the current query

      in others words when thread receive a kill_timeout, we check if we could return false/true and update the process information with (killing or timedout)

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              rspadim roberto spadim
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.