[SERVER-75714] Investigate refactor of TemporaryRecordStore Created: 05/Apr/23  Updated: 12/Apr/23

Status: Backlog
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Improvement Priority: Major - P3
Reporter: Jordi Olivares Provencio Assignee: Backlog - Storage Execution Team
Resolution: Unresolved Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
Related
is related to WT-10843 Improved support for transient tables Open
is related to SERVER-74085 Ensure queries that spill to Temporar... Backlog
is related to SERVER-74033 Remove ident force drop in favour of ... Closed
Assigned Teams:
Storage Execution
Participants:
Linked BF Score: 120

 Description   

After discussing with the Storage Engine team about WT-10843 we discovered that a potential short-term fix for the slowdown caused by SERVER-74033 would be to:

  • Maintain a completely separate WT_CONNECTION for Temporary Record Stores
  • Tune the connection so the cache quota is minimal to avoid noisy neighbor issues
  • Tune the tables/connection to disregard any sort of durability requirements

The latter would require us to fully recreate the WT directory at every startup for these collections.


Generated at Thu Feb 08 06:30:52 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.