MySQL Forums
Forum List  »  MyISAM

Re: Problems with system locking
Posted by: Ananth Reddy
Date: June 14, 2006 10:22AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
8935
April 26, 2006 05:37AM
9561
April 27, 2006 04:36AM
3861
June 13, 2006 09:59PM
Re: Problems with system locking
2751
June 14, 2006 10:22AM
2995
June 15, 2006 11:18AM
2872
July 14, 2006 03:52PM
2809
August 22, 2006 11:34AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.