Bug #29519 KILL additions
Submitted: 3 Jul 2007 13:40
Reporter: Matthew Lord Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: General Severity:S4 (Feature request)
Version:5.1 OS:Any
Assigned to: CPU Architecture:Any
Tags: KILL

[3 Jul 2007 13:40] Matthew Lord
Right now, if you have a large number of connections (up to ALL) that you want
to kill you cannot do this easily.  You also cannot force a connection to close
as happens in the shutdown process.  This would allow you to keep database cache's
etc. in place while clearing out all connections.  This is most commonly needed
when a series of problematic queries are sent to the server which cannot be killed
and are making the server unresponsive.  Currently, the only way to solve this
in a reasonable time-frame is to restart mysqld.

How to repeat:

Suggested fix:
It would be nice to add the following commands:

KILL ALL; # set killed flag on all connections
KILL FORCE ALL; # force close of all connections