-
Type:
Improvement
-
Resolution: Unresolved
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: Cache and Eviction
-
Storage Engines
-
StorEng - Refinement Pipeline
When the tree is big and has many internal pages, the eviction server walks the tree, queues only a few leaf pages, and walks many internal pages. This leads to a delay in picking the required leaf pages to reduce the cache pressure.
A couple of suggestions to improve the situation:
- When the tree has many leaf pages in the cache, let the tree walk to return only the leaf pages to improve the eviction server performance to queue the required leaf pages present in the cache.
- Try to evict the internal pages when the tree has many internal pages, irrespective of whether the cache is operating in aggressive mode.
- Queue 5% of targeted pages are internal pages along with leaf pages.
Any other suggestions to improve the situation?