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

Tune lookaside sweep to react to workload

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 3.6.6, 4.0.0-rc0, WT3.1.0
    • Component/s: None
    • Labels:
      None
    • Case:
    • Sprint:
      Storage Non-NYC 2018-04-09, Storage Non-NYC 2018-04-23, Storage Non-NYC 2018-05-07

      Description

      In WT-3766, Bruce Lucas commented:

      I ran an insert workload and induced some replica set lag to create cache pressure. In about 5 minutes of running it generated about 2 billion lookaside table entries, for a LAS file size of about 1.2. GB (highly compressible data; would be much larger for more typical data).

      In 3.6.3 I can see 10 k lookaside table removes every 10 seconds - is that the expected effect of this change? At that rate it will take about 3 weeks to get rid of the lookaside table entries that took 5 minutes to generate, so I'm wondering about the efficacy of this; maybe it needs some tuning?

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              sue.loverso Susan LoVerso
              Reporter:
              michael.cahill Michael Cahill
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: