mysql> show processlist; +----+-------+-----------+---------+---------+------+-------+----------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-------+-----------+---------+---------+------+-------+----------------------------------------------+ | 3 | sguil | localhost | sguildb | Killed | 1787 | NULL | SELECT MAX(timestamp) FROM event WHERE sid=3 | | 5 | sguil | localhost | sguildb | Query | 1201 | NULL | ANALYZE TABLE `data` | | 7 | root | localhost | NULL | Query | 0 | NULL | show processlist | +----+-------+-----------+---------+---------+------+-------+----------------------------------------------+ 3 rows in set (0.00 sec) mysql> KILL 3; Query OK, 0 rows affected (0.00 sec) mysql> KILL 5; Query OK, 0 rows affected (0.00 sec) mysql> show processlist; +----+-------+-----------+---------+---------+------+-------+----------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-------+-----------+---------+---------+------+-------+----------------------------------------------+ | 3 | sguil | localhost | sguildb | Killed | 1803 | NULL | SELECT MAX(timestamp) FROM event WHERE sid=3 | | 5 | sguil | localhost | sguildb | Killed | 1217 | NULL | ANALYZE TABLE `data` | | 7 | root | localhost | NULL | Query | 0 | NULL | show processlist | +----+-------+-----------+---------+---------+------+-------+----------------------------------------------+ 3 rows in set (0.00 sec) mysql>