Re: Select last row that is less than or equal to a date

[Rick James]

EXPLAIN is estimating, based on statistics it gathered. EXPLAIN does not really take into account the LIMIT clause.

The way to check things is:
SHOW SESSION STATUS LIKE 'Handler%';
SELECT ...
SHOW SESSION STATUS LIKE 'Handler%';
Then look at the differences in various Handler counters.

This is clearly the best index for all of those SELECTs:
index PlayerDate ( HistoryPlayer, HistoryDate )