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

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

    Details

    • Type: Task
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: OTHER
    • Labels:
      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

              • Assignee:
                Unassigned
                Reporter:
                rspadim roberto spadim
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated: