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

listCollections command should not be O(n^2) on MMAPv1

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Critical - P2
    • Resolution: Done
    • None
    • 3.0.7, 3.1.9
    • Performance, Storage
    • None
    • Fully Compatible
    • Quint 9 09/18/15

    Description

      Currently it gets the list of namespaces then gets the CollectionOptions for each namespace. The second step involves a table-scan of system.namespaces. Due to SERVER-18622 this happens even if you are only requesting information for a single namespace.

      Instead, the storageEngine API should have a way to get all namespaces and their CollectionOptions in one pass. This should speed up both MMAP and KVCatalog-based engines.

      Attachments

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. SERVER-20336 O(N^2) perf regression in listCollections and similar code paths [BLOCKING Mongo 3.0 Adoption]

          • Blocker - P1 - Blocks development and/or testing work, production could not run.
          • Closed
          related to

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-18622 listCollections command should special-case filtering by name.

          • Major - P3 - Major loss of function.
          • Closed

          Activity

            People

              charlie.swanson@mongodb.com Charlie Swanson
              mathias@mongodb.com Mathias Stearn
              Votes:
              2 Vote for this issue
              Watchers:
              12 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: