-
Type: Improvement
-
Resolution: Unresolved
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: Configuration
-
Storage Engines
-
Megabat - 2024-05-14
We tried to remove the MongoDB cursor caching layer in SERVER-82970, but we found regressions caused by extra overhead in the WiredTiger cursor caching layer.
The main sources of overhead seem to come from two places:
- Config string parsing
- Having to close and re-open the actual dhandle. In the MongoDB layer, we just call reset() when caching a cursor, which does not appear to incur the same overhead.
In the mixed_multi_deletes_batched workload, this is the time spent constructing a WiredTigerCursor:
- Before: 3.0%
- After: 6.6%
And this is zoomed into the unindex path:
Before:
After:
- is related to
-
SERVER-89811 Evaluate setting wiredTigerCursorCacheSize to 100
- Closed
-
SERVER-90638 WiredTigerCursor speedups
- Closed
- related to
-
SERVER-82970 Remove cursor cache from server as WiredTiger already caches cursor
- Backlog
-
WT-12567 Add configuration compilation to WT_SESSION.open_cursor
- In Progress