mysql> show full processlist;
 Id    | User        | Host       | db           | Command     | Time  | State                                                                 | Info                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
+-------+-------------+------------+--------------+-------------+-------+-----------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|     1 | system user |            |              | Daemon      |     0 | Waiting for event from ndbcluster                                     | NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | 
|    32 | replication | db2:53852  | NULL         | Binlog Dump | 72282 | Master has sent all binlog to slave; waiting for binlog to be updated | NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | 
|  6650 | jcamp       | localhost  | getplaylists | Query       | 58024 | Sending data                                                          | update medianet_track mt set mt.track_count_same = (select count(mt1.track_id) 
                                     from medianet_track1 mt1 where mt1.medianet_id = mt.medianet_id)                                                                                                                                                                                                                                                                                              | 
| 34665 | jcamp       | localhost  | getplaylists | Query       |     0 | NULL                                                                  | show full processlist                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 
| 34689 | jcamp       | web1:53009 | getplaylists | Sleep       |   893 |                                                                       | NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | 
| 35251 | jcamp       | localhost  | getplaylists | Killed      |  1101 | end                                                                   | update album_credit_update set descriptor_id = 621,artist_id = 277253,album_id = 671009 where id = 7467296                                                                                                                                                                                                                                                                                                                                                                         | 
| 36933 | jcamp       | localhost  | getplaylists | Query       |   193 | creating table                                                        | create temporary table medianet_track (
                                     track_id            int NOT NULL,
                                     medianet_id         int NOT NULL,
                                     recording_id        int,
                                     track_count         int NOT NULL default 0,
                                     track_count_same    int NOT NULL default 0,
                                     PRIMARY KEY (track_id)) | 
| 36934 | ldirector   | db2:47296  | ldirectordb  | Query       |   192 | Opening tables                                                        | select * from connectioncheck                                                                                                                                                                                                                                                                                                                                                                                                                                                      | 
| 36935 | jcamp       | localhost  | ldirectordb  | Query       |   151 | Opening tables                                                        | select count(*) from connectioncheck                                                                                                                                                                                                                                                                                                                                                                                                                                               | 
| 36936 | jcamp       | localhost  | getplaylists | Query       |    57 | checking permissions                                                  | show tables                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | 
| 36937 | jcamp       | localhost  | ldirectordb  | Query       |    31 | Opening tables                                                        | select count(*) from connectioncheck                                                                                                                                                                                                                                                                                                                                                                                                                                               | 
+-------+-------------+------------+--------------+-------------+-------+-----------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
11 rows in set (0.00 sec)