DB1昨日ARS慢日志累计数: 0 /var/log/mlog/db1/ars/20220324-slow.log DB1 ARS慢数据计数:0 慢数据前二十: DB1昨日DSSX慢日志累计数: 0 /var/log/mlog/db1/dssx/20220324-slow.log DB1 DSSX慢数据计数:0 慢数据前二十: DB1昨日KX慢日志累计数: 20775 /var/log/mlog/db1/kx/20220324-slow.log DB1 KX慢数据计数:80 慢数据前二十:namespace operation pattern count min (ms) max (ms) 95%-ile (ms) sum (ms) mean (ms) allowDiskUse dyf_cny.tag_search aggregate None 9833 101 379 n/a 1136540 115.6 None dyf_cny.course_character find {"cid": 1, "gid": 1} 3919 101 589 n/a 655907 167.4 None dyf_cny.user aggregate None 1851 101 18828 n/a 412099 222.6 None dyf_dssx_exam.dssx_count_info find {"plugin": 1, "result": 1, "status": 1} 720 253 747 n/a 380930 529.1 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} 17 783 19751 n/a 194922 11466.0 None dyf_cny.count_cs aggregate None 109 142 9528 n/a 188001 1724.8 None dyf_cny.count_warning find {"attrs.im.over24": 1, "handTime": 1, "handWay": 1, "status": 1, "tid": {"$ne": 1}} 191 742 1500 n/a 166415 871.3 None dyf_cny.course_character aggregate None 542 101 1371 n/a 156828 289.4 None dyf_cny.count_u_per aggregate None 63 152 4008 n/a 132872 2109.1 None dyf_cny.c_f update {"ALYKey": 1} 74 800 3600 n/a 118172 1596.9 None dyf_dssx_exam.dssx_count_info update {"finish": 1, "plugin": 1, "status": 1} 362 199 353 n/a 95688 264.3 None dyf_dssx_b2bkz.dssx_count_info find {"plugin": 1, "result": 1, "status": 1} 360 137 475 n/a 91068 253.0 None dyf_cny.c_f find {"ALYKey": 1, "status": 1} 65 121 2323 n/a 81295 1250.7 None dyf_cny.count_msg_info aggregate None 103 102 1642 n/a 76711 744.8 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} 8 5916 16049 n/a 72575 9071.9 None dyf_cny.es_exam aggregate None 79 102 5713 n/a 66186 837.8 None dyf_dssx_kjdsb2b.dssx_count_info find {"plugin": 1, "result": 1, "status": 1} 355 103 232 n/a 62712 176.7 None dyf_cny.count_course aggregate None 1 57133 57133 n/a 57133 57133.0 None dyf_cny.user count {"$or": [{"usr": {"$options": 1, "$regex": 1}}], "_id": {"$ne": 1}, "attrs.role.RCP_ADMIN": {"$ne": 1}, "status": 1, "type": 1} 8 6060 8897 n/a 56200 7025.0 None dyf_dssx_b2bkz.dssx_count_info update {"finish": 1, "plugin": 1, "status": 1} 359 101 185 n/a 47505 132.3 None +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ DB2昨日ARS慢日志累计数: 5892 /var/log/mlog/db2/ars/20220324-slow.log DB2 ARS慢数据计数:15 慢数据前二十:namespace operation pattern count min (ms) max (ms) 95%-ile (ms) sum (ms) mean (ms) allowDiskUse dyf_ars.ars_action aggregate None 809 101 50714 n/a 1452533 1795.5 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}]} 2062 135 326 n/a 405786 196.8 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}]} 1225 130 316 n/a 271097 221.3 None dyf_ars.ars_action_pv findandmodify {"cid": [{"used": 1, "val": 1}], "target": [{"used": 1, "val": 1}], "token": [{"used": 1, "val": 1}]} 668 158 322 n/a 137421 205.7 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}]} 656 142 313 n/a 129938 198.1 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}]} 177 151 257 n/a 34579 195.4 None dyf_ars.ars_action_pv findandmodify {"cid": [{"used": 1, "val": 1}], "target": [{"used": 1, "val": 1}]} 157 166 1009 n/a 31069 197.9 None dyf_ars.ars_action_pv findandmodify {"sign": [{"used": 1, "val": 1}], "url": [{"used": 1, "val": 1}]} 120 105 137 n/a 14624 121.9 None dyf_ars.ars_action_pv findandmodify {"hideReg": [{"used": 1, "val": 1}], "url": [{"used": 1, "val": 1}]} 2 141 851 n/a 992 496.0 None dyf_ars.ars_action_pv findandmodify {"classification": [{"used": 1, "val": 1}], "tag": [{"used": 1, "val": 1}]} 5 102 107 n/a 523 104.6 None dyf_ars.ars_learn_rate find {"aid": 1, "uid": 1} 2 124 143 n/a 267 133.5 None dyf_ars.ars_action_pv findandmodify {"classification": [{"used": 1, "val": 1}], "tags": [{"used": 1, "val": 1}]} 2 105 106 n/a 211 105.5 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 111 111 n/a 111 111.0 None dyf_ars.ars_action_pv findandmodify {"actId": [{"used": 1, "val": 1}], "sign": [{"used": 1, "val": 1}], "url": [{"used": 1, "val": 1}]} 1 108 108 n/a 108 108.0 None dyf_ars.ars_action_pv findandmodify {"classification": [{"used": 1, "val": 1}]} 1 104 104 n/a 104 104.0 None DB2昨日DSSX慢日志累计数: 0 /var/log/mlog/db2/dssx/20220324-slow.log DB2 DSSX慢数据计数:0 慢数据前二十: DB2昨日KX慢日志累计数: 4 /var/log/mlog/db2/kx/20220324-slow.log DB2 KX慢数据计数:0 慢数据前二十: +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ DB3昨日ARS慢日志累计数: 0 /var/log/mlog/db3/ars/20220324-slow.log DB3 ARS慢数据计数:0 慢数据前二十: DB3昨日DSSX慢日志累计数: 10567 /var/log/mlog/db3/dssx/20220324-slow.log DB3 DSSX慢数据计数:32 慢数据前二十:namespace operation pattern count min (ms) max (ms) 95%-ile (ms) sum (ms) mean (ms) allowDiskUse dyf_dssx.dssx_shipping_template aggregate None 3567 5746 13123 n/a 24949279 6994.5 None dyf_dssx.dssx_p4p_key find {"groupIdList": {"$elemMatch": 1}, "uidKey": 1} 1803 1191 2927 n/a 2835505 1572.7 None dyf_dssx.dssx_st_product count {"uid": 1} 3566 161 786 n/a 850619 238.5 None dyf_dssx.dssx_p4p_key aggregate None 288 1458 3184 n/a 510844 1773.8 None dyf_dssx.dssx_product aggregate None 217 101 5608 n/a 225333 1038.4 None dyf_dssx.dssx_product count {"$or": [{"keyword": {"$elemMatch": {"$options": 1, "$regex": 1}}}, {"productName": {"$options": 1, "$regex": 1}}], "putaway": 1, "visibility": 1} 29 2664 4385 n/a 96504 3327.7 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} 20 2736 4437 n/a 68934 3446.7 None dyf_dssx.dssx_count_info find {"plugin": 1, "result": 1, "status": 1} 288 200 334 n/a 68603 238.2 None dyf_dssx.dssx_p4p_rank_result aggregate None 100 196 2488 n/a 50139 501.4 None dyf_dssx.dssx_product find {"$or": [{"keyword": {"$elemMatch": {"$options": 1, "$regex": 1}}}, {"productName": {"$options": 1, "$regex": 1}}], "putaway": 1, "visibility": 1} 28 267 4009 n/a 41667 1488.1 None dyf_dssx.dssx_product find {"layeredCate.1": 1, "layeredCate.2": 1, "putaway": 1, "visibility": 1} 165 101 901 n/a 35236 213.6 None dyf_dssx.dssx_p4p_rank_result update {"kid": 1} 75 268 491 n/a 28249 376.7 None dyf_dssx.dssx_p4p_account find {"_id": 1} 77 284 389 n/a 24066 312.5 None dyf_dssx.dssx_product find {"category": {"$regex": 1}, "putaway": 1, "visibility": 1} 6 2763 3400 n/a 18716 3119.3 None dyf_dssx.dssx_product count {"category": {"$regex": 1}, "putaway": 1, "visibility": 1} 6 2129 2996 n/a 15644 2607.3 None dyf_dssx.dssx_p4p_key_info find {"create": 1, "grade": 1} 24 553 940 n/a 15503 646.0 None dyf_dssx.dssx_pop_store find {"publishTmpl": {"$ne": 1}} 74 101 209 n/a 9489 128.2 None dyf_dssx.dssx_cache_logistics_solution find {"cond.destinationCountry": 1, "cond.originZip": 1, "cond.packageInfo": 1, "cond.serviceType": 1, "serviceType": 1} 8 183 1520 n/a 5922 740.2 None dyf_dssx.dssx_product_update_record count {"attr.action": 1, "pid": 1} 26 192 313 n/a 5799 223.0 None dyf_dssx.dssx_p4p_key_high_score findandmodify {"key": 1, "owner": 1} 32 114 240 n/a 5694 177.9 None DB3昨日KX慢日志累计数: 0 /var/log/mlog/db3/kx/20220324-slow.log DB3 KX慢数据计数:0 慢数据前二十: