DB1昨日ARS慢日志累计数: 0 /var/log/mlog/db1/ars/20220314-slow.log DB1 ARS慢数据计数:0 慢数据前二十: DB1昨日DSSX慢日志累计数: 0 /var/log/mlog/db1/dssx/20220314-slow.log DB1 DSSX慢数据计数:0 慢数据前二十: DB1昨日KX慢日志累计数: 49746 /var/log/mlog/db1/kx/20220314-slow.log DB1 KX慢数据计数:91 慢数据前二十:namespace operation pattern count min (ms) max (ms) 95%-ile (ms) sum (ms) mean (ms) allowDiskUse dyf_cny.course_character aggregate None 16483 101 1380 n/a 5830468 353.7 None dyf_cny.uas_group find {"_id": 1, "status": 1, "type": 1} 8289 129 476 n/a 2460426 296.8 None dyf_cny.course_character find {"cid": 1, "gid": 1} 8979 101 659 n/a 1465650 163.2 None dyf_cny.tag_search aggregate None 8846 101 181 n/a 1047310 118.4 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} 120 1049 18686 n/a 855220 7126.8 None dyf_dssx_exam.dssx_count_info find {"plugin": 1, "result": 1, "status": 1} 722 266 761 n/a 419820 581.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} 120 2449 4353 n/a 354388 2953.2 None dyf_cny.count_cs aggregate None 124 111 16470 n/a 284922 2297.8 None dyf_cny.user count {"$and": [{"attrs.certification": 1, "attrs.certification.status": {"$ne": 1}}], "status": 1} 55 3962 5355 n/a 250463 4553.9 None dyf_cny.user aggregate None 1127 101 18831 n/a 249274 221.2 None dyf_cny.count_warning find {"attrs.im.over24": 1, "handTime": 1, "handWay": 1, "status": 1, "tid": {"$ne": 1}} 192 773 1386 n/a 183147 953.9 None dyf_cny.count_u_per aggregate None 58 272 4128 n/a 123121 2122.8 None dyf_dssx_exam.dssx_count_info update {"finish": 1, "plugin": 1, "status": 1} 363 219 371 n/a 106946 294.6 None dyf_cny.count_msg_info aggregate None 119 112 1767 n/a 94311 792.5 None dyf_dssx_b2bkz.dssx_count_info find {"plugin": 1, "result": 1, "status": 1} 361 111 362 n/a 92711 256.8 None dyf_cny.course_character find {"cid": 1, "gid": 1, "status": 1, "type": 1} 749 101 368 n/a 83530 111.5 None dyf_cny.c_f find {"ALYKey": 1, "status": 1} 60 125 2156 n/a 80755 1345.9 None dyf_dssx_kjdsb2b.dssx_count_info find {"plugin": 1, "result": 1, "status": 1} 341 101 265 n/a 60741 178.1 None dyf_dssx_b2bkz.dssx_count_info update {"finish": 1, "plugin": 1, "status": 1} 360 102 197 n/a 49029 136.2 None dyf_cny.es_exam aggregate None 70 106 5124 n/a 46499 664.3 None +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ DB2昨日ARS慢日志累计数: 6520 /var/log/mlog/db2/ars/20220314-slow.log DB2 ARS慢数据计数:16 慢数据前二十:namespace operation pattern count min (ms) max (ms) 95%-ile (ms) sum (ms) mean (ms) allowDiskUse dyf_ars.ars_action aggregate None 936 101 49902 n/a 419776 448.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}]} 2190 125 437 n/a 388110 177.2 None dyf_ars.ars_action_pv findandmodify {"cid": [{"used": 1, "val": 1}], "target": [{"used": 1, "val": 1}], "token": [{"used": 1, "val": 1}]} 1275 139 353 n/a 223251 175.1 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}]} 1035 128 253 n/a 188343 182.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}]} 305 126 222 n/a 53123 174.2 None dyf_ars.ars_action_pv findandmodify {"cid": [{"used": 1, "val": 1}], "target": [{"used": 1, "val": 1}]} 283 134 777 n/a 49443 174.7 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}]} 187 130 215 n/a 33200 177.5 None dyf_ars.ars_action_pv findandmodify {"sign": [{"used": 1, "val": 1}], "url": [{"used": 1, "val": 1}]} 283 101 134 n/a 32355 114.3 None dyf_ars.ars_action_pv findandmodify {"code": [{"used": 1, "val": 1}], "state": [{"used": 1, "val": 1}]} 1 726 726 n/a 726 726.0 None dyf_ars.ars_action_pv findandmodify {"actId": [{"used": 1, "val": 1}], "sign": [{"used": 1, "val": 1}], "url": [{"used": 1, "val": 1}]} 4 109 115 n/a 445 111.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}]} 2 196 199 n/a 395 197.5 None dyf_ars.ars_action_pv findandmodify None 3 103 166 n/a 377 125.7 None dyf_ars.ars_learn_rate find {"aid": 1, "uid": 1} 2 129 164 n/a 293 146.5 None dyf_ars.ars_action_pv findandmodify {"cacheFile": [{"used": 1, "val": 1}], "s": [{"used": 1, "val": 1}]} 1 283 283 n/a 283 283.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}], "token": [{"used": 1, "val": 1}]} 1 191 191 n/a 191 191.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}], "ownerType": [{"used": 1, "val": 1}], "target": [{"used": 1, "val": 1}], "token": [{"used": 1, "val": 1}], "type": [{"used": 1, "val": 1}]} 1 180 180 n/a 180 180.0 None DB2昨日DSSX慢日志累计数: 0 /var/log/mlog/db2/dssx/20220314-slow.log DB2 DSSX慢数据计数:0 慢数据前二十: DB2昨日KX慢日志累计数: 6 /var/log/mlog/db2/kx/20220314-slow.log DB2 KX慢数据计数:0 慢数据前二十: +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ DB3昨日ARS慢日志累计数: 0 /var/log/mlog/db3/ars/20220314-slow.log DB3 ARS慢数据计数:0 慢数据前二十: DB3昨日DSSX慢日志累计数: 6624 /var/log/mlog/db3/dssx/20220314-slow.log DB3 DSSX慢数据计数:25 慢数据前二十:namespace operation pattern count min (ms) max (ms) 95%-ile (ms) sum (ms) mean (ms) allowDiskUse dyf_dssx.dssx_shipping_template aggregate None 2463 5221 12097 n/a 16191610 6573.9 None dyf_dssx.dssx_st_product count {"uid": 1} 2463 147 725 n/a 514572 208.9 None dyf_dssx.dssx_p4p_key aggregate None 288 1374 2313 n/a 469968 1631.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} 90 1498 4483 n/a 217107 2412.3 None dyf_dssx.dssx_p4p_rank_result aggregate None 314 190 2588 n/a 181576 578.3 None dyf_dssx.dssx_product aggregate None 186 101 3597 n/a 180684 971.4 None dyf_dssx.dssx_product count {"$or": [{"keyword": {"$elemMatch": {"$options": 1, "$regex": 1}}}, {"productName": {"$options": 1, "$regex": 1}}], "putaway": 1, "visibility": 1} 60 1671 3818 n/a 152119 2535.3 None dyf_dssx.dssx_product find {"$or": [{"keyword": {"$elemMatch": {"$options": 1, "$regex": 1}}}, {"productName": {"$options": 1, "$regex": 1}}], "putaway": 1, "visibility": 1} 58 153 2858 n/a 71516 1233.0 None dyf_dssx.dssx_count_info find {"plugin": 1, "result": 1, "status": 1} 288 192 298 n/a 65554 227.6 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} 21 104 2692 n/a 27232 1296.8 None dyf_dssx.dssx_product find {"layeredCate.1": 1, "layeredCate.2": 1, "putaway": 1, "visibility": 1} 122 101 869 n/a 26090 213.9 None dyf_dssx.dssx_p4p_account find {"_id": 1} 85 253 416 n/a 25524 300.3 None dyf_dssx.dssx_p4p_key find {"groupIdList": {"$elemMatch": 1}, "uidKey": 1} 18 1126 1606 n/a 24157 1342.1 None dyf_dssx.dssx_product count {"category": {"$regex": 1}, "putaway": 1, "visibility": 1} 10 1154 3182 n/a 22504 2250.4 None dyf_dssx.dssx_p4p_key_info find {"create": 1, "grade": 1} 24 510 662 n/a 13636 568.2 None dyf_dssx.dssx_product find {"category": {"$regex": 1}, "putaway": 1, "visibility": 1} 5 110 2388 n/a 7200 1440.0 None dyf_dssx.dssx_pop_store find {"publishTmpl": {"$ne": 1}} 47 101 186 n/a 5533 117.7 None dyf_dssx.dssx_pop_store count {"publishTmpl": {"$ne": 1}} 24 114 203 n/a 3745 156.0 None dyf_dssx.dssx_p4p_key_high_score findandmodify {"key": 1, "owner": 1} 15 102 155 n/a 1922 128.1 None dyf_dssx.dssx_cache_logistics_solution find {"cond.destinationCountry": 1, "cond.originZip": 1, "cond.packageInfo": 1, "cond.serviceType": 1, "serviceType": 1} 3 208 894 n/a 1886 628.7 None DB3昨日KX慢日志累计数: 0 /var/log/mlog/db3/kx/20220314-slow.log DB3 KX慢数据计数:0 慢数据前二十: