Uploaded image for project: 'WiredTiger'
  1. WiredTiger
  2. WT-9309

WT perf data in Atlas Charts needs partitioning

    • Type: Icon: Improvement Improvement
    • Resolution: Duplicate
    • Priority: Icon: Minor - P4 Minor - P4
    • None
    • Affects Version/s: None
    • Component/s: None
    • Labels:
    • 8
    • Storage Engines - 2022-09-05

      Summary
      Atlas Charts is sending us "Query Targeting: Scanned Objects / Returned has gone above 1000" warnings indicating we're performing inefficient queries on our perf data.
      This is because currently all Atlas perf data is stored in a single collection, but each chart only wants a subset of that data which applies to a specific test.

      To fix this we should restructure the DB such that each test has its own collection, or index on test names to avoid needless search.

       

      Motivation

      • Does this affect any team outside of WT?
        No
      • How likely is it that this use case or problem will occur?
        This will happen on every commit moving forward.
      • If the problem does occur, what are the consequences and how severe are they?
        The queries are inefficient, but the DB is still small enough that this is not expensive or overly slow. The main problem is email spam sent to Chart admins.
      • Is this issue urgent?
        No.

      Acceptance Criteria (Definition of Done)

      Atlas Charts no longer sends warning emails about inefficient queries.{}

            Assignee:
            backlog-server-storage-engines [DO NOT USE] Backlog - Storage Engines Team
            Reporter:
            andrew.morton@mongodb.com Andrew Morton
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: