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

show databases taking extraordinarily long with wiredTiger

    • Type: Icon: Bug Bug
    • Resolution: Done
    • Priority: Icon: Major - P3 Major - P3
    • 3.0.5, 3.1.5
    • Affects Version/s: 3.0.0-rc6
    • Component/s: 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

      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
      

        1. Logfile.CSV
          9.32 MB
          Chad Kreimendahl

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

              Created:
              Updated:
              Resolved: