Uploaded image for project: 'WiredTiger'
  1. WiredTiger
  2. WT-5995

Need a means by which to detect WT cache pressure in MongoDB v4.2

    • Type: Icon: Task Task
    • Resolution: Incomplete
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • None

      In WT-5124, we clarified that the WT lookaside score cannot be used as a reliable cache pressure indicator because its value can sky-rocket while 1% of the cache is full.

      I have heard tell that the lookaside table inserts metric also is an unreliable indicator of cache pressure because inserts can occur long before cache pressure rises high, and the number of inserts can decrease (become infrequent) while cache pressure remains high. I had originally thought to use frequency of inserts as a cache pressure indicator.

      1. Could someone confirm that the lookaside table insert metric is not a satisfactory indicator of WT cache pressure?
      2. Additionally, could someone explore whether there are any reliable metrics MongoDB could use?

      milkie, if no metric can be found, the only alternative I can think of is for MongoDB to maintain a statically sized time window between stable_timestamp and oldest_timestamp, to support sharded transaction PIT reads. It would not react to cache pressure changes. Set a default window size, and allow users to modify the value via a run-time adjustable server parameter.

            Assignee:
            dianna.hohensee@mongodb.com Dianna Hohensee (Inactive)
            Reporter:
            dianna.hohensee@mongodb.com Dianna Hohensee (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: