Details
-
New Feature
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
Sometimes a software is running a intensive batch of queries, and others connections start to become stalled / slow
Should be nice a
PAUSE CONNECTION <ID>
|
PAUSE CONNECTION QUERY <ID>
|
RESUME CONNECTION <ID>
|
RESUME CONNECTION QUERY <ID>
|
and a new status at information_schema.PROCESSLIST -> Connection paused
What it does is not stop current query, but hold connection to accept a new query, but don't start executing it, hold while it is not resumed, and keep the tcp connection open with the client (if possible sending heartbeat etc to don't disconnect), when it receive a RESUME CONNECTION it "unhold" the connection and accept queries again