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

MongoDB - Chat DB get stuck some time and repeat inifinitely when have to too many collections (800.000)

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Done
    • Affects Version/s: 3.6 Required, 3.6.1
    • Fix Version/s: None
    • Component/s: Performance, WiredTiger
    • Labels:
      None
    • Operating System:
      ALL

      Description

      My DB get stuck some time about 6-10 second and repeat again inifinitely.

      My DB design model:

      • DBName:
        + chatlogextension1
      • Collection names are mongo objectIds represent user ids - 200.000 collections per DB:
        5d21f0b2383cb27bfc908f3b
        5d21f0c2383cb27bfc908f72
        5d21f0dd383cb27bfc908fce
        5d21f0e9383cb27bfc909001
        5d21f10d383cb27bfc9090b1
        5d21f114383cb27bfc9090e1
        5d21f12d383cb27bfc909143
        ...

      And i have about 5 chat DBs: chatlogextension1, chatlogextension2,...chatlogextension5.
      When i query to these chat DBs, chat DB get stuck about per one minutes and repeat.

      • While other DB is not effected.
      • This is my OS Resources:
        + CPU: everage 15%
        + RAM: everage 72% (92/128 GB)
        + Max open files: 1000000 (ulimit -n)

      May MongoDB handle about 800.000 collections or wiretiger  can handle 800.000 files?

        Attachments

        1. mongo_stuck.log
          190 kB
        2. mongo_stuck2.log
          82 kB
        3. mongo_stuck3.log
          108 kB

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: