|
1887.3.2
by Brian Aker
Extended documentation. |
1 |
KILL
|
2 |
====
|
|
3 |
||
4 |
KILL [CONNECTION | QUERY] session_id |
|
5 |
||
6 |
Calling KILL will terminate a either a running query, or disconnect a |
|
7 |
connection, i.e. a session, from the database. |
|
|
1900.2.15
by Stewart Smith
flesh out the KILL documentation |
8 |
|
9 |
The way this works is that your connection sets a 'kill' flag in the session |
|
10 |
you want to kill. At various points in query execution, a session will |
|
11 |
check if the kill flag has been set, and if so, will quickly exit. So while |
|
12 |
the KILL command will not strictly immediately kill the session, it should |
|
13 |
appear to be fairly instantaneous. |
|
14 |
||
15 |
Some engines such as Innobase will also check for the kill flag |
|
16 |
during a lock wait, allowing you to kill a session waiting for a row lock. |