DB1昨日ARS慢日志累计数: 0 /var/log/mlog/db1/ars/20220310-slow.log DB1 ARS慢数据计数:0 慢数据前二十: DB1昨日DSSX慢日志累计数: 0 /var/log/mlog/db1/dssx/20220310-slow.log DB1 DSSX慢数据计数:0 慢数据前二十: DB1昨日KX慢日志累计数: 44568 /var/log/mlog/db1/kx/20220310-slow.log DB1 KX慢数据计数:96 慢数据前二十:namespace operation pattern count min (ms) max (ms) 95%-ile (ms) sum (ms) mean (ms) allowDiskUse dyf_cny.count_course aggregate None 11770 125 27043 n/a 2235764 190.0 None dyf_cny.course_character aggregate None 5736 101 3658 n/a 1986876 346.4 None dyf_cny.uas_group find {"_id": 1, "status": 1, "type": 1} 5050 138 760 n/a 1574848 311.9 None dyf_cny.tag_search aggregate None 11837 101 736 n/a 1376706 116.3 None dyf_cny.count_cs aggregate None 403 101 18328 n/a 696740 1728.9 None dyf_cny.course_character find {"cid": 1, "gid": 1} 3655 101 458 n/a 597287 163.4 None dyf_cny.count_u_per aggregate None 224 179 3690 n/a 478097 2134.4 None dyf_dssx_exam.dssx_count_info find {"plugin": 1, "result": 1, "status": 1} 720 261 847 n/a 388755 539.9 None dyf_cny.count_msg_info aggregate None 405 101 1744 n/a 373202 921.5 None dyf_cny.user aggregate None 831 101 16458 n/a 272276 327.6 None dyf_cny.count_warning find {"attrs.im.over24": 1, "handTime": 1, "handWay": 1, "status": 1, "tid": {"$ne": 1}} 192 751 1360 n/a 171497 893.2 None dyf_dssx_exam.dssx_count_info update {"finish": 1, "plugin": 1, "status": 1} 361 197 361 n/a 96971 268.6 None dyf_dssx_b2bkz.dssx_count_info find {"plugin": 1, "result": 1, "status": 1} 361 134 786 n/a 89518 248.0 None dyf_cny.c_f find {"ALYKey": 1, "status": 1} 64 103 1816 n/a 68312 1067.4 None dyf_cny.user find {"$and": [{"usr": {"$ne": 1}}], "$or": [{"usr": {"$options": 1, "$regex": 1}}], "_id": {"$ne": 1}, "attrs.role.RCP_ADMIN": {"$ne": 1}, "status": 1, "type": 1} 11 4780 6537 n/a 64256 5841.5 None dyf_cny.user count {"$or": [{"usr": {"$options": 1, "$regex": 1}}], "_id": {"$ne": 1}, "attrs.role.RCP_ADMIN": {"$ne": 1}, "status": 1, "type": 1} 11 5284 6135 n/a 63077 5734.3 None dyf_dssx_kjdsb2b.dssx_count_info find {"plugin": 1, "result": 1, "status": 1} 344 102 236 n/a 58027 168.7 None dyf_dssx_b2bkz.dssx_count_info update {"finish": 1, "plugin": 1, "status": 1} 360 101 181 n/a 45612 126.7 None dyf_cny.es_exam aggregate None 89 102 3702 n/a 43907 493.3 None dyf_cny.count_cst aggregate None 55 102 1120 n/a 33359 606.5 None +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ DB2昨日ARS慢日志累计数: 6343 /var/log/mlog/db2/ars/20220310-slow.log DB2 ARS慢数据计数:17 慢数据前二十:namespace operation pattern count min (ms) max (ms) 95%-ile (ms) sum (ms) mean (ms) allowDiskUse dyf_ars.ars_action aggregate None 881 101 51012 n/a 1736314 1970.8 None dyf_ars.ars_action_pv findandmodify {"aid": [{"used": 1, "val": 1}], "dl": [{"used": 1, "val": 1}], "fid": [{"used": 1, "val": 1}], "filename": [{"used": 1, "val": 1}], "ownerType": [{"used": 1, "val": 1}]} 2051 121 337 n/a 344997 168.2 None dyf_ars.ars_action_pv findandmodify {"aid": [{"used": 1, "val": 1}], "cid": [{"used": 1, "val": 1}], "count": [{"used": 1, "val": 1}], "credential": [{"used": 1, "val": 1}], "fid": [{"used": 1, "val": 1}], "mark": [{"used": 1, "val": 1}], "target": [{"used": 1, "val": 1}], "type": [{"used": 1, "val": 1}]} 1296 123 1434 n/a 234949 181.3 None dyf_ars.ars_action_pv findandmodify {"cid": [{"used": 1, "val": 1}], "target": [{"used": 1, "val": 1}], "token": [{"used": 1, "val": 1}]} 721 140 351 n/a 128450 178.2 None dyf_ars.ars_action_pv findandmodify {"aid": [{"used": 1, "val": 1}], "count": [{"used": 1, "val": 1}], "ext": [{"used": 1, "val": 1}], "fid": [{"used": 1, "val": 1}], "filename": [{"used": 1, "val": 1}], "mark": [{"used": 1, "val": 1}], "nowCount": [{"used": 1, "val": 1}], "ownerId": [{"used": 1, "val": 1}], "ownerType": [{"used": 1, "val": 1}], "target": [{"used": 1, "val": 1}]} 670 117 271 n/a 116928 174.5 None dyf_ars.ars_action_pv findandmodify {"sign": [{"used": 1, "val": 1}], "url": [{"used": 1, "val": 1}]} 426 101 137 n/a 48383 113.6 None dyf_ars.ars_action_pv findandmodify {"aid": [{"used": 1, "val": 1}], "dl": [{"used": 1, "val": 1}], "filename": [{"used": 1, "val": 1}], "mark": [{"used": 1, "val": 1}], "ownerId": [{"used": 1, "val": 1}], "ownerType": [{"used": 1, "val": 1}]} 230 120 241 n/a 37833 164.5 None dyf_ars.ars_action_pv findandmodify {"cid": [{"used": 1, "val": 1}], "target": [{"used": 1, "val": 1}]} 49 153 398 n/a 8634 176.2 None dyf_ars.ars_action_pv findandmodify {"host": [{"used": 1, "val": 1}], "source": [{"used": 1, "val": 1}]} 2 190 1737 n/a 1927 963.5 None dyf_ars.ars_action_pv findandmodify None 1 487 487 n/a 487 487.0 None dyf_ars.ars_action_pv findandmodify {"aid": [{"used": 1, "val": 1}], "dl": [{"used": 1, "val": 1}], "fid": [{"used": 1, "val": 1}], "filename": [{"used": 1, "val": 1}], "ownerType": [{"used": 1, "val": 1}], "token": [{"used": 1, "val": 1}]} 3 138 180 n/a 474 158.0 None dyf_ars.ars_action_pv findandmodify {"hideReg": [{"used": 1, "val": 1}], "url": [{"used": 1, "val": 1}]} 3 119 181 n/a 420 140.0 None dyf_ars.ars_action_pv findandmodify {"aid": [{"used": 1, "val": 1}], "count": [{"used": 1, "val": 1}], "ext": [{"used": 1, "val": 1}], "fid": [{"used": 1, "val": 1}], "ownerType": [{"used": 1, "val": 1}], "target": [{"used": 1, "val": 1}], "token": [{"used": 1, "val": 1}], "type": [{"used": 1, "val": 1}]} 1 200 200 n/a 200 200.0 None dyf_ars.ars_action_pv findandmodify {"aid": [{"used": 1, "val": 1}], "dl": [{"used": 1, "val": 1}], "fid": [{"used": 1, "val": 1}], "filename": [{"used": 1, "val": 1}], "ownertype": [{"used": 1, "val": 1}]} 1 186 186 n/a 186 186.0 None dyf_ars.ars_learn_rate find {"aid": 1, "uid": 1} 1 115 115 n/a 115 115.0 None dyf_ars.ars_action_pv findandmodify {"aid": [{"used": 1, "val": 1}], "cid": [{"used": 1, "val": 1}], "gid": [{"used": 1, "val": 1}], "stuIds": [{"used": 1, "val": 1}], "tag": [{"used": 1, "val": 1}], "tid": [{"used": 1, "val": 1}], "type": [{"used": 1, "val": 1}]} 1 113 113 n/a 113 113.0 None dyf_ars.ars_action_pv findandmodify {"actId": [{"used": 1, "val": 1}], "sign": [{"used": 1, "val": 1}], "url": [{"used": 1, "val": 1}]} 1 105 105 n/a 105 105.0 None DB2昨日DSSX慢日志累计数: 0 /var/log/mlog/db2/dssx/20220310-slow.log DB2 DSSX慢数据计数:0 慢数据前二十: DB2昨日KX慢日志累计数: 4 /var/log/mlog/db2/kx/20220310-slow.log DB2 KX慢数据计数:0 慢数据前二十: +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ DB3昨日ARS慢日志累计数: 0 /var/log/mlog/db3/ars/20220310-slow.log DB3 ARS慢数据计数:0 慢数据前二十: DB3昨日DSSX慢日志累计数: 5084 /var/log/mlog/db3/dssx/20220310-slow.log DB3 DSSX慢数据计数:27 慢数据前二十:namespace operation pattern count min (ms) max (ms) 95%-ile (ms) sum (ms) mean (ms) allowDiskUse dyf_dssx.dssx_shipping_template aggregate None 1900 5131 11974 n/a 11846802 6235.2 None dyf_dssx.dssx_p4p_key aggregate None 288 1398 2261 n/a 486756 1690.1 None dyf_dssx.dssx_st_product count {"uid": 1} 1900 152 645 n/a 382753 201.4 None dyf_dssx.dssx_product aggregate None 176 101 4468 n/a 176783 1004.4 None dyf_dssx.dssx_product count {"$or": [{"keyword": {"$elemMatch": {"$options": 1, "$regex": 1}}}, {"productName": {"$options": 1, "$regex": 1}}], "putaway": 1, "visibility": 1} 24 1678 3767 n/a 70936 2955.7 None dyf_dssx.dssx_count_info find {"plugin": 1, "result": 1, "status": 1} 288 193 273 n/a 65471 227.3 None dyf_dssx.dssx_p4p_rank_result aggregate None 62 204 1157 n/a 27587 445.0 None dyf_dssx.dssx_product find {"layeredCate.1": 1, "layeredCate.2": 1, "putaway": 1, "visibility": 1} 130 101 679 n/a 26805 206.2 None dyf_dssx.dssx_p4p_account find {"_id": 1} 88 258 419 n/a 26640 302.7 None dyf_dssx.dssx_product find {"$or": [{"keyword": {"$elemMatch": {"$options": 1, "$regex": 1}}}, {"productName": {"$options": 1, "$regex": 1}}], "putaway": 1, "visibility": 1} 24 205 2880 n/a 20440 851.7 None dyf_dssx.dssx_p4p_key find {"groupIdList": {"$elemMatch": 1}, "uidKey": 1} 15 1147 1524 n/a 20088 1339.2 None dyf_dssx.dssx_product count {"$or": [{"keyword": {"$elemMatch": {"$options": 1, "$regex": 1}}}, {"productName": {"$options": 1, "$regex": 1}}], "_id": {"$nin": 1}, "putaway": 1, "visibility": 1} 7 2118 3461 n/a 17970 2567.1 None dyf_dssx.dssx_p4p_key_info find {"create": 1, "grade": 1} 24 507 653 n/a 13480 561.7 None dyf_dssx.dssx_p4p_key_high_score findandmodify {"key": 1, "owner": 1} 37 112 361 n/a 7101 191.9 None dyf_dssx.dssx_pop_store find {"publishTmpl": {"$ne": 1}} 53 101 259 n/a 6539 123.4 None dyf_dssx.dssx_pop_store count {"publishTmpl": {"$ne": 1}} 24 120 226 n/a 3746 156.1 None dyf_dssx.dssx_cache_logistics_solution find {"cond.destinationCountry": 1, "cond.originZip": 1, "cond.packageInfo": 1, "cond.serviceType": 1, "serviceType": 1} 4 294 1279 n/a 3241 810.2 None dyf_dssx.dssx_product find {"$or": [{"keyword": {"$elemMatch": {"$options": 1, "$regex": 1}}}, {"productName": {"$options": 1, "$regex": 1}}], "_id": {"$nin": 1}, "putaway": 1, "visibility": 1} 4 119 747 n/a 1377 344.2 None dyf_dssx.dssx_st_product query {"sid": {"$eq": 1}} 2 198 298 n/a 496 248.0 None dyf_dssx.dssx_account find {"uid": 1} 1 485 485 n/a 485 485.0 None DB3昨日KX慢日志累计数: 5 /var/log/mlog/db3/kx/20220310-slow.log DB3 KX慢数据计数:4 慢数据前二十:namespace operation pattern count min (ms) max (ms) 95%-ile (ms) sum (ms) mean (ms) allowDiskUse dyf_cny.user find {"attrs.certfication.idCardNo": 1} 2 3279 7125 n/a 10404 5202.0 None dyf_cny.user find {"usr.attrs.idCardNo": 1} 1 3349 3349 n/a 3349 3349.0 None dyf_cny.user find {"attrs.certifation.idCardNo": 1} 1 3299 3299 n/a 3299 3299.0 None dyf_cny.user find {"attrs.certifaction.idCardNo": 1} 1 3186 3186 n/a 3186 3186.0 None