What Ive been really looking for is a way to run SQL queries against MySQL 8.0 Inno DB without them hitting the cache.

Its tricky to validate improvements real time but I guess validating in prod is good too