Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-71542

Investigate changepoints in bestbuy_4_analytics

    • Type: Icon: Task Task
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 6.3.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • Fully Compatible
    • QE 2022-11-28, QE 2022-12-12

      Performance improved drastically (up to 50,000x) on several tests in bestbuy_4_analytics due to a change sometime between Nov 16th and 18th. Most likely causes are: SERVER-70617 and SERVER-70972.  Note that these are collection scan tests without any indexes defined at all.

      The results have been reproduced several times in evergreen, as you can see in the trend charts here: https://spruce.mongodb.com/version/637bb59cc9ec4412eb36da6a/tasks?sorts=STATUS%3AASC%3BBASE_STATUS%3ADESC

      Query MQL is listed here: https://github.com/10gen/workloads/blob/master/workloads/bestbuy_analytics.js 

            Assignee:
            steve.tarzia@mongodb.com Steve Tarzia
            Reporter:
            steve.tarzia@mongodb.com Steve Tarzia
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: