DB1昨日ARS慢日志累计数: 1 /var/log/mlog/db1/ars/20220325-slow.log DB1 ARS慢数据计数:0 慢数据前二十: DB1昨日DSSX慢日志累计数: 0 /var/log/mlog/db1/dssx/20220325-slow.log DB1 DSSX慢数据计数:0 慢数据前二十: DB1昨日KX慢日志累计数: 3120 /var/log/mlog/db1/kx/20220325-slow.log DB1 KX慢数据计数:48 慢数据前二十:namespace operation pattern count min (ms) max (ms) 95%-ile (ms) sum (ms) mean (ms) allowDiskUse dyf_cny.user aggregate None 1806 101 8224 n/a 333584 184.7 None dyf_cny.es_exam aggregate None 52 109 16146 n/a 91221 1754.2 None dyf_cny.c_f find {"ALYKey": 1, "status": 1} 66 104 1870 n/a 75176 1139.0 None dyf_dssx_exam.dssx_count_info find {"plugin": 1, "result": 1, "status": 1} 86 289 1500 n/a 50390 585.9 None dyf_cny.count_course aggregate None 1 43317 43317 n/a 43317 43317.0 None dyf_cny.tag_search aggregate None 343 101 632 n/a 40426 117.9 None dyf_cny.es_exam find {"answers.answer.ctime": 1} 2 18761 18997 n/a 37758 18879.0 None dyf_cny.course_character aggregate None 100 103 1457 n/a 33672 336.7 None dyf_cny.count_warning find {"attrs.im.over24": 1, "handTime": 1, "handWay": 1, "status": 1, "tid": {"$ne": 1}} 20 791 1730 n/a 19258 962.9 None dyf_cny.course_character find {"cid": 1, "gid": 1} 37 151 855 n/a 15959 431.3 None dyf_dssx_exam.dssx_count_info update {"finish": 1, "plugin": 1, "status": 1} 43 245 371 n/a 12445 289.4 None dyf_dssx_b2bkz.dssx_count_info find {"plugin": 1, "result": 1, "status": 1} 43 138 324 n/a 10968 255.1 None dyf_dssx_kjdsb2b.dssx_count_info find {"plugin": 1, "result": 1, "status": 1} 40 103 246 n/a 7328 183.2 None dyf_cny.count_course findandmodify {"_id": 1} 26 141 464 n/a 7296 280.6 None dyf_dssx_b2bkz.dssx_count_info update {"finish": 1, "plugin": 1, "status": 1} 43 109 154 n/a 5554 129.2 None dyf_cny.count_course update {"_id": 1} 2 255 5244 n/a 5499 2749.5 None dyf_cny.tag_search findandmodify {"group": 1, "host": 1, "name": 1, "source": 1, "tag": 1, "time": 1} 43 101 121 n/a 4640 107.9 None dyf_cny.dms_discuss aggregate None 15 104 347 n/a 4280 285.3 None dyf_cny.count_cs findandmodify {"cid": 1, "sid": 1, "time": 1} 6 385 1109 n/a 3549 591.5 None dyf_cny.msg aggregate None 8 349 504 n/a 3098 387.2 None +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ DB2昨日ARS慢日志累计数: 3902 /var/log/mlog/db2/ars/20220325-slow.log DB2 ARS慢数据计数:24 慢数据前二十:namespace operation pattern count min (ms) max (ms) 95%-ile (ms) sum (ms) mean (ms) allowDiskUse dyf_ars.ars_action aggregate None 586 101 27515 n/a 1940736 3311.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}]} 1101 137 1081 n/a 222752 202.3 None dyf_ars.ars_action_pv findandmodify {"cid": [{"used": 1, "val": 1}], "target": [{"used": 1, "val": 1}], "token": [{"used": 1, "val": 1}]} 727 158 608 n/a 156506 215.3 None dyf_ars.ars_action_pv findandmodify {"cid": [{"used": 1, "val": 1}], "target": [{"used": 1, "val": 1}]} 336 167 2405 n/a 123444 367.4 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}]} 523 149 1138 n/a 116825 223.4 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}]} 269 144 2765 n/a 57256 212.8 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}]} 103 166 259 n/a 21353 207.3 None dyf_ars.ars_action_pv findandmodify {"sign": [{"used": 1, "val": 1}], "url": [{"used": 1, "val": 1}]} 78 102 463 n/a 10257 131.5 None dyf_ars.ars_action_pv findandmodify None 9 102 2204 n/a 4107 456.3 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}]} 26 101 324 n/a 3241 124.7 None dyf_ars.ars_action_pv findandmodify {"host": [{"used": 1, "val": 1}], "source": [{"used": 1, "val": 1}]} 13 101 243 n/a 1924 148.0 None dyf_ars.ars_action_pv findandmodify {"code": [{"used": 1, "val": 1}], "state": [{"used": 1, "val": 1}]} 5 111 640 n/a 1526 305.2 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}]} 4 205 219 n/a 851 212.8 None dyf_ars.ars_action_pv findandmodify {"type": [{"used": 1, "val": 1}]} 2 109 312 n/a 421 210.5 None dyf_ars.ars_action_pv findandmodify {"cid": [{"used": 1, "val": 1}], "unpf": [{"used": 1, "val": 1}]} 1 410 410 n/a 410 410.0 None dyf_ars.ars_action_pv findandmodify {"uc_sm": [{"used": 1, "val": 1}]} 1 334 334 n/a 334 334.0 None dyf_ars.ars_learn_rate find {"aid": 1, "uid": 1} 2 148 158 n/a 306 153.0 None dyf_ars.ars_action_pv findandmodify {"actId": [{"used": 1, "val": 1}], "cid": [{"used": 1, "val": 1}]} 2 117 125 n/a 242 121.0 None dyf_ars.ars_action_pv findandmodify {"cid": [{"used": 1, "val": 1}], "token": [{"used": 1, "val": 1}], "type": [{"used": 1, "val": 1}]} 1 190 190 n/a 190 190.0 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}], "token": [{"used": 1, "val": 1}]} 1 169 169 n/a 169 169.0 None DB2昨日DSSX慢日志累计数: 0 /var/log/mlog/db2/dssx/20220325-slow.log DB2 DSSX慢数据计数:0 慢数据前二十: DB2昨日KX慢日志累计数: 27624 /var/log/mlog/db2/kx/20220325-slow.log DB2 KX慢数据计数:88 慢数据前二十:namespace operation pattern count min (ms) max (ms) 95%-ile (ms) sum (ms) mean (ms) allowDiskUse dyf_cny.count_course aggregate None 11803 101 3089 n/a 2215204 187.7 None dyf_cny.uas_group find {"_id": 1, "status": 1, "type": 1} 3673 101 1104 n/a 1080011 294.0 None dyf_cny.tag_search aggregate None 8130 101 159 n/a 938006 115.4 None dyf_dssx_exam.dssx_count_info find {"plugin": 1, "result": 1, "status": 1} 636 267 746 n/a 334348 525.7 None dyf_cny.user find {"$and": [{"attrs.basic.nickName": {"$ne": 1}}, {"attrs.certification.realName": {"$ne": 1}}], "$or": [{"$or": [{"searchMata.name": {"$options": 1, "$regex": 1}}]}, {"$or": [{"attrs.privated.phone": 1}]}], "_id": {"$ne": 1}, "attrs.role.RCP_ADMIN": {"$ne": 1}, "status": 1} 43 5353 20523 n/a 270406 6288.5 None dyf_cny.count_cs aggregate None 95 112 6240 n/a 127448 1341.6 None dyf_cny.c_f update {"ALYKey": 1} 70 1259 2785 n/a 114766 1639.5 None dyf_cny.user count {"$or": [{"$or": [{"attrs.basic.nickName": {"$options": 1, "$regex": 1}}, {"attrs.certification.realName": {"$options": 1, "$regex": 1}}]}, {"$or": [{"attrs.privated.phone": 1}]}], "_id": {"$ne": 1}, "attrs.role.RCP_ADMIN": {"$ne": 1}, "status": 1} 43 2246 10006 n/a 111940 2603.3 None dyf_cny.count_warning find {"attrs.im.over24": 1, "handTime": 1, "handWay": 1, "status": 1, "tid": {"$ne": 1}} 105 776 3037 n/a 90269 859.7 None dyf_dssx_exam.dssx_count_info update {"finish": 1, "plugin": 1, "status": 1} 320 192 329 n/a 84073 262.7 None dyf_dssx_b2bkz.dssx_count_info find {"plugin": 1, "result": 1, "status": 1} 318 121 354 n/a 79058 248.6 None dyf_cny.count_u_per aggregate None 47 108 3601 n/a 70159 1492.7 None dyf_cny.count_msg_info aggregate None 95 102 2509 n/a 63949 673.1 None dyf_dssx_kjdsb2b.dssx_count_info find {"plugin": 1, "result": 1, "status": 1} 309 102 232 n/a 54416 176.1 None dyf_cny.course_character aggregate None 274 101 1175 n/a 44425 162.1 None dyf_dssx_b2bkz.dssx_count_info update {"finish": 1, "plugin": 1, "status": 1} 316 106 206 n/a 42914 135.8 None dyf_cny.c_f find {"ALYKey": 1} 28 1298 1721 n/a 42435 1515.5 None dyf_cny.c_f findandmodify {"ALYKey": 1} 14 1310 2163 n/a 24120 1722.9 None dyf_cny.user aggregate None 1 15820 15820 n/a 15820 15820.0 None dyf_cny.r_mid find {"$or": [{"lid": 1, "rid": {"$regex": 1}}, {"rid": 1}], "ignore": {"$ne": 1}} 26 248 486 n/a 8165 314.0 None +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ DB3昨日ARS慢日志累计数: 0 /var/log/mlog/db3/ars/20220325-slow.log DB3 ARS慢数据计数:0 慢数据前二十: DB3昨日DSSX慢日志累计数: 5580 /var/log/mlog/db3/dssx/20220325-slow.log DB3 DSSX慢数据计数:29 慢数据前二十:namespace operation pattern count min (ms) max (ms) 95%-ile (ms) sum (ms) mean (ms) allowDiskUse dyf_dssx.dssx_shipping_template aggregate None 1689 5762 12316 n/a 11770613 6969.0 None dyf_dssx.dssx_p4p_key find {"groupIdList": {"$elemMatch": 1}, "uidKey": 1} 539 1150 3865 n/a 781194 1449.3 None dyf_dssx.dssx_p4p_key aggregate None 288 1426 3507 n/a 504990 1753.4 None dyf_dssx.dssx_st_product count {"uid": 1} 1689 184 1412 n/a 427639 253.2 None dyf_dssx.dssx_product aggregate None 195 101 6390 n/a 225986 1158.9 None dyf_dssx.dssx_product count {"$or": [{"keyword": {"$elemMatch": {"$options": 1, "$regex": 1}}}, {"productName": {"$options": 1, "$regex": 1}}], "putaway": 1, "visibility": 1} 61 2221 5565 n/a 211723 3470.9 None dyf_dssx.dssx_p4p_rank_result aggregate None 152 196 2614 n/a 74715 491.5 None dyf_dssx.dssx_count_info find {"plugin": 1, "result": 1, "status": 1} 288 201 628 n/a 70113 243.4 None dyf_dssx.dssx_product find {"$or": [{"keyword": {"$elemMatch": {"$options": 1, "$regex": 1}}}, {"productName": {"$options": 1, "$regex": 1}}], "putaway": 1, "visibility": 1} 61 244 4900 n/a 68431 1121.8 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} 14 2281 5631 n/a 56651 4046.5 None dyf_dssx.dssx_product find {"layeredCate.1": 1, "layeredCate.2": 1, "putaway": 1, "visibility": 1} 216 101 908 n/a 45519 210.7 None dyf_dssx.dssx_pop_store find {"publishTmpl": {"$ne": 1}} 115 101 1120 n/a 25732 223.8 None dyf_dssx.dssx_p4p_account find {"_id": 1} 80 266 367 n/a 24599 307.5 None dyf_dssx.dssx_pop_store count {"publishTmpl": {"$ne": 1}} 24 159 3401 n/a 24451 1018.8 None dyf_dssx.dssx_p4p_key_info find {"create": 1, "grade": 1} 24 557 1363 n/a 18177 757.4 None dyf_dssx.dssx_p4p_rank_result update {"kid": 1} 17 294 505 n/a 6256 368.0 None dyf_dssx.dssx_cache_logistics_solution find {"cond.destinationCountry": 1, "cond.originZip": 1, "cond.packageInfo": 1, "cond.serviceType": 1, "serviceType": 1} 8 108 1461 n/a 4736 592.0 None dyf_dssx.dssx_product count {"category": {"$regex": 1}, "putaway": 1, "visibility": 1} 1 3066 3066 n/a 3066 3066.0 None dyf_dssx.dssx_p4p_key_high_score findandmodify {"key": 1, "owner": 1} 15 107 147 n/a 2021 134.7 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} 9 113 653 n/a 1913 212.6 None DB3昨日KX慢日志累计数: 5 /var/log/mlog/db3/kx/20220325-slow.log DB3 KX慢数据计数:0 慢数据前二十: