Mariadb & MySQL :: MySQL 5.7 Reference Manual :: 8.2.1.17 LIMIT Query Optimization

MySQL :: MySQL 5.7 Reference Manual :: 8.2.1.17 LIMIT Query Optimization
https://dev.mysql.com/doc/refman/5.7/en/limit-optimization.html

MySQL 用 limit 分页为什么会影响性能？ - 云+社区 - 腾讯云
https://cloud.tencent.com/developer/article/1540076

坑，MySQL中 order by 与 limit 混用，分页有BUG！ - Python社区
http://www.python88.com/topic/107397

Mariadb学习总结（六）：索引 | 《Linux就该这么学》
https://www.linuxprobe.com/mariadb-study-index.html

SPATIAL INDEX - MariaDB Knowledge Base
https://mariadb.com/kb/en/spatial-index/