-
Type: Improvement
-
Resolution: Unresolved
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
Storage Engines
-
(copied to CRM)
-
StorEng - Refinement Pipeline
Summary
We should re-evaluate the spinlocks added by WT-4571 in _txn_get_snapshot_int. This change results in some worse scaling at high thread levels in some workloads with many readers and writers.
Motivation
Our investigation in SERVER-55030 led us to conclude that the main source of contention in workloads with many readers and writers is the spinlock inside _txn_get_snapshot_int. By adding a short sleep in this loop, we were able to demonstrate improved performance for some workloads.
- is duplicated by
-
WT-8670 Improve snapshot creation performance with high rate of concurrent read/write transactions
- Closed
- is related to
-
WT-2241 Improve performance of transaction ID allocation
- Closed
- related to
-
SERVER-55030 Remove mutexes that serialize secondary and majority read operations
- Closed
-
WT-4571 Explore performance improvement in __wt_txn_id_alloc
- Closed
-
WT-4624 Investigate then weird update-only-btree wtperf behaviour related to diagnostic
- Closed