DB1昨日ARS慢日志累计数: 0 /var/log/mlog/db1/ars/20220407-slow.log DB1 ARS慢数据计数:0 慢数据前二十: DB1昨日DSSX慢日志累计数: 0 /var/log/mlog/db1/dssx/20220407-slow.log DB1 DSSX慢数据计数:0 慢数据前二十: DB1昨日KX慢日志累计数: 18461 /var/log/mlog/db1/kx/20220407-slow.log DB1 KX慢数据计数:80 慢数据前二十:namespace operation pattern count min (ms) max (ms) 95%-ile (ms) sum (ms) mean (ms) allowDiskUse dyf_cny.uas_group find {"_id": 1, "status": 1, "type": 1} 3835 140 446 n/a 1023359 266.8 None dyf_cny.tag_search aggregate None 7654 101 160 n/a 869597 113.6 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} 69 1920 8841 n/a 426567 6182.1 None dyf_dssx_exam.dssx_count_info find {"plugin": 1, "result": 1, "status": 1} 722 270 756 n/a 390258 540.5 None dyf_cny.user aggregate None 1823 101 3319 n/a 326041 178.8 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} 69 2149 4206 n/a 205337 2975.9 None dyf_cny.count_cs aggregate None 201 107 10299 n/a 195019 970.2 None dyf_cny.count_warning find {"attrs.im.over24": 1, "handTime": 1, "handWay": 1, "status": 1, "tid": {"$ne": 1}} 191 735 1218 n/a 161539 845.8 None dyf_cny.user count {"$or": [{"$or": [{"attrs.basic.nickName": {"$options": 1, "$regex": 1}}, {"account": {"$options": 1, "$regex": 1}}]}, {"$or": [{"attrs.privated.phone": 1}]}], "_id": {"$ne": 1}, "attrs.role.RCP_ADMIN": {"$ne": 1}, "status": 1, "type": 1} 18 4499 6865 n/a 104266 5792.6 None dyf_cny.count_u_per aggregate None 91 149 3629 n/a 94428 1037.7 None dyf_dssx_exam.dssx_count_info update {"finish": 1, "plugin": 1, "status": 1} 363 187 350 n/a 94368 260.0 None dyf_dssx_b2bkz.dssx_count_info find {"plugin": 1, "result": 1, "status": 1} 361 121 368 n/a 92609 256.5 None dyf_cny.count_msg_info aggregate None 213 103 1496 n/a 82619 387.9 None dyf_cny.course_character aggregate None 300 101 1401 n/a 78337 261.1 None dyf_cny.c_f find {"ALYKey": 1, "status": 1} 67 104 1932 n/a 77353 1154.5 None dyf_dssx_kjdsb2b.dssx_count_info find {"plugin": 1, "result": 1, "status": 1} 346 101 270 n/a 62881 181.7 None dyf_cny.user find {"$and": [{"attrs.basic.nickName": {"$ne": 1}}, {"account": {"$ne": 1}}], "$or": [{"$or": [{"searchMata.accountName": {"$options": 1, "$regex": 1}}]}, {"$or": [{"attrs.privated.phone": 1}]}], "_id": {"$ne": 1}, "attrs.role.RCP_ADMIN": {"$ne": 1}, "status": 1, "type": 1} 16 3108 4206 n/a 58508 3656.8 None dyf_cny.es_exam aggregate None 66 107 3686 n/a 51672 782.9 None dyf_dssx_b2bkz.dssx_count_info update {"finish": 1, "plugin": 1, "status": 1} 361 103 187 n/a 47716 132.2 None dyf_cny.count_course aggregate None 22 114 32313 n/a 43287 1967.6 None +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ DB2昨日ARS慢日志累计数: 5941 /var/log/mlog/db2/ars/20220407-slow.log DB2 ARS慢数据计数:25 慢数据前二十:namespace operation pattern count min (ms) max (ms) 95%-ile (ms) sum (ms) mean (ms) allowDiskUse dyf_ars.ars_action aggregate None 667 102 30905 n/a 1789540 2683.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}]} 2020 146 1811 n/a 470387 232.9 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}]} 1026 176 3681 n/a 269265 262.4 None dyf_ars.ars_action_pv findandmodify {"cid": [{"used": 1, "val": 1}], "target": [{"used": 1, "val": 1}], "token": [{"used": 1, "val": 1}]} 632 196 1111 n/a 175704 278.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}], "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}]} 726 154 1344 n/a 170163 234.4 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}]} 335 170 312 n/a 78796 235.2 None dyf_ars.ars_action_pv findandmodify {"cid": [{"used": 1, "val": 1}], "target": [{"used": 1, "val": 1}]} 208 186 2070 n/a 70911 340.9 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}]} 102 101 610 n/a 11977 117.4 None dyf_ars.ars_action_pv findandmodify {"sign": [{"used": 1, "val": 1}], "url": [{"used": 1, "val": 1}]} 71 108 504 n/a 10614 149.5 None dyf_ars.ars_action_pv findandmodify {"host": [{"used": 1, "val": 1}], "source": [{"used": 1, "val": 1}]} 21 102 1631 n/a 5676 270.3 None dyf_ars.ars_action_pv findandmodify {"type": [{"used": 1, "val": 1}]} 4 165 1461 n/a 2585 646.2 None dyf_ars.ars_action_pv findandmodify {"code": [{"used": 1, "val": 1}], "state": [{"used": 1, "val": 1}]} 6 115 577 n/a 1423 237.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 181 239 n/a 841 210.2 None dyf_ars.ars_action_pv findandmodify None 3 108 274 n/a 585 195.0 None dyf_ars.ars_action_pv findandmodify {"id": [{"used": 1, "val": 1}], "token": [{"used": 1, "val": 1}]} 1 450 450 n/a 450 450.0 None dyf_ars.ars_action_pv findandmodify {"_method": [{"used": 1, "val": 1}], "filter[]": [{"used": 1, "val": 1}], "get[]": [{"used": 1, "val": 1}], "method": [{"used": 1, "val": 1}], "s": [{"used": 1, "val": 1}]} 1 449 449 n/a 449 449.0 None dyf_ars.ars_action_pv findandmodify {"entryScene": [{"used": 1, "val": 1}], "jump_from": [{"used": 1, "val": 1}]} 1 422 422 n/a 422 422.0 None dyf_ars.ars_action_pv findandmodify {"actId": [{"used": 1, "val": 1}], "sign": [{"used": 1, "val": 1}], "url": [{"used": 1, "val": 1}]} 3 114 130 n/a 369 123.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 244 244 n/a 244 244.0 None dyf_ars.ars_learn_rate find {"aid": 1, "uid": 1} 2 104 118 n/a 222 111.0 None DB2昨日DSSX慢日志累计数: 0 /var/log/mlog/db2/dssx/20220407-slow.log DB2 DSSX慢数据计数:0 慢数据前二十: DB2昨日KX慢日志累计数: 0 /var/log/mlog/db2/kx/20220407-slow.log DB2 KX慢数据计数:0 慢数据前二十: +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ DB3昨日ARS慢日志累计数: 0 /var/log/mlog/db3/ars/20220407-slow.log DB3 ARS慢数据计数:0 慢数据前二十: DB3昨日DSSX慢日志累计数: 8517 /var/log/mlog/db3/dssx/20220407-slow.log DB3 DSSX慢数据计数:30 慢数据前二十:namespace operation pattern count min (ms) max (ms) 95%-ile (ms) sum (ms) mean (ms) allowDiskUse dyf_dssx.dssx_shipping_template aggregate None 3261 6106 18668 n/a 29565008 9066.2 None dyf_dssx.dssx_st_product count {"uid": 1} 3261 179 1553 n/a 1041699 319.4 None dyf_dssx.dssx_p4p_key aggregate None 288 1359 5393 n/a 495307 1719.8 None dyf_dssx.dssx_p4p_key find {"groupIdList": {"$elemMatch": 1}, "uidKey": 1} 263 1166 3712 n/a 414021 1574.2 None dyf_dssx.dssx_product aggregate None 236 101 8251 n/a 267190 1132.2 None dyf_dssx.dssx_product count {"$or": [{"keyword": {"$elemMatch": {"$options": 1, "$regex": 1}}}, {"productName": {"$options": 1, "$regex": 1}}], "putaway": 1, "visibility": 1} 44 2261 7673 n/a 164282 3733.7 None dyf_dssx.dssx_count_info find {"plugin": 1, "result": 1, "status": 1} 287 204 571 n/a 70965 247.3 None dyf_dssx.dssx_product find {"layeredCate.1": 1, "layeredCate.2": 1, "putaway": 1, "visibility": 1} 268 101 654 n/a 50100 186.9 None dyf_dssx.dssx_p4p_rank_result aggregate None 110 182 1538 n/a 49397 449.1 None dyf_dssx.dssx_product find {"$or": [{"keyword": {"$elemMatch": {"$options": 1, "$regex": 1}}}, {"productName": {"$options": 1, "$regex": 1}}], "putaway": 1, "visibility": 1} 44 284 3451 n/a 43552 989.8 None dyf_dssx.dssx_pop_store find {"publishTmpl": {"$ne": 1}} 144 101 1376 n/a 43311 300.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} 11 2660 4755 n/a 40313 3664.8 None dyf_dssx.dssx_p4p_account find {"_id": 1} 94 261 756 n/a 30506 324.5 None dyf_dssx.dssx_pop_store count {"publishTmpl": {"$ne": 1}} 24 176 4040 n/a 28038 1168.2 None dyf_dssx.dssx_p4p_key_info find {"create": 1, "grade": 1} 24 588 1541 n/a 19531 813.8 None dyf_dssx.dssx_cache_logistics_solution find {"cond.destinationCountry": 1, "cond.originZip": 1, "cond.packageInfo": 1, "cond.serviceType": 1, "serviceType": 1} 8 143 1900 n/a 8046 1005.8 None dyf_dssx.dssx_product count {"category": {"$regex": 1}, "putaway": 1, "visibility": 1} 1 3710 3710 n/a 3710 3710.0 None dyf_dssx.dssx_p4p_rank_result update {"kid": 1} 10 312 463 n/a 3602 360.2 None dyf_dssx.dssx_p4p_key_high_score findandmodify {"key": 1, "owner": 1} 17 107 116 n/a 1897 111.6 None dyf_dssx.dssx_p4p_key_high_score count {"$or": [{"grade": 1}, {"grade": 1}, {"grade": 1}, {"grade": 1}, {"grade": 1}, {"grade": 1}], "owner": 1} 10 110 408 n/a 1789 178.9 None DB3昨日KX慢日志累计数: 0 /var/log/mlog/db3/kx/20220407-slow.log DB3 KX慢数据计数:0 慢数据前二十: