mysql> show full processlist; +------+------------+----------------+-----------+---------+------+------------- ---------+---------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- --------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+------------+----------------+-----------+---------+------+------------- ---------+---------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- --------------------------------------------------------------------+ | 1 | root | localhost:4922 | ukmserver | Query | 1 | Copying to t mp table | select COUNT ( 1 ) from ( select article , max ( concat ( fTime , fVa l , deleted ) ) xxx from xxx_update_itms2_v u group by article ) u where ( SUBST RING ( u.xxx , 3 , 1 ) ='0' and SUBSTRING ( u.xxx , 1 , 2 ) ='11' ) or ( SUBSTRI NG ( u.xxx , 3 , 1 ) ='1' and SUBSTRING ( u.xxx , 1 , 2 ) <> '11' ) | | 62 | ukm_server | localhost:1123 | ukmserver | Sleep | 2 | | NULL | | 70 | ukm_server | localhost:1134 | ukmserver | Sleep | 93 | | NULL | | 560 | ukm_server | localhost:1667 | ukmserver | Sleep | 3831 | | NULL | | 1445 | root | localhost:2588 | NULL | Query | 0 | NULL | show full processlist | | 1545 | ukm_server | localhost:2695 | ukmserver | Sleep | 5 | | NULL | | 1546 | ukm_server | localhost:2696 | ukmserver | Query | 1 | freeing item s | select h.id from trm_out_receipt_header h force index(primary) inner join trm_out_receipt_footer f on h.cash_id = f.cash_id and h.id = f.id where h.c ash_id = 999001001 and h.id > 89 order by h.id | | 1547 | ukm_server | localhost:2697 | ukmserver | Sleep | 1 | | NULL | +------+------------+----------------+-----------+---------+------+------------- ---------+---------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- --------------------------------------------------------------------+ 8 rows in set (0.38 sec) mysql>