mysql> show full processlist;
+-------+-----------+--------------------------+-------------+----------------+-------+------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Id    | User      | Host                     | db          | Command        | Time  | State              | Info                                                                                            |
+-------+-----------+--------------------------+-------------+----------------+-------+------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 31889 | opt_write | munch4.ds.internal:45088 | opt_keyword | Query          | 17117 | Locked              | insert into opt_position_views
                (date, domain, keywords, popular, related, generic, search, exit)
                values
                ('2006-07-25','annauniversity.com','university','4','0','1','0','0') |
| 32889 | opt_write | localhost                | opt_keyword | Sleep          |    28 |              | NULL                                                                                            |
| 32931 | opt_write | yoyo.ds.internal:35631   | opt_keyword | Execute        | 17117 | Copying to tmp table on disk | SELECT domain, keywords, sum(search), sum(popular), sum(exit),
           sum(generic), sum(related)
    FROM opt_position_views
    GROUP BY domain, keywords                      |
| 33102 | opt_write | yoyo.ds.internal:35637   | opt_keyword | Prepare        | 10117 | Locked              | SELECT domain, keywords, sum(search), sum(popular), sum(exit),
           sum(generic), sum(related)
    FROM opt_position_views
    GROUP BY domain, keywords                      |
| 33183 | opt_write | yoyo.ds.internal:35639   | opt_keyword | Prepare        |  7005 | Locked              | SELECT domain, keywords, sum(search), sum(popular), sum(exit),
           sum(generic), sum(related)
    FROM opt_position_views
    GROUP BY domain, keywords LIMIT 100            |
| 33243 | opt_write | yoyo.ds.internal:35642   | opt_keyword | Prepare        |  4361 | Locked              | SELECT domain, keywords, sum(search), sum(popular), sum(exit),
           sum(generic), sum(related)
    FROM opt_position_views
    GROUP BY domain, keywords LIMIT 500            |
| 33307 | opt_write | yoyo.ds.internal:35645   | opt_keyword | Sleep          |   346 |              | NULL                                                                                            |
| 33308 | opt_write | yoyo.ds.internal:35646   | opt_keyword | Prepare        |  2301 | Locked              | SELECT domain, keywords, sum(search), sum(popular), sum(exit),
           sum(generic), sum(related)
    FROM opt_position_views
    GROUP BY domain, keywords                      |
| 33377 | kgale     | 10.1.2.19:34479          | opt_keyword | Query          |   737 | Locked              | show table status like 'opt\_position\_views'                                                                                            |
| 33380 | kgale     | 10.1.2.19:34481          | opt_keyword | Query          |   534 | Locked              | show table status like 'opt\_position\_views'                                                                                            |
| 33390 | opt_write | yoyo.ds.internal:35647   | opt_keyword | Sleep          |     2 |              | NULL                                                                                            |
| 33391 | DELAYED   |                          | opt_keyword | Delayed insert |     2 | Waiting for INSERT           |                                                                                            |
| 33393 | kgale     | 10.1.2.19:34592          | opt_keyword | Sleep          |   291 |              | NULL                                                                                            |
| 33397 | root      | localhost                | NULL        | Query          |     0 | NULL              | show full processlist                                                                                            |
+-------+-----------+--------------------------+-------------+----------------+-------+------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
14 rows in set (0.00 sec)