Miscellany

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>