InnoDB Buffer Pool LRU
Midpoint insertion strategy prevents table scans from flushing hot pages
HOT Sublist (5/8)Frequently accessed
empty
empty
empty
empty
empty
empty
empty
empty
empty
empty
← Midpoint
COLD Sublist (3/8)Recently loaded
empty
empty
empty
empty
empty
empty
Pages at the tail of COLD sublist are evicted first (LRU)
Activity Log
No activity yet. Load some pages!
How it works:
- New pages are inserted at the midpoint (head of COLD sublist)
- Pages are promoted to HOT sublist after repeated access
- Table scans only affect the COLD sublist, preserving hot pages
- Eviction happens from the tail of the COLD sublist (true LRU)