Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
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
- relates to
-
MDEV-4427 query timeouts
- Closed