We are using MySQL 8.0.35, Here we are facing some slow queries in our production, When we checked the explain plan In all slow queries there is an hint “Using MRR”.
So when we execute the same query separately in terminal, Sometimes “Using MRR” is not used and the query executes faster and sometimes “Using MRR” is used and slowed.
So taken Optimizer trace for both scenarios, From there is no clue how MRR optimization is used in the query.
Can someone explain how MRR(Multi Range Read) Optimization is used in an Query with some examples.
New contributor
logavanan logi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.