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

Investigate changepoints in bestbuy_4_analytics

    XMLWordPrintableJSON

Details

    • Icon: Task Task
    • Resolution: Fixed
    • Icon: Major - P3 Major - P3
    • 6.3.0-rc0
    • None
    • None
    • Fully Compatible
    • QE 2022-11-28, QE 2022-12-12

    Description

      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 

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: