In MySQL 5.6 we made it possible to estimate the number of fetched rows for queries with many equality predicates (e.g., many values in the IN clause). The new way of estimating fetched rows kicks in if the number of equality predicates exceeds the value of eq_range_index_dive_limit, which has a default of 10.
The good thing about the new way of estimating number of rows is that it is faster than the old way (index dives). On the other hand it is also less accurate.
As it happens, we got push back from the community …[Read more...]