What makes MySQL LRU cache scan resistant
Ref:
- https://medium.com/@arpitbhayani/what-makes-mysql-lru-cache-scan-resistant-a73364f286d7
- https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool.html
- https://arpit.substack.com/p/2q-cache-management-algorithm
Linux Page cache reclaim
TODO Read this blog completely https://biriukov.dev/docs/page-cache/4-page-cache-eviction-and-page-reclaim/
Also about shadow entries and refaulting distance https://github.com/torvalds/linux/blob/master/mm/workingset.c