mysql> mysql> show full processlist; +-------+----------------+-----------------------------+---------+----------------+-------+----------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +-------+----------------+-----------------------------+---------+----------------+-------+----------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | 5 | root | localhost | stats | Sleep | 20194 | | NULL | | 274 | root | localhost | stats | Sleep | 19613 | | NULL | | 7621 | automo | 10.1.3.213:47245 | meta | Sleep | 14 | | NULL | | 9432 | dba | localhost | NULL | Query | 0 | NULL | show full processlist | | 9618 | dev | admon1.rev.internal:45906 | stats | Sleep | 2561 | | NULL | | 9621 | dev | admon1.rev.internal:45907 | stats | Sleep | 2574 | | NULL | | 9675 | zzhao | 10.1.2.15:33729 | stats | Connect | 2416 | Reading from net | NULL | | 9748 | dev | process7.rev.internal:38951 | stats | Sleep | 1128 | | NULL | | 9749 | dev | process3.rev.internal:56966 | stats | Sleep | 1131 | | NULL | | 9752 | dev | process7.rev.internal:38952 | stats | Sleep | 1156 | | NULL | | 9753 | dev | process3.rev.internal:56967 | stats | Sleep | 1146 | | NULL | | 9754 | dev | process2.rev.internal:56953 | stats | Sleep | 1152 | | NULL | | 9757 | dev | process4.rev.internal:57017 | stats | Sleep | 1140 | | NULL | | 9759 | dev | process2.rev.internal:56954 | stats | Sleep | 1151 | | NULL | | 9760 | dev | process4.rev.internal:57018 | stats | Sleep | 1142 | | NULL | | 9773 | dev | process7.rev.internal:38953 | meta | Sleep | 116 | | NULL | | 9775 | dev | process7.rev.internal:38954 | meta | Sleep | 115 | | NULL | | 9776 | dev | process3.rev.internal:56968 | meta | Sleep | 114 | | NULL | | 9777 | dev | process3.rev.internal:56969 | meta | Sleep | 113 | | NULL | | 9778 | dev | process2.rev.internal:56955 | meta | Sleep | 112 | | NULL | | 9779 | dev | process2.rev.internal:56956 | meta | Sleep | 110 | | NULL | | 9780 | dev | process4.rev.internal:57019 | meta | Sleep | 110 | | NULL | | 9781 | dev | process4.rev.internal:57020 | meta | Sleep | 108 | | NULL | | 9900 | dev | process6.rev.internal:35813 | stats | Sleep | 1456 | | NULL | | 9901 | billing_write | process6.rev.internal:35814 | billing | Connect | 1956 | Reading from net | NULL | | 9906 | dev | process6.rev.internal:35815 | meta | Sleep | 895 | | NULL | | 9989 | dev | fs1.internal:59759 | meta | Sleep | 1786 | | NULL | | 10032 | dev | process1.rev.internal:60956 | stats | Query | 1330 | Sending data | SELECT site_id, pplacement_id, campaign_id, partofweek, local_hour, v, c, p, day FROM timeofday_master WHERE site_id AND day >= '20060109' AND pplacement_id != 11 | | 10033 | dev | process1.rev.internal:60957 | meta | Sleep | 1656 | | NULL | | 10103 | DELAYED | | stats | Delayed insert | 88 | Waiting for INSERT | | | 10112 | DELAYED | | stats | Delayed insert | 1389 | upgrading lock | | | 10134 | DELAYED | | stats | Delayed insert | 1474 | reschedule | | | 10146 | dev | fs1.internal:59869 | meta | Sleep | 1417 | | NULL | | 10150 | DELAYED | | stats | Delayed insert | 45 | Waiting for INSERT | | | 10200 | dev | fs1.internal:59925 | meta | Connect | 1482 | Reading from net | NULL | | 10201 | dev | fs1.internal:59926 | stats | Query | 1481 | Copying to tmp table | SELECT s.campaign_id AS campaign_id, sum(v) AS v, sum(c) AS c, sum(p) AS p, sum(p2) AS p2, sum(p3) AS p3, sum(revenue) AS revenue, sum(commission) AS commission FROM detail_current AS s WHERE s.day='2006-02-06' AND s.day='2006-02-06' GROUP BY campaign_id | | 10350 | dev | web3.rev.internal:47640 | meta | Sleep | 1319 | | NULL | | 10351 | dev | web3.rev.internal:47641 | stats | Query | 1171 | Locked | SELECT s.site_id AS site_id, sum(v) AS v, sum(c) AS c, sum(p) AS p, sum(p2) AS p2, sum(p3) AS p3, sum(revenue) AS revenue, sum(commission) AS commission FROM detail_current AS s WHERE s.publisher_id='63341' AND s.day>='2006-02-06' AND s.day<='2006-02-06' GROUP BY site_id | | 10352 | dev | web3.rev.internal:47642 | meta | Sleep | 1171 | | NULL | | 10361 | dev | fs1.internal:60072 | meta | Sleep | 1308 | | NULL | | 10382 | dev | web3.rev.internal:47649 | meta | Sleep | 1276 | | NULL | | 10383 | dev | web3.rev.internal:47650 | stats | Query | 1171 | Locked | SELECT s.site_id AS site_id, sum(v) AS v, sum(c) AS c, sum(p) AS p, sum(p2) AS p2, sum(p3) AS p3, sum(revenue) AS revenue, sum(commission) AS commission FROM detail_current AS s WHERE s.publisher_id='63341' AND s.day>='2006-02-06' AND s.day<='2006-02-06' GROUP BY site_id | | 10384 | dev | web3.rev.internal:47651 | meta | Sleep | 1171 | | NULL | | 10388 | dev | web3.rev.internal:47656 | meta | Sleep | 1268 | | NULL | | 10389 | dev | web3.rev.internal:47657 | stats | Query | 1171 | Locked | SELECT s.site_id AS site_id, sum(v) AS v, sum(c) AS c, sum(p) AS p, sum(p2) AS p2, sum(p3) AS p3, sum(revenue) AS revenue, sum(commission) AS commission FROM detail_current AS s WHERE s.publisher_id='63341' AND s.day>='2006-02-06' AND s.day<='2006-02-06' GROUP BY site_id | | 10390 | dev | web3.rev.internal:47658 | meta | Sleep | 1171 | | NULL | | 10422 | dev | fs1.internal:60124 | meta | Sleep | 1185 | | NULL | | 10423 | dev | fs1.internal:60125 | stats | Query | 1185 | Locked | SELECT s.campaign_id AS campaign_id, sum(v) AS v, sum(c) AS c, sum(p) AS p, sum(p2) AS p2, sum(p3) AS p3, sum(revenue) AS revenue, sum(commission) AS commission FROM detail_current AS s WHERE s.advertiser_id='300046' AND s.day>='2006-02-06' AND s.day<='2006-02-06' GROUP BY campaign_id | | 10431 | dev | web3.rev.internal:47674 | meta | Sleep | 1171 | | NULL | | 10432 | dev | web3.rev.internal:47675 | meta | Sleep | 1171 | | NULL | | 10433 | dev | web3.rev.internal:47676 | meta | Sleep | 1171 | | NULL | | 10509 | dev | fs1.internal:60201 | meta | Connect | 1042 | Reading from net | NULL | | 10513 | dev | fs1.internal:60206 | stats | Query | 1041 | Locked | SELECT s.day AS day, sum(v) AS v, sum(c) AS c, sum(p) AS p, sum(p2) AS p2, sum(p3) AS p3, sum(revenue) AS revenue, sum(commission) AS commission FROM detail_current AS s WHERE s.day>='2006-02-01' AND s.day<='2006-02-06' GROUP BY day | | 10542 | dev | process5.rev.internal:45317 | stats | Sleep | 113 | | NULL | | 10544 | dev | process5.rev.internal:45318 | stats | Sleep | 152 | | NULL | | 10607 | dev | process5.rev.internal:45319 | meta | Sleep | 52 | | NULL | | 10609 | dev | process5.rev.internal:45320 | meta | Sleep | 50 | | NULL | | 10624 | dev | fs1.internal:60338 | meta | Sleep | 935 | | NULL | | 10722 | billing_wr_fs1 | fs1.internal:60462 | billing | Sleep | 783 | | NULL | | 10760 | dev | thor.internal:47995 | stats | Sleep | 645 | | NULL | | 10761 | dev | thor.internal:47996 | meta | Sleep | 634 | | NULL | | 10777 | dev | thor.internal:48018 | stats | Connect | 628 | Reading from net | NULL | | 10778 | dev | thor.internal:48019 | meta | Connect | 628 | Reading from net | NULL | | 10782 | dev | thor.internal:48024 | stats | Sleep | 396 | | NULL | | 10783 | dev | thor.internal:48025 | meta | Sleep | 396 | | NULL | | 10817 | dev | thor.internal:48055 | stats | Sleep | 232 | | NULL | | 10818 | dev | thor.internal:48056 | meta | Sleep | 233 | | NULL | | 10845 | dev | web3.rev.internal:47777 | meta | Sleep | 424 | | NULL | | 10846 | dev | web3.rev.internal:47778 | stats | Query | 424 | Locked | SELECT s.site_id AS site_id, sum(v) AS v, sum(c) AS c, sum(p) AS p, sum(p2) AS p2, sum(p3) AS p3, sum(revenue) AS revenue, sum(commission) AS commission FROM detail_current AS s WHERE s.publisher_id='63341' AND s.day>='2006-02-01' AND s.day<='2006-02-06' GROUP BY site_id | | 10847 | dev | web3.rev.internal:47779 | meta | Connect | 424 | Reading from net | NULL | | 10856 | dev | web3.rev.internal:47792 | meta | Sleep | 416 | | NULL | | 10857 | dev | web3.rev.internal:47793 | stats | Query | 416 | Locked | SELECT s.site_id AS site_id, sum(v) AS v, sum(c) AS c, sum(p) AS p, sum(p2) AS p2, sum(p3) AS p3, sum(revenue) AS revenue, sum(commission) AS commission FROM detail_current AS s WHERE s.publisher_id='58961' AND s.day>='2006-02-01' AND s.day<='2006-02-06' GROUP BY site_id | | 10858 | dev | web3.rev.internal:47794 | meta | Connect | 416 | Reading from net | NULL | | 10867 | dev | web3.rev.internal:47801 | meta | Sleep | 368 | | NULL | | 10868 | dev | web3.rev.internal:47802 | stats | Query | 368 | Locked | SELECT s.site_id AS site_id, sum(v) AS v, sum(c) AS c, sum(p) AS p, sum(p2) AS p2, sum(p3) AS p3, sum(revenue) AS revenue, sum(commission) AS commission FROM detail_current AS s WHERE s.publisher_id='63341' AND s.day>='2006-02-01' AND s.day<='2006-02-06' GROUP BY site_id | | 10869 | dev | web3.rev.internal:47803 | meta | Connect | 368 | Reading from net | NULL | | 10883 | dev | web3.rev.internal:47813 | meta | Sleep | 322 | | NULL | | 10884 | dev | web3.rev.internal:47814 | stats | Query | 322 | Locked | SELECT s.site_id AS site_id, sum(v) AS v, sum(c) AS c, sum(p) AS p, sum(p2) AS p2, sum(p3) AS p3, sum(revenue) AS revenue, sum(commission) AS commission FROM detail_current AS s WHERE s.publisher_id='58961' AND s.day>='2006-02-01' AND s.day<='2006-02-06' GROUP BY site_id | | 10885 | dev | web3.rev.internal:47815 | meta | Connect | 322 | Reading from net | NULL | | 10888 | dev | munin.rnd.internal:41894 | meta | Sleep | 297 | | NULL | | 10891 | dev | web3.rev.internal:47823 | meta | Sleep | 294 | | NULL | | 10892 | dev | web3.rev.internal:47824 | stats | Query | 294 | Locked | SELECT s.site_id AS site_id, sum(v) AS v, sum(c) AS c, sum(p) AS p, sum(p2) AS p2, sum(p3) AS p3, sum(revenue) AS revenue, sum(commission) AS commission FROM detail_current AS s WHERE s.publisher_id='63341' AND s.day>='2006-02-01' AND s.day<='2006-02-06' GROUP BY site_id | | 10893 | dev | web3.rev.internal:47825 | meta | Connect | 294 | Reading from net | NULL | | 10896 | dev | web3.rev.internal:47829 | meta | Sleep | 285 | | NULL | | 10897 | dev | web3.rev.internal:47830 | stats | Query | 285 | Locked | SELECT s.site_id AS site_id, sum(v) AS v, sum(c) AS c, sum(p) AS p, sum(p2) AS p2, sum(p3) AS p3, sum(revenue) AS revenue, sum(commission) AS commission FROM detail_current AS s WHERE s.publisher_id='62853' AND s.day>='2006-02-01' AND s.day<='2006-02-06' GROUP BY site_id | | 10898 | dev | web3.rev.internal:47831 | meta | Connect | 285 | Reading from net | NULL | | 10906 | dev | web3.rev.internal:47839 | meta | Sleep | 258 | | NULL | | 10907 | dev | web3.rev.internal:47840 | stats | Query | 258 | Locked | SELECT s.site_id AS site_id, sum(v) AS v, sum(c) AS c, sum(p) AS p, sum(p2) AS p2, sum(p3) AS p3, sum(revenue) AS revenue, sum(commission) AS commission FROM detail_current AS s WHERE s.publisher_id='55191' AND s.day>='2006-02-01' AND s.day<='2006-02-06' GROUP BY site_id | | 10908 | dev | web3.rev.internal:47841 | meta | Connect | 258 | Reading from net | NULL | | 10911 | dev | web3.rev.internal:47842 | meta | Sleep | 247 | | NULL | | 10912 | dev | web3.rev.internal:47843 | stats | Query | 247 | Locked | SELECT s.site_id AS site_id, sum(v) AS v, sum(c) AS c, sum(p) AS p, sum(p2) AS p2, sum(p3) AS p3, sum(revenue) AS revenue, sum(commission) AS commission FROM detail_current AS s WHERE s.publisher_id='62040' AND s.day>='2006-02-01' AND s.day<='2006-02-06' GROUP BY site_id | | 10913 | dev | web3.rev.internal:47844 | meta | Connect | 247 | Reading from net | NULL | | 10921 | DELAYED | | stats | Delayed insert | 113 | Waiting for INSERT | | | 10922 | DELAYED | | stats | Delayed insert | 112 | Waiting for INSERT | | | 10923 | DELAYED | | stats | Delayed insert | 110 | Waiting for INSERT | | | 10924 | DELAYED | | stats | Delayed insert | 106 | Waiting for INSERT | | | 10925 | DELAYED | | stats | Delayed insert | 106 | Waiting for INSERT | | | 10926 | DELAYED | | stats | Delayed insert | 106 | Waiting for INSERT | | | 10927 | DELAYED | | stats | Delayed insert | 103 | Waiting for INSERT | | | 10928 | DELAYED | | stats | Delayed insert | 101 | Waiting for INSERT | | | 10929 | DELAYED | | stats | Delayed insert | 98 | Waiting for INSERT | | | 10930 | DELAYED | | stats | Delayed insert | 95 | Waiting for INSERT | | | 10931 | DELAYED | | stats | Delayed insert | 89 | Waiting for INSERT | | | 10932 | DELAYED | | stats | Delayed insert | 88 | Waiting for INSERT | | | 10941 | dev | web3.rev.internal:47849 | meta | Sleep | 200 | | NULL | | 10942 | dev | web3.rev.internal:47850 | stats | Query | 200 | Locked | SELECT s.site_id AS site_id, sum(v) AS v, sum(c) AS c, sum(p) AS p, sum(p2) AS p2, sum(p3) AS p3, sum(revenue) AS revenue, sum(commission) AS commission FROM detail_current AS s WHERE s.publisher_id='55191' AND s.day>='2006-02-01' AND s.day<='2006-02-06' GROUP BY site_id | | 10943 | dev | web3.rev.internal:47851 | meta | Connect | 200 | Reading from net | NULL | | 10944 | DELAYED | | stats | Delayed insert | 62 | Waiting for INSERT | | | 10945 | DELAYED | | stats | Delayed insert | 60 | Waiting for INSERT | | | 10946 | DELAYED | | stats | Delayed insert | 43 | Waiting for INSERT | | | 10947 | DELAYED | | stats | Delayed insert | 41 | Waiting for INSERT | | | 10949 | dev | web3.rev.internal:47852 | meta | Sleep | 158 | | NULL | | 10950 | dev | web3.rev.internal:47853 | stats | Query | 158 | Locked | SELECT s.site_id AS site_id, sum(v) AS v, sum(c) AS c, sum(p) AS p, sum(p2) AS p2, sum(p3) AS p3, sum(revenue) AS revenue, sum(commission) AS commission FROM detail_current AS s WHERE s.publisher_id='62040' AND s.day>='2006-02-01' AND s.day<='2006-02-06' GROUP BY site_id | | 10951 | dev | web3.rev.internal:47854 | meta | Connect | 158 | Reading from net | NULL | | 10987 | ds | munch4.ds.internal:40403 | meta | Sleep | 154 | | NULL | | 10994 | dev | web3.rev.internal:47860 | meta | Sleep | 147 | | NULL | | 10995 | dev | web3.rev.internal:47861 | stats | Query | 147 | Locked | SELECT s.site_id AS site_id, sum(v) AS v, sum(c) AS c, sum(p) AS p, sum(p2) AS p2, sum(p3) AS p3, sum(revenue) AS revenue, sum(commission) AS commission FROM detail_current AS s WHERE s.publisher_id='62853' AND s.day>='2006-02-01' AND s.day<='2006-02-06' GROUP BY site_id | | 10996 | dev | web3.rev.internal:47862 | meta | Connect | 147 | Reading from net | NULL | | 11004 | dev | web3.rev.internal:47870 | meta | Sleep | 115 | | NULL | | 11005 | dev | web3.rev.internal:47871 | stats | Query | 115 | Locked | SELECT s.site_id AS site_id, sum(v) AS v, sum(c) AS c, sum(p) AS p, sum(p2) AS p2, sum(p3) AS p3, sum(revenue) AS revenue, sum(commission) AS commission FROM detail_current AS s WHERE s.publisher_id='55191' AND s.day>='2006-02-01' AND s.day<='2006-02-06' GROUP BY site_id | | 11006 | dev | web3.rev.internal:47872 | meta | Connect | 115 | Reading from net | NULL | | 11016 | ds | munch2.ds.internal:37243 | meta | Sleep | 95 | | NULL | | 11018 | ds | munch3.ds.internal:53384 | meta | Sleep | 94 | | NULL | | 11022 | dev | web3.rev.internal:47883 | meta | Sleep | 87 | | NULL | | 11023 | dev | web3.rev.internal:47884 | stats | Query | 87 | Locked | SELECT s.site_id AS site_id, sum(v) AS v, sum(c) AS c, sum(p) AS p, sum(p2) AS p2, sum(p3) AS p3, sum(revenue) AS revenue, sum(commission) AS commission FROM detail_current AS s WHERE s.publisher_id='58961' AND s.day>='2006-02-01' AND s.day<='2006-02-06' GROUP BY site_id | | 11024 | dev | web3.rev.internal:47885 | meta | Connect | 87 | Reading from net | NULL | | 11028 | dev | web3.rev.internal:47891 | meta | Sleep | 65 | | NULL | | 11029 | dev | web3.rev.internal:47892 | stats | Query | 65 | Locked | SELECT s.site_id AS site_id, sum(v) AS v, sum(c) AS c, sum(p) AS p, sum(p2) AS p2, sum(p3) AS p3, sum(revenue) AS revenue, sum(commission) AS commission FROM detail_current AS s WHERE s.publisher_id='63341' AND s.day>='2006-02-01' AND s.day<='2006-02-06' GROUP BY site_id | | 11030 | dev | web3.rev.internal:47893 | meta | Connect | 65 | Reading from net | NULL | | 11035 | ds | munch2.ds.internal:37251 | meta | Sleep | 33 | | NULL | | 11037 | ds | munch2.ds.internal:37253 | meta | Sleep | 32 | | NULL | | 11041 | dev | web3.rev.internal:47902 | meta | Sleep | 26 | | NULL | | 11042 | dev | web3.rev.internal:47903 | stats | Query | 26 | Locked | SELECT s.site_id AS site_id, sum(v) AS v, sum(c) AS c, sum(p) AS p, sum(p2) AS p2, sum(p3) AS p3, sum(revenue) AS revenue, sum(commission) AS commission FROM detail_current AS s WHERE s.publisher_id='63341' AND s.day>='2006-02-01' AND s.day<='2006-02-06' GROUP BY site_id | | 11043 | dev | web3.rev.internal:47904 | meta | Connect | 26 | Reading from net | NULL | | 11046 | dev | web3.rev.internal:47909 | meta | Sleep | 21 | | NULL | | 11047 | dev | web3.rev.internal:47910 | meta | Connect | 21 | Reading from net | NULL | | 11048 | dev | web3.rev.internal:47911 | meta | Sleep | 21 | | NULL | | 11049 | dev | web3.rev.internal:47912 | stats | Query | 21 | Locked | SELECT s.site_id AS site_id, sum(v) AS v, sum(c) AS c, sum(p) AS p, sum(p2) AS p2, sum(p3) AS p3, sum(revenue) AS revenue, sum(commission) AS commission FROM detail_current AS s WHERE s.publisher_id='63341' AND s.day>='2006-02-06' AND s.day<='2006-02-06' GROUP BY site_id | | 11059 | dev | fs1.internal:60554 | meta | Sleep | 0 | | NULL | | 11060 | dev | fs1.internal:60555 | meta | Sleep | 0 | | NULL | +-------+----------------+-----------------------------+---------+----------------+-------+----------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 140 rows in set (0.01 sec) mysql>