PriorityqueueoptimizationforfilesortisnowvisibleinM_MySQL:TL;DR:Priority queue optimization for filesort with small LIMIT is now visible in MariaDB: there is a status variable and you can also see it in the slow query log (KB page link).A longer variant:One of the new optimizations in MySQL 5.6 is