DB1昨日ARS慢日志累计数: 0 /var/log/mlog/db1/ars/20220406-slow.log DB1 ARS慢数据计数:0 慢数据前二十: DB1昨日DSSX慢日志累计数: 0 /var/log/mlog/db1/dssx/20220406-slow.log DB1 DSSX慢数据计数:0 慢数据前二十: DB1昨日KX慢日志累计数: 25115 /var/log/mlog/db1/kx/20220406-slow.log DB1 KX慢数据计数:64 慢数据前二十:namespace operation pattern count min (ms) max (ms) 95%-ile (ms) sum (ms) mean (ms) allowDiskUse dyf_cny.count_course aggregate None 10756 101 954 n/a 1848749 171.9 None dyf_cny.tag_search aggregate None 8096 101 170 n/a 927973 114.6 None dyf_dssx_exam.dssx_count_info find {"plugin": 1, "result": 1, "status": 1} 718 279 727 n/a 375159 522.5 None dyf_cny.user aggregate None 1880 101 3349 n/a 338608 180.1 None dyf_cny.count_cs aggregate None 92 161 18115 n/a 155886 1694.4 None dyf_cny.count_warning find {"attrs.im.over24": 1, "handTime": 1, "handWay": 1, "status": 1, "tid": {"$ne": 1}} 134 759 1098 n/a 111254 830.3 None dyf_dssx_exam.dssx_count_info update {"finish": 1, "plugin": 1, "status": 1} 361 189 365 n/a 94391 261.5 None dyf_dssx_b2bkz.dssx_count_info find {"plugin": 1, "result": 1, "status": 1} 360 129 342 n/a 88447 245.7 None dyf_cny.course_character aggregate None 315 101 1216 n/a 81132 257.6 None dyf_cny.c_f find {"ALYKey": 1, "status": 1} 67 112 1841 n/a 76241 1137.9 None dyf_cny.count_u_per aggregate None 40 276 2765 n/a 63832 1595.8 None dyf_dssx_kjdsb2b.dssx_count_info find {"plugin": 1, "result": 1, "status": 1} 343 102 239 n/a 61970 180.7 None dyf_cny.count_msg_info aggregate None 91 107 1611 n/a 60580 665.7 None dyf_dssx_b2bkz.dssx_count_info update {"finish": 1, "plugin": 1, "status": 1} 359 102 196 n/a 46689 130.1 None dyf_cny.es_exam aggregate None 42 102 3576 n/a 44223 1052.9 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} 8 4575 5775 n/a 40366 5045.8 None dyf_cny.es_exam find {"answers.answer.ctime": 1} 5 5850 9902 n/a 34770 6954.0 None dyf_cny.c_f update {"ALYKey": 1} 25 805 3109 n/a 33237 1329.5 None dyf_cny.uas_group find {"_id": 1, "status": 1, "type": 1} 113 167 266 n/a 25594 226.5 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} 7 2828 3610 n/a 22058 3151.1 None +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ DB2昨日ARS慢日志累计数: 6576 /var/log/mlog/db2/ars/20220406-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_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}]} 2431 151 433 n/a 522563 215.0 None dyf_ars.ars_action aggregate None 887 101 50640 n/a 513081 578.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}]} 1041 158 467 n/a 255554 245.5 None dyf_ars.ars_action_pv findandmodify {"cid": [{"used": 1, "val": 1}], "target": [{"used": 1, "val": 1}], "token": [{"used": 1, "val": 1}]} 876 178 1245 n/a 207710 237.1 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}]} 688 162 446 n/a 152324 221.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}]} 251 177 302 n/a 57910 230.7 None dyf_ars.ars_action_pv findandmodify {"cid": [{"used": 1, "val": 1}], "target": [{"used": 1, "val": 1}]} 230 190 695 n/a 51887 225.6 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 130 n/a 10906 106.9 None dyf_ars.ars_action_pv findandmodify {"sign": [{"used": 1, "val": 1}], "url": [{"used": 1, "val": 1}]} 49 119 165 n/a 6598 134.7 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}]} 8 213 250 n/a 1811 226.4 None dyf_ars.ars_action_pv findandmodify {"code": [{"used": 1, "val": 1}], "state": [{"used": 1, "val": 1}]} 2 108 757 n/a 865 432.5 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}]} 2 229 246 n/a 475 237.5 None dyf_ars.ars_action_pv findandmodify None 2 160 181 n/a 341 170.5 None dyf_ars.ars_action_pv findandmodify {"ka78597247?token": [{"used": 1, "val": 1}]} 1 258 258 n/a 258 258.0 None dyf_ars.ars_learn_rate find {"aid": 1, "uid": 1} 2 110 141 n/a 251 125.5 None DB2昨日DSSX慢日志累计数: 0 /var/log/mlog/db2/dssx/20220406-slow.log DB2 DSSX慢数据计数:0 慢数据前二十: DB2昨日KX慢日志累计数: 0 /var/log/mlog/db2/kx/20220406-slow.log DB2 KX慢数据计数:0 慢数据前二十: +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ DB3昨日ARS慢日志累计数: 0 /var/log/mlog/db3/ars/20220406-slow.log DB3 ARS慢数据计数:0 慢数据前二十: DB3昨日DSSX慢日志累计数: 9055 /var/log/mlog/db3/dssx/20220406-slow.log DB3 DSSX慢数据计数:31 慢数据前二十:namespace operation pattern count min (ms) max (ms) 95%-ile (ms) sum (ms) mean (ms) allowDiskUse dyf_dssx.dssx_shipping_template aggregate None 3627 6135 16894 n/a 28329190 7810.6 None dyf_dssx.dssx_st_product count {"uid": 1} 3627 178 788 n/a 951741 262.4 None dyf_dssx.dssx_p4p_key aggregate None 287 1386 4617 n/a 472390 1646.0 None dyf_dssx.dssx_p4p_key find {"groupIdList": {"$elemMatch": 1}, "uidKey": 1} 281 1174 2283 n/a 400396 1424.9 None dyf_dssx.dssx_product aggregate None 222 101 5565 n/a 223986 1008.9 None dyf_dssx.dssx_product count {"$or": [{"keyword": {"$elemMatch": {"$options": 1, "$regex": 1}}}, {"productName": {"$options": 1, "$regex": 1}}], "putaway": 1, "visibility": 1} 50 2472 4951 n/a 169849 3397.0 None dyf_dssx.dssx_count_info find {"plugin": 1, "result": 1, "status": 1} 288 199 452 n/a 70977 246.4 None dyf_dssx.dssx_p4p_rank_result aggregate None 110 213 2478 n/a 51256 466.0 None dyf_dssx.dssx_product find {"$or": [{"keyword": {"$elemMatch": {"$options": 1, "$regex": 1}}}, {"productName": {"$options": 1, "$regex": 1}}], "putaway": 1, "visibility": 1} 50 177 3713 n/a 39813 796.3 None dyf_dssx.dssx_product find {"layeredCate.1": 1, "layeredCate.2": 1, "putaway": 1, "visibility": 1} 174 101 461 n/a 28679 164.8 None dyf_dssx.dssx_p4p_account find {"_id": 1} 82 270 493 n/a 25953 316.5 None dyf_dssx.dssx_p4p_key_info find {"create": 1, "grade": 1} 24 575 818 n/a 15686 653.6 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} 4 2652 3493 n/a 12878 3219.5 None dyf_dssx.dssx_pop_store find {"publishTmpl": {"$ne": 1}} 71 101 291 n/a 9056 127.5 None dyf_dssx.dssx_p4p_key_high_score findandmodify {"key": 1, "owner": 1} 43 101 159 n/a 5709 132.8 None dyf_dssx.dssx_pop_store count {"publishTmpl": {"$ne": 1}} 24 156 311 n/a 4972 207.2 None dyf_dssx.dssx_product count {"category": {"$regex": 1}, "putaway": 1, "visibility": 1} 1 3084 3084 n/a 3084 3084.0 None dyf_dssx.dssx_p4p_rank_result update {"kid": 1} 6 358 647 n/a 2576 429.3 None dyf_dssx.dssx_product_update_record count {"attr.action": 1, "pid": 1} 9 222 277 n/a 2273 252.6 None dyf_dssx.dssx_product_update_record find {"attr.action": 1, "pid": 1} 9 163 248 n/a 1951 216.8 None DB3昨日KX慢日志累计数: 0 /var/log/mlog/db3/kx/20220406-slow.log DB3 KX慢数据计数:0 慢数据前二十: