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

Add option to listDatabases to only get db names, not size info

    XMLWordPrintable

Details

    • Improvement
    • Status: Closed
    • Major - P3
    • Resolution: Fixed
    • None
    • 3.2.13, 3.4.3, 3.5.4
    • Storage
    • Linux yq131 2.6.18-164.el5 #1 SMP Thu Sep 3 03:28:30 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux
      ext4 filesystem
    • Fully Compatible
    • v3.4, v3.2
    • Storage 2017-03-06

    Description

      I have about 29377 files (including datafile and nsfile), 13666 databases. The total size is about 1TB. The mongod started with parameters "smallfiles" and "noprealloc".
      When I run the command listDatabases, it takes too long on calculating "sizeOnDisk" and determining the empty of database, more than a hour sometimes. But I just need a list of database names. An option to not display size or empty probably makes sense.
      I found that mongod will receive the listDatabases command in the following cases:
      1. Dump all databases use mongodump
      2. A Member of replica set doing initialSync
      3. Add a new shard to a cluster.
      In these cases, listDatabases may cause mongod overload and can not do the normal queries.

      Attachments

        Issue Links

          is depended on by

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-28924 Change databasesCloner to use the "nameOnly" version of listDatabases

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

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-28925 Use listDatabases({'nameOnly': true}) in the addShard implementation

          • Major - P3 - Major loss of function.
          • Closed
          is documented by

          Task - A task that needs to be done. DOCS-10011 Need to document namesOnly option for listDatabases

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

          Improvement - An improvement or enhancement to an existing feature or task. DOCS-10213 MongoDB 3.4 manual doesn't note `versionadded` for listDatabases' nameOnly option

          • Major - P3 - Major loss of function.
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. SERVER-24948 initial sync failed because listDatabases exceeded 30s socket (read) timeout

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

          Bug - A problem which impairs or prevents the functions of the product. SERVER-27666 listDatabases performance issue w/ replicasets & wiredTiger

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

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-21066 Investigate listDatabases option to return only dbnames and skip sizes

          • Minor - P4 - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          is related to

          Task - A task that needs to be done. TOOLS-1653 use the new higher performance listDatabases() in mongodump, et. al.

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

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-6898 Allow all authenticated users to run listDatabases

          • Minor - P4 - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-21067 Investigate having the storage size of a given collection/index/database cached within the WT/KV api

          • Minor - P4 - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          related to

          Bug - A problem which impairs or prevents the functions of the product. DOCS-11104 Comment on: "manual/reference/command/listDatabases"

          • Closed

          Bug - A problem which impairs or prevents the functions of the product. SERVER-11051 listDatabases command reports existence of databases that have never been written to.

          • Minor - P4 - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            People

              geert.bosch@mongodb.com Geert Bosch
              elmerzhang Lei Zhang
              Votes:
              10 Vote for this issue
              Watchers:
              27 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: