We have monitor job capture processlist and most of them are in sleep state except few which are trying to do some work.
Here is processlist:
2006-06-14 09:55:01
Id User Host db Command Time State Info
13 system user NULL Connect 1168267 Waiting for master to send event NULL
116084 repl d10.somedomain.com:39368 NULL Binlog Dump 672195 Has sent all binlog to slave; waiting for binlog to be updated NULL
152120 system user NULL Connect 0 Has read all relay log; waiting for the slave I/O thread to update it NULL
261016 repl d9.somedomain.com:49903 NULL Binlog Dump 149627 Has sent all binlog to slave; waiting for binlog to be updated NULL
329575 user a5.somedomain.com:34356 silo Sleep 81 NULL
329616 user a5.somedomain.com:34509 silo Sleep 81 NULL
329617 user a5.somedomain.com:34510 silo Sleep 81 NULL
329621 user a5.somedomain.com:34520 silo Sleep 80 NULL
329642 user-mdbro a15.somedomain.com:49033 silo Sleep 82 NULL
329643 user-mdbro a15.somedomain.com:49038 silo Sleep 82 NULL
329725 user-mmemdb d10.somedomain.com:41960 silo Sleep 0 NULL
329738 user-mmemdb d10.somedomain.com:42080 silo Sleep 0 NULL
329740 user-mmemdb d10.somedomain.com:42082 silo Sleep 39 NULL
329742 user-mmemdb d10.somedomain.com:42083 silo Sleep 0 NULL
329749 user-mmemdb d10.somedomain.com:42149 silo Sleep 0 NULL
329750 user-mmemdb d10.somedomain.com:42150 silo Sleep 0 NULL
329751 user-mmemdb d10.somedomain.com:42151 silo Sleep 0 NULL
329752 user-mmemdb d10.somedomain.com:42152 silo Sleep 0 NULL
329757 user a5.somedomain.com:34902 silo Sleep 81 NULL
329763 user a5.somedomain.com:34923 silo Sleep 81 NULL
329764 user a5.somedomain.com:34924 silo Sleep 80 NULL
329781 user-mmemdb d10.somedomain.com:42435 silo Sleep 0 NULL
329782 user-mmemdb d10.somedomain.com:42445 silo Sleep 0 NULL
329783 user a5.somedomain.com:34997 silo Sleep 81 NULL
329785 user a5.somedomain.com:35014 silo Sleep 46 NULL
329786 user a5.somedomain.com:35015 silo Sleep 81 NULL
329787 user a5.somedomain.com:35026 silo Sleep 81 NULL
329800 user-mmemdb d10.somedomain.com:42598 silo Sleep 0 NULL
329808 user-mmemdb d10.somedomain.com:42720 silo Sleep 1 NULL
329821 user-mmemdb d10.somedomain.com:42908 silo Sleep 39 NULL
329860 user a5.somedomain.com:35408 silo Query 1 update insert into SomeTableRecentBounce (member_id, email, mailType, mailId, bounceInfo, date) values (63622332, 'dragonlance@dhmail.net', 100, 56803, 'Undeliverable mail: Free and Easy Insurance Quotes plus Points!', '2006-06-14 09:55:00')
329863 user-mmemdb d10.somedomain.com:43361 silo Sleep 0 NULL
329864 user a5.somedomain.com:35420 silo Sleep 1 NULL
329867 user-mmemdb d10.somedomain.com:43390 silo Sleep 0 NULL
329879 user a5.somedomain.com:35486 silo Sleep 81 NULL
329885 user-mmemdb d10.somedomain.com:43611 silo Query 0 NULL NULL
329893 user-mmemdb d10.somedomain.com:43704 silo Sleep 0 NULL
329894 user-mmemdb d10.somedomain.com:43705 silo Sleep 0 NULL
329895 user-mmemdb d10.somedomain.com:43706 silo Sleep 0 NULL
329900 user-mmemdb d10.somedomain.com:43745 silo Sleep 1 NULL
329902 user-mmemdb d10.somedomain.com:43746 silo Sleep 69 NULL
329901 user-mmemdb d10.somedomain.com:43744 silo Sleep 69 NULL
329903 user-mmemdb d10.somedomain.com:43747 silo Sleep 0 NULL
329913 user-mmemdb d10.somedomain.com:43787 silo Sleep 1 NULL
329916 user-mmemdb d10.somedomain.com:43800 silo Sleep 82 NULL
329919 user-mmemdb d10.somedomain.com:43854 silo Sleep 0 NULL
329923 user-mmemdb d10.somedomain.com:43895 silo Sleep 0 NULL
329931 user-mmemdb d10.somedomain.com:44005 silo Sleep 0 NULL
329932 user-mmemdb d10.somedomain.com:44006 silo Sleep 1 NULL
329954 user a5.somedomain.com:35754 silo Sleep 80 NULL
329990 user a5.somedomain.com:35921 silo Sleep 81 NULL
329992 user a5.somedomain.com:35922 silo Sleep 81 NULL
329993 user a5.somedomain.com:35923 silo Sleep 80 NULL
329994 user a5.somedomain.com:35924 silo Sleep 81 NULL
329995 user a5.somedomain.com:35925 silo Sleep 1 NULL
329996 user a5.somedomain.com:35926 silo Sleep 81 NULL
329997 user a5.somedomain.com:35927 silo Sleep 81 NULL
329998 user a5.somedomain.com:35928 silo Sleep 81 NULL
329999 user a5.somedomain.com:35929 silo Sleep 80 NULL
330000 user a5.somedomain.com:35930 silo Sleep 81 NULL
330001 user a5.somedomain.com:35931 silo Query 0 System lock select membertxnt0_.id as id2_, membertxnt0_.date as date2_, membertxnt0_.member_id as member_id2_, membertxnt0_.trigger_id as trigger_id2_, membertxnt0_.cell_id as cell_id2_, membertxnt0_.srcIP as srcIP2_, membertxnt0_.testing as tes
ting2_, membertxnt0_.clickAward as clickAward2_, trigger1_.id as id0_, trigger1_.version as version0_, trigger1_.inactive as inactive0_, trigger1_.isInternal as isInternal0_, trigger1_.type as type0_, trigger1_.description as descript6_0_, trigger1_.mcAdjustable as mcAdjust7_0_, trigger1_.genericizedTrigger as ge
nerici8_0_, basecell2_.id as id1_, basecell2_.cellType as cellType1_, basecell2_.version as version1_, basecell2_.inactive as inactive1_, basecell2_.isInternal as isInternal1_, basecell2_.description as descript6_1_, basecell2_.notes as notes1_, basecell2_.cellSplashContent_id as cellSpla8_1_, basecell2_.state as
state1_, basecell2_.endDate as endDate1_, basecell2_.startDate as startDate1_, basecell2_.firstLive as firstLive1_, basecell2_.lastLive as lastLive1_, basecell2_.equivCells_id as equivCe14_1_, basecell2_.job_id as job_id1_, basecell2_.molester_adminUser_id as moleste16_1_, basecell2_.welcomeEmail as welcome17_1_
, basecell2_.targetURI as targetURI1_, basecell2_.hasGuardQuestion as hasGuar19_1_, basecell2_.guardQuestion_id as guardQu20_1_, basecell2_.ad_id as ad_id1_, basecell2_.copyText as copyText1_, basecell2_.pointsText as pointsText1_, basecell2_.parentCell_id as parentC24_1_, basecell2_.targetQuery as targetQ25_1_,
basecell2_.emailSubject as emailSu26_1_, basecell2_.emailFrom as emailFrom1_, basecell2_.block_id as block_id1_, basecell2_.autoDaily as autoDaily1_, ((basecell2_.startDate is null) or (basecell2_.startDate < now())) as f5_1_, ((basecell2_.endDate is not null) and (basecell2_.endDate < now())) as f6_1_ from Membe
rTxnTracking membertxnt0_ left outer join Trigger trigger1_ on membertxnt0_.trigger_id=trigger1_.id left outer join Cell basecell2_ on membertxnt0_.cell_id=basecell2_.id where membertxnt0_.id=216454257131233633
330002 user a5.somedomain.com:35932 silo Sleep 81 NULL
330003 user a5.somedomain.com:35933 silo Sleep 81 NULL
330004 user a5.somedomain.com:35934 silo Sleep 80 NULL
330005 user a5.somedomain.com:35935 silo Sleep 81 NULL
330006 user a5.somedomain.com:35936 silo Sleep 81 NULL
330007 user a5.somedomain.com:35937 silo Sleep 79 NULL
330008 user a5.somedomain.com:35938 silo Sleep 81 NULL
330009 user a5.somedomain.com:35939 silo Sleep 81 NULL
330010 user a5.somedomain.com:35940 silo Sleep 79 NULL
330011 user a5.somedomain.com:35941 silo Sleep 80 NULL
330012 user a5.somedomain.com:35942 silo Sleep 81 NULL
330013 user a5.somedomain.com:35943 silo Sleep 80 NULL
330014 user a5.somedomain.com:35944 silo Sleep 0 NULL
330015 user a5.somedomain.com:35945 silo Sleep 80 NULL
330016 user a5.somedomain.com:35946 silo Sleep 80 NULL
330017 user a5.somedomain.com:35947 silo Sleep 1 NULL
330018 user a5.somedomain.com:35948 silo Sleep 0 NULL
330019 user a5.somedomain.com:35949 silo Sleep 80 NULL
330020 user a5.somedomain.com:35950 silo Sleep 81 NULL
330021 user a5.somedomain.com:35951 silo Sleep 81 NULL
330022 user a5.somedomain.com:35952 silo Sleep 79 NULL
330023 user a5.somedomain.com:35953 silo Sleep 80 NULL
330024 user a5.somedomain.com:35954 silo Sleep 81 NULL
330025 user a5.somedomain.com:35955 silo Sleep 80 NULL
330026 user a5.somedomain.com:35956 silo Sleep 80 NULL
330027 user a5.somedomain.com:35957 silo Sleep 81 NULL
330028 user a5.somedomain.com:35958 silo Sleep 79 NULL
330029 user a5.somedomain.com:35959 silo Sleep 80 NULL
330030 user a5.somedomain.com:35960 silo Sleep 79 NULL
330031 user a5.somedomain.com:35961 silo Sleep 81 NULL
330032 user a5.somedomain.com:35962 silo Sleep 81 NULL
330033 user a5.somedomain.com:35963 silo Sleep 81 NULL
330034 user a5.somedomain.com:35964 silo Sleep 81 NULL
330035 user a5.somedomain.com:35965 silo Sleep 81 NULL
330036 user a5.somedomain.com:35966 silo Sleep 81 NULL
330037 user a5.somedomain.com:35967 silo Query 0 update insert into SomeTableTxnTracking (date, member_id, trigger_id, cell_id, srcIP, testing, clickAward, id) values ('2006-06-14 09:55:01', 25495362, 1, 64339, 1109734914, '0', 0, 216454257131233634)
330038 user a5.somedomain.com:35968 silo Sleep 81 NULL
330039 user a5.somedomain.com:35969 silo Sleep 80 NULL
330040 user a5.somedomain.com:35970 silo Query 0 Locked insert into SomeTableRecentBounce (member_id, email, mailType, mailId, bounceInfo, date) values (100865582, 'inatlnow@yahoo.com', 100, 56803, '554 delivery error: dd Sorry your message to
inatlnow@yahoo.com cannot be delivered. This account has
been disabled or discontinued [#102]. - mta329.mail.scd.yahoo.com', '2006-06-14 09:55:01')
330041 user a5.somedomain.com:35971 silo Sleep 81 NULL
330042 user a5.somedomain.com:35972 silo Sleep 0 NULL
330043 user a5.somedomain.com:35973 silo Sleep 81 NULL
330044 user a5.somedomain.com:35974 silo Sleep 81 NULL
330045 user a5.somedomain.com:35975 silo Sleep 81 NULL
330046 user a5.somedomain.com:35976 silo Sleep 80 NULL
330048 user a5.somedomain.com:35977 silo Sleep 81 NULL
330049 user a5.somedomain.com:35978 silo Sleep 81 NULL
330050 user a5.somedomain.com:35979 silo Sleep 81 NULL
330051 user a5.somedomain.com:35980 silo Query 0 cleaning up select basecell0_.id as id0_, basecell0_.cellType as cellType0_, basecell0_.version as version0_, basecell0_.inactive as inactive0_, basecell0_.isInternal as isInternal0_, basecell0_.description as descript6_0_, basecell0_.notes as no
tes0_, basecell0_.cellSplashContent_id as cellSpla8_0_, basecell0_.state as state0_, basecell0_.endDate as endDate0_, basecell0_.startDate as startDate0_, basecell0_.firstLive as firstLive0_, basecell0_.lastLive as lastLive0_, basecell0_.equivCells_id as equivCe14_0_, basecell0_.job_id as job_id0_, basecell0_.mol
ester_adminUser_id as moleste16_0_, basecell0_.welcomeEmail as welcome17_0_, basecell0_.targetURI as targetURI0_, basecell0_.hasGuardQuestion as hasGuar19_0_, basecell0_.guardQuestion_id as guardQu20_0_, basecell0_.ad_id as ad_id0_, basecell0_.copyText as copyText0_, basecell0_.pointsText as pointsText0_, basecel
l0_.parentCell_id as parentC24_0_, basecell0_.targetQuery as targetQ25_0_, basecell0_.emailSubject as emailSu26_0_, basecell0_.emailFrom as emailFrom0_, basecell0_.block_id as block_id0_, basecell0_.autoDaily as autoDaily0_, ((basecell0_.startDate is null) or (basecell0_.startDate < now())) as f5_0_, ((basecell0_
.endDate is not null) and (basecell0_.endDate < now())) as f6_0_ from Cell basecell0_ where basecell0_.id=14453
330052 user a5.somedomain.com:35981 silo Sleep 1 NULL
330053 user a5.somedomain.com:35982 silo Sleep 0 NULL
330054 user a5.somedomain.com:35983 silo Sleep 79 NULL
330055 user a5.somedomain.com:35984 silo Sleep 81 NULL
330056 user a5.somedomain.com:35985 silo Sleep 80 NULL
330057 user-mdbro a15.somedomain.com:52915 silo Sleep 10 NULL
330058 user-mdbro a15.somedomain.com:52917 silo Sleep 10 NULL
330060 user a5.somedomain.com:35986 silo Sleep 81 NULL
330061 user a5.somedomain.com:35987 silo Sleep 80 NULL
330062 user a5.somedomain.com:35988 silo Sleep 80 NULL
330063 user a5.somedomain.com:35989 silo Sleep 81 NULL
330064 user a5.somedomain.com:35990 silo Sleep 81 NULL
330065 user a5.somedomain.com:35991 silo Sleep 0 NULL
330066 user-mmemdb d10.somedomain.com:44666 silo Sleep 69 NULL
330067 user a5.somedomain.com:35993 silo Sleep 80 NULL
330068 user a5.somedomain.com:35994 silo Sleep 81 NULL
330069 user a5.somedomain.com:35995 silo Sleep 81 NULL
330070 user a5.somedomain.com:35996 silo Sleep 1 NULL
330071 user a5.somedomain.com:35997 silo Sleep 81 NULL
330072 user a5.somedomain.com:35998 silo Sleep 81 NULL
330073 user a5.somedomain.com:35999 silo Sleep 81 NULL
330074 user a5.somedomain.com:36001 silo Sleep 81 NULL
330075 user a5.somedomain.com:36002 silo Query 0 Writing to net select id, version from Cell where inactive=0 and state in (2,3)
330076 user a5.somedomain.com:36003 silo Query 0 Updating update SomeTable_DemogAnswerHistory set member_id=209055474, demogAnswer_id=1, startDate='2006-06-13 18:42:11', endDate=null, refreshDate='2006-06-14 09:54:59' where id=237369670
330078 user-mmemdb d10.somedomain.com:44669 silo Sleep 1 NULL
330080 user a5.somedomain.com:36006 silo Sleep 80 NULL
330081 user a5.somedomain.com:36009 silo Sleep 1 NULL
330082 user a5.somedomain.com:36013 silo Sleep 0 NULL
330084 user-mmemdb d10.somedomain.com:44757 silo Sleep 1 NULL
330087 user a5.somedomain.com:36060 silo Sleep 0 NULL
330097 user-mmemdb d10.somedomain.com:44855 silo Sleep 1 NULL
330098 user-mmemdb d10.somedomain.com:44856 silo Sleep 39 NULL
330114 user-mmemdb d10.somedomain.com:45100 silo Sleep 0 NULL
330121 mysql d41.somedomain.com:43418 NULL Query 0 NULL show full processlist
Thanks
ananth
Edited 1 time(s). Last edit at 06/14/2006 10:28AM by Ananth Reddy.