mysql 性能优化

https://tech.meituan.com/2014/06/30/mysql-index.html

limit 20000 10 加载很慢怎么解决

思路：：采用id排序，通过id来限制范围

https://www.iteye.com/blog/uule-2422189

SELECT * FROM users WHERE uid >=  (SELECT uid FROM users ORDER BY uid limit 20000, 1) limit 0, 10;