1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
SELECT COUNT(ID) FROM DATA_DICTIONARY.PROCESSLIST ORDER BY ID; COUNT(ID) 6 SELECT IF(KILL(id), "YES", "NO") FROM DATA_DICTIONARY.PROCESSLIST WHERE ID != CONNECTION_ID(); IF(KILL(id), "YES", "NO") YES YES YES YES YES SELECT count(ID) FROM DATA_DICTIONARY.PROCESSLIST WHERE COMMAND != "Killed"; count(ID) 1 SELECT KILL(CONNECTION_ID()); ERROR HY000: You cannot kill the session you are connected from. |