It is handled by W-TinyLFU where I use this scenario as a stress test [1]. While LIRS / LIRS2 did not pass this one scenario, the quality of the work behind that policy leads me to believe it could be improved to handle that case.
[1] https://github.com/ben-manes/caffeine/wiki/Efficiency#adapti...
Also remember that many DBs are multi-user so any access patterns from each connection will get thrown in the same bucket.