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

show databases taking extraordinarily long with wiredTiger

XMLWordPrintableJSON

    • 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
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None

      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

            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: