-
Type:
Task
-
Resolution: Unresolved
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
None
-
Storage Engines, Storage Engines - Transactions
-
SE Transactions - 2025-12-05, SE Transactions - 2026-01-16, SE Transactions - 2026-01-30, SE Transactions - 2026-02-13
-
8
Currently in the design doc, we implement a hash table with a fixed size derived from the WT cache size. Each bucket in the table is protected by a lock that guards insert, update, and remove operations. Within each bucket, entries are stored in a doubly linked list, with each entry representing a page cache.
The concern is that when multiple entries collide into the same bucket, operations on that bucket will contend on the same lock. Since page read is on a critical path, this level of contention may not be acceptable, especially if the hash table size is not well tuned and collisions become frequent.
This ticket is to implement a POC and run perf tests to verify whether the current page cache hash table design is causing performance degradations, and propose workaround if it does.