DB1昨日ARS慢日志累计数: 0 /var/log/mlog/db1/ars/20220326-slow.log DB1 ARS慢数据计数:0 慢数据前二十: DB1昨日DSSX慢日志累计数: 0 /var/log/mlog/db1/dssx/20220326-slow.log DB1 DSSX慢数据计数:0 慢数据前二十: DB1昨日KX慢日志累计数: 0 /var/log/mlog/db1/kx/20220326-slow.log DB1 KX慢数据计数:0 慢数据前二十: +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ DB2昨日ARS慢日志累计数: 2000 /var/log/mlog/db2/ars/20220326-slow.log DB2 ARS慢数据计数:12 慢数据前二十:namespace operation pattern count min (ms) max (ms) 95%-ile (ms) sum (ms) mean (ms) allowDiskUse dyf_ars.ars_action aggregate None 759 102 48519 n/a 997634 1314.4 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}]} 411 143 290 n/a 78404 190.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}]} 252 166 283 n/a 53248 211.3 None dyf_ars.ars_action_pv findandmodify {"cid": [{"used": 1, "val": 1}], "target": [{"used": 1, "val": 1}], "token": [{"used": 1, "val": 1}]} 219 154 369 n/a 45396 207.3 None dyf_ars.ars_action_pv findandmodify {"cid": [{"used": 1, "val": 1}], "target": [{"used": 1, "val": 1}]} 173 158 782 n/a 34399 198.8 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}]} 135 158 244 n/a 26345 195.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}]} 43 169 228 n/a 8954 208.2 None dyf_ars.ars_action_pv findandmodify {"sign": [{"used": 1, "val": 1}], "url": [{"used": 1, "val": 1}]} 4 122 134 n/a 510 127.5 None dyf_ars.ars_action_pv findandmodify {"code": [{"used": 1, "val": 1}], "state": [{"used": 1, "val": 1}]} 1 403 403 n/a 403 403.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 168 168 n/a 168 168.0 None dyf_ars.ars_learn_rate find {"aid": 1, "uid": 1} 1 127 127 n/a 127 127.0 None dyf_ars.ars_action_pv findandmodify None 1 126 126 n/a 126 126.0 None DB2昨日DSSX慢日志累计数: 0 /var/log/mlog/db2/dssx/20220326-slow.log DB2 DSSX慢数据计数:0 慢数据前二十: DB2昨日KX慢日志累计数: 8430 /var/log/mlog/db2/kx/20220326-slow.log DB2 KX慢数据计数:51 慢数据前二十:namespace operation pattern count min (ms) max (ms) 95%-ile (ms) sum (ms) mean (ms) allowDiskUse dyf_dssx_exam.dssx_count_info find {"plugin": 1, "result": 1, "status": 1} 722 269 743 n/a 372689 516.2 None dyf_cny.user aggregate None 1883 101 2941 n/a 328682 174.6 None dyf_cny.tag_search aggregate None 2389 101 149 n/a 272799 114.2 None dyf_cny.count_warning find {"attrs.im.over24": 1, "handTime": 1, "handWay": 1, "status": 1, "tid": {"$ne": 1}} 192 684 1091 n/a 157886 822.3 None dyf_dssx_exam.dssx_count_info update {"finish": 1, "plugin": 1, "status": 1} 363 226 334 n/a 94436 260.2 None dyf_dssx_b2bkz.dssx_count_info find {"plugin": 1, "result": 1, "status": 1} 361 129 326 n/a 86436 239.4 None dyf_cny.c_f find {"ALYKey": 1, "status": 1} 64 111 2435 n/a 81422 1272.2 None dyf_cny.course_character aggregate None 311 101 1232 n/a 80306 258.2 None dyf_dssx_kjdsb2b.dssx_count_info find {"plugin": 1, "result": 1, "status": 1} 353 103 235 n/a 61768 175.0 None dyf_cny.es_exam aggregate None 103 101 3103 n/a 54111 525.3 None dyf_dssx_b2bkz.dssx_count_info update {"finish": 1, "plugin": 1, "status": 1} 360 101 176 n/a 47046 130.7 None dyf_cny.count_cs aggregate None 21 244 3999 n/a 33114 1576.9 None dyf_cny.es_exam find {"answers.answer.ctime": 1} 4 6730 9330 n/a 30137 7534.2 None dyf_cny.count_u_per aggregate None 14 344 2516 n/a 26649 1903.5 None dyf_cny.count_course aggregate None 1 24352 24352 n/a 24352 24352.0 None dyf_cny.count_msg_info aggregate None 21 147 1350 n/a 18401 876.2 None dyf_cny.uas_group find {"_id": 1, "status": 1, "type": 1} 45 153 234 n/a 9276 206.1 None dyf_cny.c_f update {"ALYKey": 1} 5 1274 2641 n/a 8638 1727.6 None dyf_cny.count_course findandmodify {"_id": 1} 26 131 833 n/a 7552 290.5 None dyf_dssx_kjdsb2b.dssx_count_info update {"finish": 1, "plugin": 1, "status": 1} 60 101 124 n/a 6282 104.7 None +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ DB3昨日ARS慢日志累计数: 0 /var/log/mlog/db3/ars/20220326-slow.log DB3 ARS慢数据计数:0 慢数据前二十: DB3昨日DSSX慢日志累计数: 2984 /var/log/mlog/db3/dssx/20220326-slow.log DB3 DSSX慢数据计数:23 慢数据前二十:namespace operation pattern count min (ms) max (ms) 95%-ile (ms) sum (ms) mean (ms) allowDiskUse dyf_dssx.dssx_shipping_template aggregate None 884 5771 9284 n/a 5916688 6693.1 None dyf_dssx.dssx_p4p_key aggregate None 288 1456 2444 n/a 493305 1712.9 None dyf_dssx.dssx_st_product count {"uid": 1} 884 182 674 n/a 216731 245.2 None dyf_dssx.dssx_product aggregate None 164 101 4550 n/a 180037 1097.8 None dyf_dssx.dssx_count_info find {"plugin": 1, "result": 1, "status": 1} 288 206 405 n/a 70590 245.1 None dyf_dssx.dssx_p4p_key find {"groupIdList": {"$elemMatch": 1}, "uidKey": 1} 38 1158 1756 n/a 50051 1317.1 None dyf_dssx.dssx_product count {"$or": [{"keyword": {"$elemMatch": {"$options": 1, "$regex": 1}}}, {"productName": {"$options": 1, "$regex": 1}}], "putaway": 1, "visibility": 1} 15 2557 3639 n/a 43590 2906.0 None dyf_dssx.dssx_product find {"layeredCate.1": 1, "layeredCate.2": 1, "putaway": 1, "visibility": 1} 142 102 756 n/a 28493 200.7 None dyf_dssx.dssx_p4p_account find {"_id": 1} 72 269 367 n/a 21868 303.7 None dyf_dssx.dssx_product count {"category": {"$regex": 1}, "putaway": 1, "visibility": 1} 8 2240 3266 n/a 21514 2689.2 None dyf_dssx.dssx_p4p_rank_result aggregate None 34 209 1980 n/a 18892 555.6 None dyf_dssx.dssx_p4p_key_info find {"create": 1, "grade": 1} 24 527 698 n/a 14296 595.7 None dyf_dssx.dssx_product find {"category": {"$regex": 1}, "putaway": 1, "visibility": 1} 6 846 3605 n/a 14269 2378.2 None dyf_dssx.dssx_product find {"$or": [{"keyword": {"$elemMatch": {"$options": 1, "$regex": 1}}}, {"productName": {"$options": 1, "$regex": 1}}], "putaway": 1, "visibility": 1} 15 226 1515 n/a 10755 717.0 None dyf_dssx.dssx_pop_store find {"publishTmpl": {"$ne": 1}} 72 101 190 n/a 8789 122.1 None dyf_dssx.dssx_pop_store count {"publishTmpl": {"$ne": 1}} 24 140 376 n/a 4541 189.2 None dyf_dssx.dssx_cache_logistics_solution find {"cond.destinationCountry": 1, "cond.originZip": 1, "cond.packageInfo": 1, "cond.serviceType": 1, "serviceType": 1} 2 632 1088 n/a 1720 860.0 None dyf_dssx.dssx_p4p_rank_result update {"kid": 1} 2 346 373 n/a 719 359.5 None dyf_dssx.dssx_product_update_record count {"attr.action": 1, "pid": 1} 2 232 278 n/a 510 255.0 None dyf_dssx.dssx_product_update_record find {"attr.action": 1, "pid": 1} 2 178 206 n/a 384 192.0 None DB3昨日KX慢日志累计数: 4 /var/log/mlog/db3/kx/20220326-slow.log DB3 KX慢数据计数:0 慢数据前二十: