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

show databases taking extraordinarily long with wiredTiger

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major - P3
    • Resolution: Fixed
    • 3.0.0-rc6
    • 3.0.5, 3.1.5
    • Performance, WiredTiger
    • None
    • Fully Compatible
    • ALL
    • Hide

      "show databases" or doing a listdatabases command through the api/C#/java/etc.

      Show
      "show databases" or doing a listdatabases command through the api/C#/java/etc.
    • 0

    Description

      Issue Status as of Jul 14, 2015

      ISSUE SUMMARY
      When using the WiredTiger storge engine, methods to collect the size of each database for the output of the show databases operation in the mongo shell are inefficent, particularly with larger numbers of databases, collections, and indexes.

      USER IMPACT
      The show databases operation in the mongo shell can take a long time to return the listing of databases.

      WORKAROUNDS
      None.

      AFFECTED VERSIONS
      MongoDB 3.0.0 through 3.0.4.

      FIX VERSION
      The fix is included in the 3.0.5 production release.

      Original description

      When running the show databases command, with only 20 databases, we're seeing extremely long response times, typically of 60-90 seconds.

      Based on previous conversations, I'm curious if this might be related to checking database sizes and/or stating files.

      > show databases
      		 
      Admin              0.000GB
      		 
      BTest              0.003GB
      		 
      Config             0.000GB
      		 
      Customer-Fox       0.012GB
      		 
      Customer-CBS       0.040GB
      		 
      Customer-NBC       0.004GB
      		 
      Elmah              0.000GB
      		 
      MBTest             0.004GB
      		 
      Master             0.033GB
      		 
      Monitoring         0.021GB
      		 
      OCRM               0.009GB
      		 
      OCarp              0.085GB
      		 
      ODev               0.134GB
      		 
      OP                 0.041GB
      		 
      Provisions         0.002GB
      		 
      Queue              0.009GB
      		 
      local              0.000GB

      Attachments

        Issue Links

          is depended on by

          Bug - A problem which impairs or prevents the functions of the product. WT-1973 MongoDB changes for WiredTiger 2.7.0

          • Major - P3 - Major loss of function.
          • Closed
          is related to

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-25025 Improve startup time when there are tens of thousands of collections/indexes on WiredTiger

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

          Bug - A problem which impairs or prevents the functions of the product. SERVER-16353 listDatabases is very slow on wiredtiger primary

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

          Task - A task that needs to be done. WT-1634 Opening a cursor with many tables is slow

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

          Activity

            People

              michael.cahill@mongodb.com Michael Cahill (Inactive)
              sallgeud Chad Kreimendahl
              Votes:
              3 Vote for this issue
              Watchers:
              24 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: