EmergencyEMERGENCY? Get 24/7 Help Now!

How rows_sent can be more than rows_examined?

 | February 28, 2014 |  Posted In: Insight for DBAs, MySQL

When looking at queries that are candidates for optimization I often recommend that people look at rows_sent and rows_examined values as available in the slow query log (as well as some other places). If rows_examined is by far larger than rows_sent, say 100 larger, then the query is a great candidate for optimization. Optimization could […]

Read More