rendered paste bodymysql> 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)