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)

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

      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?

        1. mongo_stuck.log
          190 kB
          Doanh Ngô Văn
        2. mongo_stuck2.log
          82 kB
          Doanh Ngô Văn
        3. mongo_stuck3.log
          108 kB
          Doanh Ngô Văn

            Assignee:
            daniel.hatcher@mongodb.com Danny Hatcher (Inactive)
            Reporter:
            developer.doanhngo@gmail.com Doanh Ngô Văn
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated:
              Resolved: