…worse… const | 1 | Using temporary; Using filesort | | 1 |…is likely to be way slower than LIMIT 0,10. It is true most users will not go further than…filesort. The solution for this problem is ether extending your indexes so MySQL Optimizer does not have to chose between better sort or better lookup or…
Percona's MySQL & InnoDB performance and scalability blog
Percona Webinars
Careers at Percona
- Sales and Marketing Operations Engineer
- Trainer (Worldwide)
- Software Engineer
- Regional Support Sales Representative
- MySQL Consultant (American timezones)
MySQL Training from Percona
- Orlando, USA on Monday, 11 June 2012
- Raleigh, USA on Monday, 18 June 2012
- Boston, USA on Monday, 09 July 2012
- Chicago, USA on Monday, 09 July 2012
- Los Angeles, USA on Monday, 23 July 2012
Copyright © Percona Inc. • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.