[SERVER-74115] Investigate "GET_LINKS_LIST_ms", "GET_NODE_ms", and "COUNT_LINK_ms" regressions Created: 16/Feb/23  Updated: 09/May/23

Status: Open
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Task Priority: Major - P3
Reporter: Mihai Andrei Assignee: Backlog - Query Execution
Resolution: Unresolved Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File image-2023-03-15-09-46-28-464.png    
Issue Links:
Duplicate
is duplicated by SERVER-69751 Investigate SBE Linkbench regressions Closed
Assigned Teams:
Query Execution
Sprint: QE 2023-03-06, QE 2023-03-20, QE 2023-04-03, QE 2023-04-17, QE 2023-05-01
Participants:
Story Points: 3

 Description   

db.sbe_perf_latest.aggregate([{ $match: { tags: {$ne: "ignore"}, test: {$in: ["GET_LINKS_LIST_ms", "GET_NODE_ms", "COUNT_LINK_ms"]}} }, {$project: {signed_percent_change_stable: 1, test: 1, signed_z_score_change_stable: 1,  measurement: 1, _id: 0}}, {$sort: {signed_percent_change_stable: 1}}]).pretty()
[
  {
    measurement: 'Latency95thPercentile',
    signed_percent_change_stable: -53.24306410377807,
    signed_z_score_change_stable: -15.421577922756684,
    test: 'GET_LINKS_LIST_ms'
  },
  {
    measurement: 'Latency95thPercentile',
    signed_percent_change_stable: -23.715852029299313,
    signed_z_score_change_stable: -9.167730986469127,
    test: 'GET_NODE_ms'
  },
  {
    measurement: 'Latency95thPercentile',
    signed_percent_change_stable: -20.784040825794463,
    signed_z_score_change_stable: -8.007831780438325,
    test: 'COUNT_LINK_ms'
  },
  {
    measurement: 'Latency50thPercentile',
    signed_percent_change_stable: -12.660028449502164,
    signed_z_score_change_stable: -11.805257022075887,
    test: 'GET_LINKS_LIST_ms'
  }, 



 Comments   
Comment by Mihai Andrei [ 14/Mar/23 ]

alberto.massari@mongodb.com, is this related to https://jira.mongodb.org/browse/SERVER-69774  ? 

Generated at Thu Feb 08 06:26:33 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.