|
1963.2.1
by Brian Aker
Fixing up the kill function. |
1 |
# Test creating a bunch of connections, and then killing them. |
2 |
connect (con1,localhost,root,,); |
|
3 |
connect (con2,localhost,root,,); |
|
4 |
connect (con3,localhost,root,,); |
|
5 |
connect (con4,localhost,root,,); |
|
6 |
connect (con5,localhost,root,,); |
|
7 |
||
8 |
connection default; |
|
9 |
SELECT COUNT(ID) FROM DATA_DICTIONARY.PROCESSLIST ORDER BY ID; |
|
10 |
SELECT IF(KILL(id), "YES", "NO") FROM DATA_DICTIONARY.PROCESSLIST WHERE ID != CONNECTION_ID(); |
|
11 |
SELECT count(ID) FROM DATA_DICTIONARY.PROCESSLIST WHERE COMMAND != "Killed"; |
|
12 |
--error 1713
|
|
13 |
SELECT KILL(CONNECTION_ID()); |