https://www.percona.com/blog/the-mysql-optimizer-the-os-cache-and-sequential-versus-random-io/
The MySQL optimizer, the OS cache, and sequential versus random I/O - Percona
May 4, 2026 - In my post on estimating query completion time, I wrote about how I measured the performance on a join between a few tables in a typical star schema data...
random i omysql optimizer