用友股份-LE服务支持部技术方案--《Iufo效率诊断》建立日期：2013-04-01修改日期：xxxx-xx-xx文档属性：客户文控编号：LE-DY-JS-2013-00252/240文档控制创建记录审阅人姓名所属部门职位审阅签字发布人姓名所属部门发布时间日期作者所属部门邮件地址版本2013-04-01蔡平昕V1.03目录Iufo效率诊断.......................................................................................................................4一、系统环境:..............................................................................................................4二、问题现象：...........................................................................................................4三、问题分析：...........................................................................................................4四、解决方法:..............................................................................................................5五、附录：...................................................................................................................54Iufo效率诊断一、系统环境:环境：linux+NC5.6WAS中间件Oracle数据库二、问题现象：某项目iufo效率突然变慢，正好年初报表要发布，非常紧急。三、问题分析：1.交流发现去年报表不慢，今年这个报表就开始慢了。2.跟踪nmc发现报表确实很慢，大量的循环语句查询客商档案(bd_cumandoc)的查询。3.因为客商档案应该从中间件缓存读取，为什么还大量查询后台数据库。根据sql数据库查询，发现记录均是空。从下面附录也可以看出（readnum=0)4.缓存无法使用导致数据库压力过大。5.与业务沟通发现客商档案没有分配，建议分配。56.分配后问题得到解决。四、解决方法:公式中的客商档案、存货档案、科目等不能为空，把为空的删除或分配掉。五、附录：附录一：thread=Thread-63status=BLOCKEDelapsetime=3294266operator=N/AremoteAddr=N/AremoteCallMethod=nc.bs.framework.execute.Executor$1@16c2db9sqlcosttime=393296;readresulttime=39833;readrownum=259506;writetoclienttime=0;writetoclientbytes=0;readfromclientbytes=0;notclosedconnectioncount=0#threadstacknc.vo.bd.access.FlatBDaccessor.loadDataByCon(FlatBDaccessor.java:342)nc.vo.bd.access.FlatBDaccessor.getDocByCode(FlatBDaccessor.java:134)nc.vo.gl.glreporttools.PrepareAssParse.getValuePkByValueCode(PrepareAssParse.java:1257)nc.vo.gl.glreporttools.PrepareAssParse.prepareAssitant(PrepareAssParse.java:1024)nc.vo.gl.glreporttools.PrepareAssParse.getAssVOsByAssInit(PrepareAssParse.java:550)nc.vo.gl.glreporttools.AssPrepareMultiCorps.prepareAssMultiCorps(AssPrepareMultiCorps.java:73)6nc.ui.gl.glreport.FunctionExecutor.exFctBtch1(FunctionExecutor.java:706)nc.ui.gl.glreporttools.OriginalSrvCallNCGL.callFunc1(OriginalSrvCallNCGL.java:391)nc.ui.gl.glreporttools.OriginalSrvCallNCGL.callFunc(OriginalSrvCallNCGL.java:760)nc.ui.fi.uforeport.NCFuncForUFO.calcFuncValues(NCFuncForUFO.java:88)com.ufsoft.script.DynFormulaUtil.preCalcDynExtFunc(DynFormulaUtil.java:89)com.ufsoft.iufo.fmtplugin.formula.UfoFmlExecutor.batchCalcDynFinafunc(UfoFmlExecutor.java:2965)com.ufsoft.iufo.fmtplugin.formula.UfoFmlExecutor.calDynAreaFormula(UfoFmlExecutor.java:2660)com.ufsoft.iufo.fmtplugin.formula.UfoFmlExecutor.calAllDynAreas(UfoFmlExecutor.java:2235)com.ufsoft.iufo.fmtplugin.formula.UfoFmlExecutor.calcAllFormula(UfoFmlExecutor.java:1559)com.ufsoft.iufo.fmtplugin.formula.UfoFmlExecutor.calcAllFormula(UfoFmlExecutor.java:1512)com.ufsoft.iufo.fmtplugin.service.ReportCalcSrv.calcAllFormula(ReportCalcSrv.java:118)nc.ui.iuforeport.repcalc.RepCalcThrd.run(RepCalcThrd.java:251)nc.bs.framework.execute.Executor$1.run(Executor.java:90)nc.bs.framework.execute.impl.ExecutorThread.run(ExecutorThread.java:30)#sqlstatck:totalcosttime=393296totalnumberofSql=55104totalconnectionused=177#TheSql0:selectdistinctbd_cumandoc.pk_cubasdoc,custcode,custname,bd_cumandoc.pk_corp,bd_cubasdoc.pk_corp,null,bd_cubasdoc.pk_cubasdocfrombd_cumandoc,bd_cubasdocwhere1=1and(bd_cumandoc.pk_cubasdoc=bd_cubasdoc.pk_cubasdoc)and(bd_cumandoc.pk_corp='1070'orbd_cumandoc.pk_corp='0001')and(bd_cumandoc.custflag='0'orbd_cumandoc.custflag='2')andcustcode='600111'costtime=47readnum=0status=finished#TheSql1:selectdistinctbd_deptdoc.pk_deptdoc,deptcode,deptname,bd_deptdoc.pk_corp,null,pk_fathedept,nullfrombd_deptdocwhere1=1and(bd_deptdoc.pk_corp='1070')anddeptcode='61988'costtime=16readnum=0status=finished#TheSql2:selectdistinctbd_cumandoc.pk_cubasdoc,custcode,custname,bd_cumandoc.pk_corp,bd_cubasdoc.pk_corp,null,bd_cubasdoc.pk_cubasdocfrombd_cumandoc,bd_cubasdocwhere1=1and(bd_cumandoc.pk_cubasdoc=bd_cubasdoc.pk_cubasdoc)and(bd_cumandoc.pk_corp='1070'orbd_cumandoc.pk_corp='0001')and(bd_cumandoc.custflag='0'orbd_cumandoc.custflag='2')andcustcode='600111'costtime=47readnum=0status=finished8#TheSql3:selectdistinctbd_deptdoc.pk_deptdoc,deptcode,deptname,bd_deptdoc.pk_corp,null,pk_fathedept,nullfrombd_deptdocwhere1=1and(bd_deptdoc.pk_corp='1070')anddeptcode='61988'costtime=0readnum=0status=finished#TheSql4:selectdistinctbd_deptdoc.pk_deptdoc,deptcode,deptname,bd_deptdoc.pk_corp,null,pk_fathedept,nullfrombd_deptdocwhere1=1and(bd_deptdoc.pk_corp='1070')anddeptcode='61988'costtime=0readnum=0status=finished#TheSql5:selectdistinctbd_deptdoc.pk_deptdoc,deptcode,deptname,bd_deptdoc.pk_corp,null,pk_fathedept,nullfrombd_deptdocwhere1=1and(bd_deptdoc.pk_corp='1070')anddeptcode='61988'costtime=0readnum=0status=finished#TheSql6:selectdistinctbd_cumandoc.pk_cubasdoc,custcode,custname,bd_cumandoc.pk_corp,bd_cubasdoc.pk_corp,null,bd_cubasdoc.pk_cubasdocfrombd_cumandoc,bd_cubasdocwhere1=1and(bd_cumandoc.pk_cubasdoc=bd_cubasdoc.pk_cubasdoc)and(bd_cumandoc.pk_corp='1070'or9bd_cumandoc.pk_corp='0001')and(bd_cumandoc.custflag='0'orbd_cumandoc.custflag='2')andcustcode='600111'costtime=62readnum=0status=finished#TheSql7:selectdistinctbd_deptdoc.pk_deptdoc,deptcode,deptname,bd_deptdoc.pk_corp,null,pk_fathedept,nullfrombd_deptdocwhere1=1and(bd_deptdoc.pk_corp='1070')anddeptcode='61988'costtime=0readnum=0status=finished#TheSql8:selectdistinctbd_cumandoc.pk_cubasdoc,custcode,custname,bd_cumandoc.pk_corp,bd_cubasdoc.pk_corp,null,bd_cubasdoc.pk_cubasdocfrombd_cumandoc,bd_cubasdocwhere1=1and(bd_cumandoc.pk_cubasdoc=bd_cubasdoc.pk_cubasdoc)and(bd_cumandoc.pk_corp='1070'orbd_cumandoc.pk_corp='0001')and(bd_cumandoc.custflag='0'orbd_cumandoc.custflag='2')andcustcode='600111'costtime=63readnum=0status=finished#TheSql9:selectdistinctbd_deptdoc.pk_deptdoc,deptcode,deptname,bd_deptdoc.pk_corp,null,pk_fathedept,nullfrombd_deptdocwhere1=1and(bd_deptdoc.pk_corp='1070')anddeptcode='61988'10costtime=0readnum=0status=finished#TheSql10:selectdistinctbd_deptdoc.pk_deptdoc,deptcode,deptname,bd_deptdoc.pk_corp,null,pk_fathedept,nullfrombd_deptdocwhere1=1and(bd_deptdoc.pk_corp='1070')anddeptcode='61988'costtime=0readnum=0status=finished#TheSql11:selectdistinctbd_deptdoc.pk_deptdoc,deptcode,deptname,bd_deptdoc.pk_corp,null,pk_fathedept,nullfrombd_deptdocwhere1=1and(bd_deptdoc.pk_corp='1070')anddeptcode='61988'costtime=0readnum=0status=finished#TheSql12:selectdistinctbd_cumandoc.pk_cubasdoc,custcode,custname,bd_cumandoc.pk_corp,bd_cubasdoc.pk_corp,null,bd_cubasdoc.pk_cubasdocfrombd_cumandoc,bd_cubasdocwhere1=1and(bd_cumandoc.pk_cubasdoc=bd_cubasdoc.pk_cubasdoc)and(bd_cumandoc.pk_corp='1070'orbd_cumandoc.pk_corp='0001')and(bd_cumandoc.custflag='0'orbd_cumandoc.custflag='2')andcustcode='600111'costtime=78readnum=011status=finished#TheSql13:selectdistinctbd_deptdoc.pk_deptdoc,deptcode,deptname,bd_deptdoc.pk_corp,null,pk_fathedept,nullfrombd_deptdocwhere1=1and(bd_deptdoc.pk_corp='1070')anddeptcode='61988'costtime=0readnum=0status=finished#TheSql14:selectdistinctbd_cumandoc.pk_cubasdoc,custcode,custname,bd_cumandoc.pk_corp,bd_cubasdoc.pk_corp,null,bd_cubasdoc.pk_cubasdocfrombd_cumandoc,bd_cubasdocwhere1=1and(bd_cumandoc.pk_cubasdoc=bd_cubasdoc.pk_cubasdoc)and(bd_cumandoc.pk_corp='1070'orbd_cumandoc.pk_corp='0001')and(bd_cumandoc.custflag='0'orbd_cumandoc.custflag='2')andcustcode='600111'costtime=62readnum=0status=finished#TheSql15:selectdistinctbd_deptdoc.pk_deptdoc,deptcode,deptname,bd_deptdoc.pk_corp,null,pk_fathedept,nullfrombd_deptdocwhere1=1and(bd_deptdoc.pk_corp='1070')anddeptcode='61988'costtime=0readnum=0status=finished#TheSql16:12selectdistinctbd_deptdoc.pk_deptdoc,deptcode,deptname,bd_deptdoc.pk_corp,null,pk_fathedept,nullfrombd_deptdocwhere1=1and(bd_deptdoc.pk_corp='1070')anddeptcode='61988'costtime=0readnum=0status=finished#TheSql17:selectdistinctbd_deptdoc.pk_deptdoc,deptcode,deptname,bd_deptdoc.pk_corp,null,pk_fathedept,nullfrombd_deptdocwhere1=1and(bd_deptdoc.pk_corp='1070')anddeptcode='61988'costtime=0readnum=0status=finished#TheSql18:selectdistinctbd_cumandoc.pk_cubasdoc,custcode,custname,bd_cumandoc.pk_corp,bd_cubasdoc.pk_corp,null,bd_cubasdoc.pk_cubasdocfrombd_cumandoc,bd_cubasdocwhere1=1and(bd_cumandoc.pk_cubasdoc=bd_cubasdoc.pk_cubasdoc)and(bd_cumandoc.pk_corp='1070'orbd_cumandoc.pk_corp='0001')and(bd_cumandoc.custflag='0'orbd_cumandoc.custflag='2')andcustcode='600111'costtime=47readnum=0status=finished#TheSql19:selectdistinctbd_deptdoc.pk_deptdoc,deptcode,deptname,bd_deptdoc.pk_corp,null,pk_fathedept,nullfrombd_deptdocwhere1=1and(bd_deptdoc.pk_corp='1070')anddeptcode='61988'13costtime=0readnum=0status=finished#TheSql20:selectdistinctbd_cumandoc.pk_cubasdoc,custcode,custname,bd_cumandoc.pk_corp,bd_cubasdoc.pk_corp,null,bd_cubasdoc.pk_cubasdocfrombd_cumandoc,bd_cubasdocwhere1=1and(bd_cumandoc.pk_cubasdoc=bd_cubasdoc.pk_cubasdoc)and(bd_cumandoc.pk_corp='1070'orbd_cumandoc.pk_corp='0001')and(bd_cumandoc.custflag='0'orbd_cumandoc.custflag='2')andcustcode='600111'costtime=47readnum=0status=finished#TheSql21:selectdistinctbd_deptdoc.pk_deptdoc,deptcode,deptname,bd_deptdoc.pk_corp,null,pk_fathedept,nullfrombd_deptdocwhere1=1and(bd_deptdoc.pk_corp='1070')anddeptcode='61988'costtime=0readnum=0status=finished#TheSql22:selectdistinctbd_deptdoc.pk_deptdoc,deptcode,deptname,bd_deptdoc.pk_corp,null,pk_fathedept,nullfrombd_deptdocwhere1=1and(bd_deptdoc.pk_corp='1070')anddeptcode='61988'costtime=0readnum=014status=finished#TheSql23:selectdistinctbd_deptdoc.pk_deptdoc,deptcode,deptname,bd_deptdoc.pk_corp,null,pk_fathedept,nullfrombd_deptdocwhere1=1and(bd_deptdoc.pk_corp='1070')anddeptcode='61988'costtime=0readnum=0status=finished#TheSql24:selectdistinctbd_cumandoc.pk_cubasdoc,custcode,custname,bd_cumandoc.pk_corp,bd_cubasdoc.pk_corp,null,bd_cubasdoc.pk_cubasdocfrombd_cumandoc,bd_cubasdocwhere1=1and(bd_cumandoc.pk_cubasdoc=bd_cubasdoc.pk_cubasdoc)and(bd_cumandoc.pk_corp='1070'orbd_cumandoc.pk_corp='0001')and(bd_cumandoc.custflag='0'orbd_cumandoc.custflag='2')andcustcode='600111'costtime=47readnum=0status=finished#TheSql25:selectdistinctbd_deptdoc.pk_deptdoc,deptcode,deptname,bd_deptdoc.pk_corp,null,pk_fathedept,nullfrombd_deptdocwhere1=1and(bd_deptdoc.pk_corp='1070')anddeptcode='61988'costtime=0readnum=0status=finished#TheSql26:15selectdistinctbd_cumandoc.pk_cubasdoc,custcode,custname,bd_cumandoc.pk_corp,bd_cubasdoc.pk_corp,null,bd_cubasdoc.pk_cubasdocfrombd_cumandoc,bd_cubasdocwhere1=1and(bd_cumandoc.pk_cubasdoc=bd_cubasdoc.pk_cubasdoc)and(bd_cumandoc.pk_corp='1070'orbd_cumandoc.pk_corp='0001')and(bd_cumandoc.custflag='0'orbd_cumandoc.custflag='2')andcustcode='600111'costtime=62readnum=0status=finished#TheSql27:selectdistinctbd_deptdoc.pk_deptdoc,deptcode,deptname,bd_deptdoc.pk_corp,null,pk_fathedept,nullfrombd_deptdocwhere1=1and(bd_deptdoc.pk_corp='1070')anddeptcode='61988'costtime=0readnum=0status=finished#TheSql28:selectdistinctbd_deptdoc.pk_deptdoc,deptcode,deptname,bd_deptdoc.pk_corp,null,pk_fathedept,nullfrombd_deptdocwhere1=1and(bd_deptdoc.pk_corp='1070')anddeptcode='61988'costtime=0readnum=0status=finished#TheSql29:selectdistinctbd_deptdoc.pk_deptdoc,deptcode,deptname,bd_deptdoc.pk_corp,null,pk_fathedept,nullfrombd_deptdocwhere1=1and(bd_deptdoc.pk_corp='1070')anddeptcode='61988'16costtime=0readnum=0status=finished#TheSql30:selectdistinctbd_cumandoc.pk_cubasdoc,custcode,custname,bd_cumandoc.pk_corp,bd_cubasdoc.pk_corp,null,bd_cubasdoc.pk_cubasdocfrombd_cumandoc,bd_cubasdocwhere1=1and(bd_cumandoc.pk_cubasdoc=bd_cubasdoc.pk_cubasdoc)and(bd_cumandoc.pk_corp='1070'orbd_cumandoc.pk_corp='0001')and(bd_cumandoc.custflag='0'orbd_cumandoc.custflag='2')andcustcode='600111'costtime=78readnum=0status=finished#TheSql31:selectdistinctbd_deptdoc.pk_deptdoc,deptcode,deptname,bd_deptdoc.pk_corp,null,pk_fathedept,nullfrombd_deptdocwhere1=1and(bd_deptdoc.pk_corp='1070')anddeptcode='61988'costtime=0readnum=0status=finished#TheSql32:selectdistinctbd_cumandoc.pk_cubasdoc,custcode,custname,bd_cumandoc.pk_corp,bd_cubasdoc.pk_corp,null,bd_cubasdoc.pk_cubasdocfrombd_cumandoc,bd_cubasdocwhere1=1and(bd_cumandoc.pk_cubasdoc=bd_cubasdoc.pk_cubasdoc)and(bd_cumandoc.pk_corp='1070'orbd_cumandoc.pk_corp='0001')and(bd_cumandoc.custflag='0'orbd_cumandoc.custflag='2')andcustcode='600111'17costtime=62readnum=0status=finished#TheSql33:selectdistinctbd_deptdoc.pk_deptdoc,deptcode,deptname,bd_deptdoc.pk_corp,null,pk_fathedept,nullfrombd_deptdocwhere1=1and(bd_deptdoc.pk_corp='1070')anddeptcode='61988'costtime=0readnum=0status=finished#TheSql34:selectdistinctbd_deptdoc.pk_deptdoc,deptcode,deptname,bd_deptdoc.pk_corp,null,pk_fathedept,nullfrombd_deptdocwhere1=1and(bd_deptdoc.pk_corp='1070')anddeptcode='61988'costtime=0readnum=0status=finished#TheSql35:selectdistinctbd_deptdoc.pk_deptdoc,deptcode,deptname,bd_deptdoc.pk_corp,null,pk_fathedept,nullfrombd_deptdocwhere1=1and(bd_deptdoc.pk_corp='1070')anddeptcode='61988'costtime=0readnum=0status=finished#TheSql36:18selectdistinctbd_cumandoc.pk_cubasdoc,custcode,custname,bd_cumandoc.pk_corp,bd_cubasdoc.pk_corp,null,bd_cubasdoc.pk_cubasdocfrombd_cumandoc,bd_cubasdocwhere1=1and(bd_cumandoc.pk_cubasdoc=bd_cubasdoc.pk_cubasdoc)and(bd_cumandoc.pk_corp='1070'orbd_cumandoc.pk_corp='0001')and(bd_cumandoc.custflag='0'orbd_cumandoc.custflag='2')andcustcode='600111'costtime=47readnum=0status=finished#TheSql37:selectdistinctbd_deptdoc.pk_deptdoc,deptcode,deptname,bd_deptdoc.pk_corp,null,pk_fathedept,nullfrombd_deptdocwhere1=1and(bd_deptdoc.pk_corp='1070')anddeptcode='61988'costtime=0readnum=0status=finished#TheSql38:selectdistinctbd_cumandoc.pk_cubasdoc,custcode,custname,bd_cumandoc.pk_corp,bd_cubasdoc.pk_corp,null,bd_cubasdoc.pk_cubasdocfrombd_cumandoc,bd_cubasdocwhere1=1and(bd_cumandoc.pk_cubasdoc=bd_cubasdoc.pk_cubasdoc)and(bd_cumandoc.pk_corp='1070'orbd_cumandoc.pk_corp='0001')and(bd_cumandoc.custflag='0'orbd_cumandoc.custflag='2')andcustcode='600111'costtime=78readnum=0status=finished#TheSql39:19selectdistinctbd_deptdoc.pk_deptdoc,deptcode,deptname,bd_deptdoc.pk_corp,null,pk_fathedept,nullfrombd_deptdocwhere1=1and(bd_deptdoc.pk_corp='1070')anddeptcode='61988'costtime=0readnum=0status=finished#TheSql40:selectdistinctbd_deptdoc.pk_deptdoc,deptcode,deptname,bd_deptdoc.pk_corp,null,pk_fathedept,nullfrombd_deptdocwhere1=1and(bd_deptdoc.pk_corp='1070')anddeptcode='61988'costtime=0readnum=0status=finished#TheSql41:selectdistinctbd_deptdoc.pk_deptdoc,deptcode,deptname,bd_deptdoc.pk_corp,null,pk_fathedept,nullfrombd_deptdocwhere1=1and(bd_deptdoc.pk_corp='1070')anddeptcode='61988'costtime=0readnum=0status=finished#TheSql42:selectdistinctbd_cumandoc.pk_cubasdoc,custcode,custname,bd_cumandoc.pk_corp,bd_cubasdoc.pk_corp,null,bd_cubasdoc.pk_cubasdocfrombd_cumandoc,bd_cubasdocwhere1=1and(bd_cumandoc.pk_cubasdoc=bd_cubasdoc.pk_cubasdoc)and(bd_cumandoc.pk_corp='1070'orbd_cumandoc.pk_corp='0001')and(bd_cumandoc.custflag='0'orbd_cumandoc.custflag='2')andcustcode='600111'20costtime=94readnum=0status=finished#TheSql43:selectdistinctbd_deptdoc.pk_deptdoc,deptcode,deptname,bd_deptdoc.pk_corp,null,pk_fathedept,nullfrombd_deptdocwhere1=1and(bd_deptdoc.pk_corp='1070')anddeptcode='61988'costtime=0readnum=0status=finished#TheSql44:selectdistinctbd_cumandoc.pk_cubasdoc,custcode,custname,bd_cumandoc.pk_corp,bd_cubasdoc.pk_corp,null,bd_cubasdoc.pk_cubasdocfrombd_cumandoc,bd_cubasdocwhere1=1and(bd_cumandoc.pk_cubasdoc=bd_cubasdoc.pk_cubasdoc)and(bd_cumandoc.pk_corp='1070'orbd_cumandoc.pk_corp='0001')and(bd_cumandoc.custflag='0'orbd_cumandoc.custflag='2')andcustcode='600111'costtime=47readnum=0status=finished#TheSql45:selectdistinctbd_deptdoc.pk_deptdoc,deptcode,deptname,bd_deptdoc.pk_corp,null,pk_fathedept,nullfrombd_deptdocwhere1=1and(bd_deptdoc.pk_corp='1070')anddeptcode='61988'costtime=0readnum=021status=finished#TheSql46:selectdistinctbd_deptdoc.pk_deptdoc,deptcode,deptname,bd_deptdoc.pk_corp,null,pk_fathedept,nullfrombd_deptdocwhere1=1and(bd_deptdoc.pk_corp='1070')anddeptcode='61988'costtime=0readnum=0status=finished#TheSql47:selectdistinctbd_deptdoc.pk_deptdoc,deptcode,deptname,bd_deptdoc.pk_corp,null,pk_fathedept,nullfrombd_deptdocwhere1=1and(bd_deptdoc.pk_corp='1070')anddeptcode='61988'costtime=0readnum=0status=finished#TheSql48:selectdistinctbd_cumandoc.pk_cubasdoc,custcode,custname,bd_cumandoc.pk_corp,bd_cubasdoc.pk_corp,null,bd_cubasdoc.pk_cubasdocfrombd_cumandoc,bd_cubasdocwhere1=1and(bd_cumandoc.pk_cubasdoc=bd_cubasdoc.pk_cubasdoc)and(bd_cumandoc.pk_corp='1070'orbd_cumandoc.pk_corp='0001')and(bd_cumandoc.custflag='0'orbd_cumandoc.custflag='2')andcustcode='600111'costtime=31readnum=0status=finished#TheSql49:22selectdistinctbd_deptdoc.pk_deptdoc,deptcode,deptname,bd_deptdoc.pk_corp,null,pk_fathedept,nullfrombd_deptdocwhere1=1and(bd_deptdoc.pk_corp='1070')anddeptcode='61988'costtime=0readnum=0status=finished==========thread=Thread-22status=WAITINGelapsetime=3539047operator=N/AremoteAddr=N/AremoteCallMethod=nc.bs.framework.cluster.impl.MessageEngine$MessageEngineDaemon@1deb1adsqlcosttime=0;readresulttime=0;readrownum=0;writetoclienttime=0;writetoclientbytes=0;readfromclientbytes=0;notclosedconnectioncount=0#threadstacksun.misc.Unsafe.park(NativeMethod)java.util.concurrent.locks.LockSupport.park(LockSupport.java:118)java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:1767)java.util.concurrent.ArrayBlockingQueue.take(ArrayBlockingQueue.java:341)nc.bs.framework.cluster.impl.ClusterMessageTopic.consume(ClusterMessageTopic.java:84)nc.bs.framework.cluster.impl.MessageProcessDaemon.run(MessageProcessDaemon.java:37)nc.bs.framework.execute.impl.ExecutorThread.run(ExecutorThread.java:30)23#sqlstatck:totalcosttime=0totalnumberofSql=0totalconnectionused=0==========thread=Thread-18status=TIMED_WAITINGelapsetime=3541172operator=N/AremoteAddr=N/AremoteCallMethod=NtbNavigateServicesqlcosttime=0;readresulttime=0;readrownum=0;writetoclienttime=0;writetoclientbytes=0;readfromclientbytes=0;notclosedconnectioncount=0#threadstackjava.lang.Thread.sleep(NativeMethod)nc.bs.ntb.pub.NtbNavigateService.run(NtbNavigateService.java:147)nc.bs.framework.execute.Executor.run(Executor.java:71)nc.bs.framework.execute.Executor$1.run(Executor.java:90)nc.bs.framework.execute.impl.ExecutorThread.run(ExecutorThread.java:30)#sqlstatck:totalcosttime=0totalnumberofSql=0totalconnectionused=0==========thread=Thread-55status=TIMED_WAITINGelapsetime=3400734operator=N/AremoteAddr=N/AremoteCallMethod=nc.bs.framework.execute.Executor$1@1137ff6sqlcosttime=0;readresulttime=0;readrownum=0;writetoclienttime=0;writetoclientbytes=0;readfromclientbytes=0;notclosedconnectioncount=024#threadstackjava.lang.Thread.sleep(NativeMethod)com.ufsoft.iufo.util.userrole.UserRoleFuncInfoCenter.run(UserRoleFuncInfoCenter.java:263)nc.bs.framework.execute.Executor$1.run(Executor.java:90)nc.bs.framework.execute.impl.ExecutorThread.run(ExecutorThread.java:30)#sqlstatck:totalcosttime=0totalnumberofSql=0totalconnectionused=0==========thread=Thread-4status=WAITINGelapsetime=3554594operator=N/AremoteAddr=N/AremoteCallMethod=nc.bs.framework.execute.Executor$1@1d1e765sqlcosttime=0;readresulttime=0;readrownum=0;writetoclienttime=0;writetoclientbytes=0;readfromclientbytes=0;notclosedconnectioncount=0#threadstackjava.lang.Object.wait(NativeMethod)java.lang.Object.wait(Object.java:474)nc.bs.uap.scheduler.impl.GuardedService$1.run(GuardedService.java:49)nc.bs.framework.execute.Executor$1.run(Executor.java:90)nc.bs.framework.execute.impl.ExecutorThread.run(ExecutorThread.java:30)#sqlstatck:totalcosttime=0totalnumberofSql=0totalconnectionused=025==========thread=Thread-12status=TIMED_WAITINGelapsetime=3551422operator=N/AremoteAddr=N/AremoteCallMethod=10.10.5.232:6400'sHeartbeatsqlcosttime=1269;readresulttime=0;readrownum=254;writetoclienttime=0;writetoclientbytes=0;readfromclientbytes=0;notclosedconnectioncount=0#threadstackjava.lang.Thread.sleep(NativeMethod)nc.bs.pub.clusterscheduler.HostService$2.run(HostService.java:127)nc.bs.framework.execute.Executor.run(Executor.java:71)nc.bs.framework.execute.Executor$1.run(Executor.java:90)nc.bs.framework.execute.impl.ExecutorThread.run(ExecutorThread.java:30)#sqlstatck:totalcosttime=1269totalnumberofSql=262totalconnectionused=1#TheSql0:SELECTparamId,paramName,paramValue,note,def1,def2FROMqdi_parameterWHEREparamIdin('scheduler_task_thread_num','scheduler_heartbeat_time','scheduler_host_timeouts','scheduler_temp_table_timeouts')costtime=0readnum=4status=finished#TheSql1:26SELECTparamId,paramName,paramValue,note,def1,def2FROMqdi_parameterWHEREparamId='perf_watch_running'costtime=15readnum=1status=finished#TheSql2:SELECTparamId,paramName,paramValue,note,def1,def2FROMqdi_parameterWHEREparamId='perf_watch_limit_elapsed_time'costtime=0readnum=1status=finished#TheSql3:SELECToid,tablename,dsName,tableType,dropFlag,activeTime,createTime,threadName,hostIdFROMqdi_temptablesWHEREdropflag=1or(activeTime+36000000<1364803703390)costtime=47readnum=3status=finished#TheSql4:selectcount(1)fromuser_viewswhereview_name='TEMQ_1886B8E13DC4A250DF'costtime=0readnum=1status=finished#TheSql5:27DELETEFROMqdi_temptablesWHEREoid='iufo_TEMQ_1886b8e13dc4a250df'costtime=16readnum=0status=finished#TheSql6:selectcount(1)fromuser_viewswhereview_name='TEMQ_1886B8E13DC4A35E19'costtime=0readnum=1status=finished#TheSql7:DELETEFROMqdi_temptablesWHEREoid='iufo_TEMQ_1886b8e13dc4a35e19'costtime=0readnum=0status=finished#TheSql8:selectcount(1)fromuser_viewswhereview_name='TEMQ_1886B8E13DC4A39AA5'costtime=0readnum=1status=finished#TheSql9:28DELETEFROMqdi_temptablesWHEREoid='iufo_TEMQ_1886b8e13dc4a39aa5'costtime=16readnum=0status=finished#TheSql10:SELECThostID,ip,port,servername,activetime,activeStatus,loadWeightFROMqdi_hostORDERBYactivetimedesccosttime=16readnum=1status=finished#TheSql11:updateqdi_hostsetts='2013-04-0116:10:25',activetime=nullwherehostID=nullcosttime=15readnum=0status=finished#TheSql12:updateqdi_modulessetts='2013-04-0116:10:25',hostid='10.10.5.232:6400'where((hostid='')or(hostidisnull)or(hostidnotin(selecthostidfromqdi_host)))and(hostsisnullorhosts=''or(hostslike'%10.10.5.232:6400%'))costtime=0readnum=0status=finished#TheSql13:29SELECTmoduleID,handlerClzName,hostID,hosts,priorty,loadWeightFROMqdi_modulesWHEREhostid='10.10.5.232:6400'costtime=16readnum=1status=finished#TheSql14:selectpk_job,name,timeconfigfromqdi_jobcosttime=0readnum=0status=finished#TheSql15:SELECTparamId,paramName,paramValue,note,def1,def2FROMqdi_parameterWHEREparamIdin('scheduler_task_thread_num','scheduler_heartbeat_time','scheduler_host_timeouts','scheduler_temp_table_timeouts')costtime=16readnum=4status=finished#TheSql16:SELECTparamId,paramName,paramValue,note,def1,def2FROMqdi_parameterWHEREparamId='perf_watch_running'costtime=0readnum=1status=finished#TheSql17:30SELECTparamId,paramName,paramValue,note,def1,def2FROMqdi_parameterWHEREparamId='perf_watch_limit_elapsed_time'costtime=0readnum=1status=finished#TheSql18:SELECToid,tablename,dsName,tableType,dropFlag,activeTime,createTime,threadName,hostIdFROMqdi_temptablesWHEREdropflag=1or(activeTime+36000000<1364803825250)costtime=15readnum=3status=finished#TheSql19:selectcount(1)fromuser_viewswhereview_name='TEMQ_1886B8E13DC4A3DBF3'costtime=16readnum=1status=finished#TheSql20:DELETEFROMqdi_temptablesWHEREoid='iufo_TEMQ_1886b8e13dc4a3dbf3'costtime=16readnum=0status=finished#TheSql21:31selectcount(1)fromuser_viewswhereview_name='TEMQ_1886B8E13DC4A45143'costtime=0readnum=1status=finished#TheSql22:DELETEFROMqdi_temptablesWHEREoid='iufo_TEMQ_1886b8e13dc4a45143'costtime=0readnum=0status=finished#TheSql23:selectcount(1)fromuser_viewswhereview_name='TEMQ_1886B8E13DC4A56562'costtime=0readnum=1status=finished#TheSql24:DELETEFROMqdi_temptablesWHEREoid='iufo_TEMQ_1886b8e13dc4a56562'costtime=15readnum=0status=finished#TheSql25:32SELECThostID,ip,port,servername,activetime,activeStatus,loadWeightFROMqdi_hostORDERBYactivetimedesccosttime=0readnum=1status=finished#TheSql26:updateqdi_hostsetts='2013-04-0116:12:26',activetime=nullwherehostID=nullcosttime=47readnum=0status=finished#TheSql27:updateqdi_modulessetts='2013-04-0116:12:26',hostid='10.10.5.232:6400'where((hostid='')or(hostidisnull)or(hostidnotin(selecthostidfromqdi_host)))and(hostsisnullorhosts=''or(hostslike'%10.10.5.232:6400%'))costtime=0readnum=0status=finished#TheSql28:SELECTmoduleID,handlerClzName,hostID,hosts,priorty,loadWeightFROMqdi_modulesWHEREhostid='10.10.5.232:6400'costtime=0readnum=1status=finished#TheSql29:33selectpk_job,name,timeconfigfromqdi_jobcosttime=16readnum=0status=finished#TheSql30:SELECTparamId,paramName,paramValue,note,def1,def2FROMqdi_parameterWHEREparamIdin('scheduler_task_thread_num','scheduler_heartbeat_time','scheduler_host_timeouts','scheduler_temp_table_timeouts')costtime=0readnum=4status=finished#TheSql31:SELECTparamId,paramName,paramValue,note,def1,def2FROMqdi_parameterWHEREparamId='perf_watch_running'costtime=0readnum=1status=finished#TheSql32:SELECTparamId,paramName,paramValue,note,def1,def2FROMqdi_parameterWHEREparamId='perf_watch_limit_elapsed_time'costtime=0readnum=1status=finished#TheSql33:34SELECToid,tablename,dsName,tableType,dropFlag,activeTime,createTime,threadName,hostIdFROMqdi_temptablesWHEREdropflag=1or(activeTime+36000000<1364803946125)costtime=0readnum=2status=finished#TheSql34:selectcount(1)fromuser_viewswhereview_name='TEMQ_1886B8E13DC4A601A2'costtime=31readnum=1status=finished#TheSql35:DELETEFROMqdi_temptablesWHEREoid='iufo_TEMQ_1886b8e13dc4a601a2'costtime=0readnum=0status=finished#TheSql36:selectcount(1)fromuser_viewswhereview_name='TEMQ_1886B8E13DC4A7018E'costtime=0readnum=1status=finished#TheSql37:35DELETEFROMqdi_temptablesWHEREoid='iufo_TEMQ_1886b8e13dc4a7018e'costtime=0readnum=0status=finished#TheSql38:SELECThostID,ip,port,servername,activetime,activeStatus,loadWeightFROMqdi_hostORDERBYactivetimedesccosttime=0readnum=1status=finished#TheSql39:updateqdi_hostsetts='2013-04-0116:14:26',activetime=nullwherehostID=nullcosttime=15readnum=0status=finished#TheSql40:updateqdi_modulessetts='2013-04-0116:14:26',hostid='10.10.5.232:6400'where((hostid='')or(hostidisnull)or(hostidnotin(selecthostidfromqdi_host)))and(hostsisnullorhosts=''or(hostslike'%10.10.5.232:6400%'))costtime=0readnum=0status=finished#TheSql41:36SELECTmoduleID,handlerClzName,hostID,hosts,priorty,loadWeightFROMqdi_modulesWHEREhostid='10.10.5.232:6400'costtime=0readnum=1status=finished#TheSql4...
