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

Significant delays when large collections are responsible for full WiredTiger cache



    • Type: Bug
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Gone away
    • Affects Version/s: 3.2.7, 3.2.8
    • Fix Version/s: None
    • Component/s: Performance, WiredTiger
    • Labels:
    • Operating System:


      We are unable to recreate this problem in 3.2.5. It appears to have existed since 3.2.7.

      One of our database systems which houses approximately 90 databases, most of which are less than 2GB in size, encounters an extreme degredation in performance when a particularly large collection (12GB) is loaded into the cache. The cacheSizeGB on this system is 32GB.

      The problem only occurs if the WiredTiger cache is full AND the large collection appears loaded into the cache (speculation on the last part). In this scenario, requests that typically take 1ms begin to take 50-500ms, and the slow request log blossoms quickly.

      We can replicate the above scenario by performing a simple query on the large collection when the WiredTiger cache is at or near its cache limit.

      We've also been able to verify that the slowness does not happen when the database is otherwise taxed with a full cache. So we can execute a very long running map/reduce on other data and not impact performance. Only when the giant collections are loaded do we see the issue.


          Issue Links



              • Votes:
                3 Vote for this issue
                19 Start watching this issue


                • Created: